orderdetail.cs

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

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

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

		public void Insert(OrderDetailInfo orderdetail)
		{
			object[] parms = {
								Common.GetNextIdByTable("OrderDetailInfo","OrderDetailId","SingleLayer",null,10),
								orderdetail.OrderId,
								orderdetail.Quantity,
								orderdetail.CommodityId
							 };
			DAI.RunProcNonQuery("CRM_OrderDetail_Insert",parms);
		}

		public DataTable GetAllOrderDetail()
		{
			return DAI.RunProcTable("CRM_OrderDetail_AllOrderDetail");
		}

		public OrderDetailInfo GetOrderDetailById(string orderDetailId)
		{
			OrderDetailInfo orderdetail = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_OrderDetail_GetOrderDetailById",orderDetailId))
			{
				if (rdr.Read())
				{
					orderdetail = new OrderDetailInfo();

					orderdetail.OrderDetailId = rdr["OrderDetailId"].ToString();
					orderdetail.OrderId = rdr["OrderId"].ToString();
					orderdetail.Quantity = rdr["Quantity"].ToString();
					orderdetail.CommodityId = rdr["CommodityId"].ToString();
				}
			}
			return orderdetail;
		}

		public DataTable GetOrderDetailByOrderId(string orderId)
		{
			return DAI.RunProcTable("CRM_OrderDetail_GetOrderDetailByOrderId",orderId);;
		}

		#endregion
	}
}