using System;
using CallCenter.DALFactory;
using CallCenter.IDAL;
using CallCenter.Modules;
using System.Collections;
using System.Data;

namespace CallCenter.BusinessLayer
{
	/// <summary>
	/// 系統操作員數據操作類
	/// </summary>
	public class XsxxBLL
	{
		private IXsxx dal = XsxxDAL.Create();
		public XsxxBLL()
		{
			// 
			// TODO: 在此處添加構造函數邏輯
			//
		}

		/// <summary>
		/// 添加商品車入庫信息
		/// </summary>
		/// <param name="info">商品車信息</param>
		/// <returns>
		/// -1出廠編號重復；
		/// 1 添加成功
		/// </returns>
		public int addXsxx(XsxxInfo info)
		{
			try
			{
				return dal.addXsxx(info);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 修改指定商品車信息
		/// </summary>
		/// <param name="info">商品車入庫信息</param>
		/// <returns>
		/// 影響的記錄數
		/// </returns>
		public int updateXsxx(XsxxInfo info)
		{
			try
			{
				return dal.updateXsxx(info);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 刪除指定商品車信息
		/// </summary>
		/// <param name="lnames">以“,”分隔的出廠編號的字符串</param>
		public int delXsxx(string ids)
		{
			try
			{
				return dal.delXsxx(ids);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		/// <summary>
		/// 檢索指定商品車信息
		/// </summary>
		/// <param name="ccbh">出廠編號</param>
		/// <returns>商品車信息</returns>
		public XsxxInfo getXsxxByid(int id)
		{
			try
			{
				return dal.getXsxxByid(id);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		
		public DataSet getALLXsxx_DataSet(string tableName,string idcol)
		{
			try
			{
				return dal.getALLXsxx_DataSet(tableName,idcol);
			}
			catch(Exception e)
			{
				throw e;
			}
		}
		public Decimal getXsxxCount(int year,int imonth,string tablename,string colname)
		{
			try
			{
				return dal.getXsxxCount(year,imonth,tablename,colname);
			}
			catch(Exception e)
			{
				throw e;
			}
		}
		public Decimal getTotalCount(int year,string tablename,string colname)
		{
			try
			{
				return dal.getTotalCount(year,tablename,colname);
			}
			catch(Exception e)
			{
				throw e;
			}
		}
		//		public DataSet getDic_DataSet(string tableName,string id,string name)
		//		{
		//			try
		//			{
		//				return dal.getDic_DataSet(tableName,id,name);
		//			}
		//			catch(Exception e)
		//			{
		//				throw e;
		//			}
		//		}
	}
}