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

namespace CRM.SQLServerDAL
{
	/// <summary>
	/// Order 的摘要說明。
	/// </summary>
	public class Order : IOrder
	{
		#region IOrder 成員

		public DataTable GetAllOrder()
		{
			return DAI.RunProcTable("CRM_Order_GetAllOrder");
		}

		public void Insert(OrderInfo order)
		{
			object[] parms = {
								Common.GetNextIdByTable("OrderInfo","OrderId","SingleLayer",null,10),
								order.CustomerId,
								order.TransType,
								order.Status,
								order.BZ
							 };
			DAI.RunProcNonQuery("CRM_Order_Insert",parms);
		}

		public DataTable GetOrderByCustomerId(string customerId)
		{
			return DAI.RunProcTable("CRM_Order_GetOrderByCustomerId",customerId);
		}

		public OrderInfo GetOrderById(string orderId)
		{
			OrderInfo order = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_Order_GetOrderById",orderId))
			{
				if (rdr.Read())
				{
					order = new OrderInfo();

					order.OrderId = rdr["OrderId"].ToString();
					order.CustomerId = rdr["CustomerId"].ToString();
					order.OrderDate = rdr["OrderDate"].ToString();
					order.TransType = rdr["TransType"].ToString();
					order.Status = rdr["Status"].ToString();
					order.BZ = rdr["BZ"].ToString();
				}
			}
			return order;
		}

		public void Delete(string orderId)
		{
			DAI.RunProcNonQuery("CRM_Order_Delete",orderId);
		}

		public void Update(OrderInfo order)
		{
			object[] parms = {
								 order.OrderId,
								 order.CustomerId,
								 order.TransType,
								 order.Status,
								 order.BZ
							 };
			DAI.RunProcNonQuery("CRM_Order_Update",parms);
		}

		public DataTable GetOrderByUserId(string userid)
		{
			return DAI.RunProcTable("CRM_Order_GetOrderByUserId",userid);
		}
	
		#endregion
	}
}