commodity.cs

某个公司需要维持良好的客户关系

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using CRM.IDAL;
using CRM.Model;

namespace CRM.SQLServerDAL
{
	/// <summary>
	/// Commodity 的摘要说明。
	/// </summary>
	public class Commodity :ICommodity
	{
		#region ICommodity 成员

		public CommodityInfo GetCommodityById(string commodityId)
		{
			CommodityInfo commodity = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Commodity_GetCommodityById",commodityId))
			{
				if (rdr.Read())
				{
					commodity = new CommodityInfo();

					commodity.CommodityId = rdr["CommodityId"].ToString();
					commodity.Name = rdr["Name"].ToString();
					commodity.Price = rdr["Price"].ToString();
					commodity.Discount = rdr["Discount"].ToString();
					commodity.PutOutTime = rdr["PutOutTime"].ToString();
					commodity.Tel = rdr["Tel"].ToString();
					commodity.Company = rdr["Company"].ToString();
					commodity.Country = rdr["Country"].ToString();
					commodity.Province = rdr["Province"].ToString();
					commodity.Address = rdr["Address"].ToString();
					commodity.Quantity = rdr["Quantity"].ToString();
					commodity.BZ = rdr["BZ"].ToString();
				}
			}
			return commodity;
		}

		public void Insert(CommodityInfo commodity)
		{
			object[] parms = {
							    Common.GetNextIdByTable("CommodityInfo","CommodityId","SingleLayer",null,10),
								commodity.Name,
								commodity.Price,
								commodity.Discount,
								commodity.Tel,
								commodity.Company,
								commodity.Country,
								commodity.Province,
								commodity.Address,
								commodity.Quantity,
								commodity.BZ
							 };
			DAI.RunProcNonQuery("CRM_Commodity_Insert",parms);
		}

		public DataTable GetAllCommodity()
		{
			return DAI.RunProcTable("CRM_Commodity_GetAllCommodity");
		}

		public void Delete(string commodityId)
		{
			DAI.RunProcNonQuery("CRM_Commodity_Delete",commodityId);
		}

		public void Update(CommodityInfo commodity)
		{
			object[] parms = {
								commodity.CommodityId,
								commodity.Name,
								commodity.Price,
								commodity.Discount,
								commodity.Tel,
								commodity.Company,
								commodity.Country,
								commodity.Province,
								commodity.Address,
								commodity.Quantity,
								commodity.BZ
							 };
			DAI.RunProcNonQuery("CRM_Commodity_Update",parms);
		}

		#endregion
	}
}