?? order.cs
字號:
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
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -