990 lines
54 KiB
C#
990 lines
54 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using WMS.IData.ICK;
|
||
using System.Data;
|
||
using WMS.Model.CK;
|
||
using WMS.DBUtility;
|
||
|
||
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
||
using WMS.Common;
|
||
|
||
namespace WMS.SqlServerData.CKData
|
||
{
|
||
class OrdersData : IOrders
|
||
{
|
||
/// <summary>
|
||
/// 查询销售订单
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public DataTable InsertOrderData()
|
||
{
|
||
string sqlStr = "select * from [dbo].[OrderDetail] where OrderState='0'";
|
||
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
||
|
||
}
|
||
public DataTable GetOrderInfo(string orderNo)
|
||
{
|
||
string sqlStr = "select * from [dbo].[OrderDetail] where orderNo='"+orderNo+"'";
|
||
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
||
}
|
||
public void UpdataOrderSts(string oderNo)
|
||
{
|
||
string sqlStr = " update OrderDetail set OrderState ='" + 3 + " where OrderNo='" + oderNo + "'";
|
||
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
/// <summary>
|
||
/// 审核 和反审核
|
||
/// </summary>
|
||
/// <param name="orderID"></param>
|
||
public void CheckData(string orderID,string sts)
|
||
{
|
||
string sqlStr = " update T_CG_ORDER set STS ='"+sts+ "',READSTS=0 where CGORDERID='" + orderID+"'";
|
||
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
public void InserRkWareNotce(string orderID)
|
||
{
|
||
string sqlStr = " update T_CG_ORDER set READSTS=1 where CGORDERID='" + orderID + "'";
|
||
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
/// <summary>
|
||
/// 查询采购订单
|
||
/// </summary>
|
||
/// <param name="order"></param>
|
||
/// <returns></returns>
|
||
public DataTable GetTableOrder(CgOrder order)
|
||
{
|
||
string sqlStr =@"select *,a.PROVIDER_NAME from T_CG_ORDER t left join T_BASE_PROVIDER_DICTIONARY a on t.PROVIDER_ID = a.PROVIDER_ID where 1=1";
|
||
if(order!=null)
|
||
{
|
||
if (order.STS != "")
|
||
{
|
||
sqlStr = sqlStr + " and t.sts ='" + order.STS + "'";
|
||
}
|
||
if (order.PROVIDER_ID!="")
|
||
{
|
||
sqlStr = sqlStr + " and t.PROVIDER_ID ='" + order.PROVIDER_ID+"'";
|
||
}
|
||
if (order.READSTS != "")
|
||
{
|
||
sqlStr = sqlStr + " and t.READSTS ='" + order.READSTS + "'";
|
||
}
|
||
if (order.ENDDATE!= DateTime.Parse("1900-01-01"))
|
||
{
|
||
sqlStr = sqlStr + " and t.ENDDATE between convert(date,'" + order.ENDDATE.ToString("yyyy-MM-dd") + "',23) and convert(date,'" + order.LATEDATE.ToString("yyyy-MM-dd") + "',23)";
|
||
}
|
||
|
||
|
||
}
|
||
sqlStr= sqlStr+ " order by CREATE_DATE desc";
|
||
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
||
|
||
}
|
||
public DataTable GetTableOrderInfo(string goodsId)
|
||
{
|
||
string sqlStr =@"select t.GOODS_ID,t.CGNUM,t.DHNUM,t.THNUM,t.CGJG,t.BARCODE,
|
||
(case t.PRINTSTS when '0' then '未打印' when '1' then '已打印' end)PRINTSTS,
|
||
t.STS, a.GOODS_NAME from T_CG_ORDER_INFO t
|
||
left join T_BASE_GOODS a on t.GOODS_ID = a.GOODS_ID
|
||
where t.GOODS_ID = '' where GOODS_ID='"+goodsId+"'";
|
||
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
||
|
||
}
|
||
|
||
/// <summary>
|
||
/// 新增采购明细
|
||
/// </summary>
|
||
/// <param name="orderInfo"></param>
|
||
public void InCgOrderInfo(CgOrderInfo orderInfo)
|
||
{
|
||
string sqlStr = "insert into [dbo].[T_CG_ORDER_INFO]([GOODS_ID]," +
|
||
"[CGNUM],[DHNUM],[THNUM],[CGJG],[BARCODE],[PRINTSTS]," +
|
||
"[PRINTNUM],[CGORDERID],[ORDERID],GOODSENDDATE)values('" + orderInfo.GOODS_ID + "'," +
|
||
" '"+orderInfo.CGNUM+"','"+orderInfo.DHNUM+"','"+orderInfo.THNUM+"'," +
|
||
" '"+orderInfo.CGJG+"','"+orderInfo.BARCODE+"','"+orderInfo.PRINTSTS+"'," +
|
||
" '"+orderInfo.PRINTNUM+"','"+orderInfo.CGORDERID+"'," +
|
||
"'"+orderInfo.ORDERID+"','"+ orderInfo .GOODSENDDATE+ "')";
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
/// <summary>
|
||
/// 新增采购单
|
||
/// </summary>
|
||
/// <param name="order"></param>
|
||
public void InCgorder(CgOrder order)
|
||
{
|
||
string sqlStr = " insert into T_CG_ORDER(CGORDERID,PROVIDER_ID,[ORDERID]," +
|
||
"[EndDate],[LATEDATE],[ORDER_PRICE],[CONTRACTNUM],[ORDER_NOW_PRICE]," +
|
||
"[DISCOUNT],[FINAN_AUDIT_MAN],[AUDIT_MAN],[BGSTS],[PAY_DATE],[PAY_TYPE]," +
|
||
"[REMARK],CREATE_MAN)values('" + order.CGORDERID+"'," +
|
||
"'"+order.PROVIDER_ID+"','"+ order .ORDERID+ "','"+order.ENDDATE+"'," +
|
||
" '"+order.LATEDATE+"','"+order.ORDER_PRICE+"','"+order.CONTRACTNUM+"'," +
|
||
" '"+order.ORDER_NOW_PRICE+"','"+order.DISCOUNT+"','"+order.FINAN_AUDIT_MAN+"'," +
|
||
"' "+order.AUDIT_MAN+"','"+order.BGSTS+"','"+order.PAY_DATE+"'," +
|
||
"'"+order.PAY_TYPE+"','"+order.REMARK+"','"+order.CREATE_MAN+"' )";
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
public void UpdatePlanProvider(string orderId,string providerId)
|
||
{
|
||
string sqlStr = " update T_CG_ORDER_PLAN set" +
|
||
" PROVIDER_ID='"+providerId+ "' where ORDERID='"+ orderId + "' ";
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
/// <summary>
|
||
/// 关闭单据
|
||
/// </summary>
|
||
/// <param name="ORDERID"></param>
|
||
/// <param name="men"></param>
|
||
public void UpdatePlanClose(string ORDERID, string men)
|
||
{
|
||
string sqlStr = " update T_CG_ORDER_PLAN set" +
|
||
" STS ='1',DELMEN='"+men+ "',DELDATE=getdate() where ORDERID='" + ORDERID+"'";
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
}
|
||
/// <summary>
|
||
/// 查询为处理的采购计划
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public DataTable GetOrderPlanData()
|
||
{
|
||
string sqlStr =@"select t.GOODS_ID,t.CGNUM,t.CREATEMEN,t.CREATEDATE,t.ORDERID,a.GOODS_NAME,b.PROVIDER_NAME ,t.PROVIDER_ID,
|
||
(case t.sts when '0' then '未处理' when '1' then '生成采购任务' when '2' then '已关闭' end)sts from T_CG_ORDER_PLAN t left join T_BASE_GOODS a on t.GOODS_ID = a.GOODS_ID left join T_BASE_PROVIDER_DICTIONARY b on t.PROVIDER_ID = b.PROVIDER_ID where t.sts = '0'";
|
||
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
||
|
||
}
|
||
/// <summary>
|
||
/// 增加采购计划
|
||
/// </summary>
|
||
/// <param name="orderData"></param>
|
||
public void AddCgOrderPlan(CgOrderPlan orderData)
|
||
{
|
||
string sqlStr = "insert into T_CG_ORDER_PLAN(GOODS_ID,CGNUM,XQNUM,PROVIDER_ID,FGOODSID,CREATEMEN,ORDERID,TASKID)" +
|
||
"values" +
|
||
"('"+ orderData.GOODS_ID + "','"+ orderData .CGNUM+ "','"+orderData.XQNUM+"'," +
|
||
"'"+orderData.PROVIDER_ID +"','"+orderData.FGOODSID+ "','" + orderData.CREATEMEN + "'," +
|
||
"'"+orderData.ORDERID+"','"+orderData.TASKID+"')";
|
||
SystemDataObject.Instance.ExecuteSql(sqlStr);
|
||
|
||
}
|
||
/// <summary>
|
||
/// 根据时间查询订单数据
|
||
/// </summary>
|
||
/// <param name="benDate"></param>
|
||
/// <param name="endDate"></param>
|
||
/// <returns></returns>
|
||
public DataTable GetOrderDate(string benDate,string endDate)
|
||
{
|
||
string sql =@"select a.order_id, --出库单号
|
||
a.businessorderid, --原业务单号 ERP
|
||
a.shoporderid, --店铺订单号 网店
|
||
a.shopid, --店铺编号
|
||
a.shopname, --店铺名称
|
||
a.log_com_id, --快递公司编号
|
||
j.log_com_name Log_com_name, --快递公司
|
||
a.expressno, --快递单号
|
||
a.cs_operator_man, --客服审核人
|
||
k.Name Cs_operator_man_Name, --客服审核人名称
|
||
a.cs_operator_date, --客审日期
|
||
a.customermemberid, --收货人会员账号
|
||
a.CUS_GUID, --客户GUID
|
||
a.customername, --收货人姓名
|
||
a.customerphone, --收货人联系方式
|
||
a.customerprovince, --收货人所在省
|
||
b.add_Name customerprovince_Name, --收货人所在省名称
|
||
a.customercity, --收货人所在市
|
||
c.add_name customercity_Name, --收货人所在市名称
|
||
a.customerdistrict, --收货人所在区
|
||
d.add_name customerdistrict_Name, --收货人所在区名称
|
||
a.customeraddress, --收货人地址
|
||
a.pay_date, --支付日期
|
||
a.goods_num, --商品数量
|
||
a.goods_price, --标准金额
|
||
a.expressmoney, --快递费用
|
||
a.remark, --收货人备注
|
||
a.status, --确认状态(0=未确认，1=已确认，2=已生成，3=已拣货，-1=关闭,-2=退货)
|
||
a.packingweith, --包裹重量
|
||
a.weighed_man, --称重人
|
||
f.Name weighed_man_Name, --称重人名称
|
||
a.weighed_date, --称重时间
|
||
a.packing_man, --包装人
|
||
g.Name packing_man_Name, --包装人名称
|
||
a.packing_date, --包装时间
|
||
a.storagename, --存放区
|
||
a.ctl_pallet_id, --存放容器编号
|
||
a.create_man, --创建人
|
||
h.Name create_man_Name, --创建人名称
|
||
a.create_date, --订单时间
|
||
a.datasource, --数据来源(0 新增 ，1 线上，2 ERP ，3 导入)
|
||
a.PACKAGINGMATERIALS, --包装材料
|
||
a.MATERIALSCOUNT, --包材数量
|
||
a.STORAGE_ID, --仓库编号
|
||
i.STORAGE_NAME Storage_name, --仓库名称
|
||
a.POSTCOAD, --邮编
|
||
a.WEIGHTING_TOTAL, --称重重量
|
||
a.FINAN_AUDIT_MAN, --财务审核人
|
||
a.FINAN_AUDIT_DATE, --财务审核时间
|
||
a.CUS_MEMBERNAME, --会员名称
|
||
a.ORDER_SOURCE, --订单来源
|
||
a.TELEPHONE, --手机号
|
||
a.PICK_NUM, --已捡货数
|
||
a.PRINTJH, --打印拣货单(0 未打印，1已打印)
|
||
a.PRINTCK, --打印出库单(0 未打印，1已打印)
|
||
a.PRINTKD, --打印快递单(0 未打印，1已打印)
|
||
a.DFSTATUS, --是否为货到付款状态(0 否 ，1 是)
|
||
a.REP_FLAG,
|
||
a.CK_TYPE --出库状态(0 线上出库，1 线下出库，2 调拨出库)
|
||
from t_ck_orders a
|
||
left join t_base_addressarea b on a.customerprovince = b.add_id
|
||
left join t_base_addressarea c on a.customercity = c.add_id
|
||
left join t_base_addressarea d on a.customerdistrict = d.add_id
|
||
left join T_BASE_USERINFO f on a.weighed_man = f.USER_ID
|
||
left join T_BASE_USERINFO g on a.packing_man = g.USER_ID
|
||
left join T_BASE_USERINFO h on a.create_man = h.USER_ID
|
||
left join T_BASE_STORAGEINFO i on a.STORAGE_ID = i.STORAGE_ID
|
||
left join t_Base_Logisticscominfo j on a.LOG_COM_ID = j.log_com_id
|
||
left join T_BASE_USERINFO k on a.cs_operator_man = k.USER_ID
|
||
where FINAN_AUDIT_DATE>=convert(date,'" + benDate + "',23) and FINAN_AUDIT_DATE<=" +
|
||
"convert(date,'" + endDate + "',23) order by a.order_id desc,a.shopname,j.log_com_name,a.datasource,a.status ";
|
||
|
||
|
||
return SystemDataObject.Instance.GetDataTable(sql);
|
||
}
|
||
|
||
|
||
|
||
|
||
/// <summary>
|
||
/// 查询通知单
|
||
/// </summary>
|
||
/// <param name="model">通知单实体</param>
|
||
/// <returns></returns>
|
||
public DataTable GetOrders(OrdersModel model)
|
||
{
|
||
#region 查询语句
|
||
string sql =@"select a.order_id, --出库单号
|
||
a.businessorderid, --原业务单号 ERP
|
||
a.shoporderid, --店铺订单号 网店
|
||
a.shopid, --店铺编号
|
||
a.shopname, --店铺名称
|
||
a.log_com_id, --快递公司编号
|
||
j.log_com_name Log_com_name, --快递公司
|
||
a.expressno, --快递单号
|
||
a.cs_operator_man, --客服审核人
|
||
k.Name Cs_operator_man_Name, --客服审核人名称
|
||
a.cs_operator_date, --客审日期
|
||
a.customermemberid, --收货人会员账号
|
||
a.CUS_GUID, --客户GUID
|
||
a.customername, --收货人姓名
|
||
a.customerphone, --收货人联系方式
|
||
a.customerprovince, --收货人所在省
|
||
b.add_Name customerprovince_Name, --收货人所在省名称
|
||
a.customercity, --收货人所在市
|
||
c.add_name customercity_Name, --收货人所在市名称
|
||
a.customerdistrict, --收货人所在区
|
||
d.add_name customerdistrict_Name, --收货人所在区名称
|
||
a.customeraddress, --收货人地址
|
||
a.pay_date, --支付日期
|
||
a.goods_num, --商品数量
|
||
a.goods_price, --标准金额
|
||
a.expressmoney, --快递费用
|
||
a.remark, --收货人备注
|
||
a.status, --确认状态(0=未确认，1=已确认，2=已生成，3=已拣货，-1=关闭,-2=退货)
|
||
a.packingweith, --包裹重量
|
||
a.weighed_man, --称重人
|
||
f.Name weighed_man_Name, --称重人名称
|
||
a.weighed_date, --称重时间
|
||
a.packing_man, --包装人
|
||
g.Name packing_man_Name, --包装人名称
|
||
a.packing_date, --包装时间
|
||
a.storagename, --存放区
|
||
a.ctl_pallet_id, --存放容器编号
|
||
a.create_man, --创建人
|
||
h.Name create_man_Name, --创建人名称
|
||
a.create_date, --订单时间
|
||
a.datasource, --数据来源(0 新增 ，1 线上，2 ERP ，3 导入)
|
||
a.PACKAGINGMATERIALS, --包装材料
|
||
a.MATERIALSCOUNT, --包材数量
|
||
a.STORAGE_ID, --仓库编号
|
||
i.STORAGE_NAME Storage_name, --仓库名称
|
||
a.POSTCOAD, --邮编
|
||
a.WEIGHTING_TOTAL, --称重重量
|
||
a.FINAN_AUDIT_MAN, --财务审核人
|
||
a.FINAN_AUDIT_DATE, --财务审核时间
|
||
a.CUS_MEMBERNAME, --会员名称
|
||
a.ORDER_SOURCE, --订单来源
|
||
a.TELEPHONE, --手机号
|
||
a.PICK_NUM, --已捡货数
|
||
a.PRINTJH, --打印拣货单(0 未打印，1已打印)
|
||
a.PRINTCK, --打印出库单(0 未打印，1已打印)
|
||
a.PRINTKD, --打印快递单(0 未打印，1已打印)
|
||
a.DFSTATUS, --是否为货到付款状态(0 否 ，1 是)
|
||
a.REP_FLAG,
|
||
a.CK_TYPE --出库状态(0 线上出库，1 线下出库，2 调拨出库)
|
||
from t_ck_orders a
|
||
left join t_base_addressarea b on a.customerprovince = b.add_id
|
||
left join t_base_addressarea c on a.customercity = c.add_id
|
||
left join t_base_addressarea d on a.customerdistrict = d.add_id
|
||
left join T_BASE_USERINFO f on a.weighed_man = f.USER_ID
|
||
left join T_BASE_USERINFO g on a.packing_man = g.USER_ID
|
||
left join T_BASE_USERINFO h on a.create_man = h.USER_ID
|
||
left join T_BASE_STORAGEINFO i on a.STORAGE_ID = i.STORAGE_ID
|
||
left join t_Base_Logisticscominfo j on a.LOG_COM_ID = j.log_com_id
|
||
left join T_BASE_USERINFO k on a.cs_operator_man = k.USER_ID
|
||
where 1=1";
|
||
#endregion
|
||
|
||
|
||
if (!string.IsNullOrEmpty(model.ORDER_ID))
|
||
{
|
||
sql += " and a.order_id = '" + model.ORDER_ID + "'";
|
||
}
|
||
|
||
|
||
if (!string.IsNullOrEmpty(model.BUSINESSORDERID))
|
||
{
|
||
sql += " and a.BUSINESSORDERID = '" + model.BUSINESSORDERID + "'";
|
||
}
|
||
|
||
|
||
if (!string.IsNullOrEmpty(model.DATASOURCE))
|
||
{
|
||
sql += " and a.DATASOURCE = '" + model.DATASOURCE + "'";
|
||
}
|
||
|
||
|
||
if (!string.IsNullOrEmpty(model.STATUS))
|
||
{
|
||
sql += " and a.STATUS ='" + model.STATUS + "'";
|
||
}
|
||
|
||
if (!string.IsNullOrEmpty(model.Order_source))
|
||
|
||
{
|
||
|
||
sql += " and a.Order_source ='" + model.Order_source + "'";
|
||
|
||
}
|
||
|
||
|
||
if (model.CREATE_DATE.Year.ToString()!= "1900")
|
||
{
|
||
|
||
|
||
sql += " and convert(varchar(100),a.CREATE_DATE,23) >= '" + model.CREATE_DATE + "'";
|
||
}
|
||
|
||
if (!string.IsNullOrEmpty(model.EXPRESSNO))
|
||
{
|
||
|
||
sql += " and a.EXPRESSNO = '" + model.EXPRESSNO + "'";
|
||
|
||
}
|
||
|
||
if (model.Ck_type!="")
|
||
{
|
||
sql += " and a.Ck_type = '" + model.Ck_type + "'";
|
||
}
|
||
|
||
sql += " order by a.order_id desc,a.shopname,j.log_com_name,a.datasource,a.status";
|
||
|
||
return SystemDataObject.Instance.GetDataSet(sql).Tables[0];
|
||
}
|
||
|
||
|
||
|
||
#region 新增通知单信息
|
||
/// <summary>
|
||
/// 新增通知单信息
|
||
/// </summary>
|
||
/// <param name="model"></param>
|
||
public void AddOrders(OrdersModel model)
|
||
{
|
||
#region 增加SQL
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("insert into T_CK_ORDERS(");
|
||
strSql.Append("ORDER_ID,BUSINESSORDERID,SHOPORDERID,SHOPID,SHOPNAME,LOG_COM_ID,EXPRESSNO,CS_OPERATOR_MAN,CS_OPERATOR_DATE,CUSTOMERMEMBERID,CUSTOMERNAME,CUSTOMERPHONE,CUSTOMERPROVINCE,CUSTOMERCITY,CUSTOMERDISTRICT,CUSTOMERADDRESS,PAY_DATE,GOODS_NUM,GOODS_PRICE,EXPRESSMONEY,REMARK,STATUS,PACKINGWEITH,WEIGHED_MAN,WEIGHED_DATE,PACKING_MAN,PACKING_DATE,STORAGENAME,CREATE_MAN,DATASOURCE,PACKAGINGMATERIALS,MATERIALSCOUNT,STORAGE_ID,POSTCOAD,FINAN_AUDIT_MAN,FINAN_AUDIT_DATE,WEIGHTING_TOTAL,CUS_MEMBERNAME,ORDER_SOURCE,TELEPHONE,PRINTJH,PRINTKD,PRINTCK,DFSTATUS,CK_TYPE,CUS_GUID");
|
||
strSql.Append(" )values (");
|
||
strSql.Append(":ORDER_ID,:BUSINESSORDERID,:SHOPORDERID,:SHOPID,:SHOPNAME,:LOG_COM_ID,:EXPRESSNO,:CS_OPERATOR_MAN,:CS_OPERATOR_DATE,:CUSTOMERMEMBERID,:CUSTOMERNAME,:CUSTOMERPHONE,:CUSTOMERPROVINCE,:CUSTOMERCITY,:CUSTOMERDISTRICT,:CUSTOMERADDRESS,:PAY_DATE,:GOODS_NUM,:GOODS_PRICE,:EXPRESSMONEY,:REMARK,:STATUS,:PACKINGWEITH,:WEIGHED_MAN,:WEIGHED_DATE,:PACKING_MAN,:PACKING_DATE,:STORAGENAME,:CREATE_MAN,:DATASOURCE,:PACKAGINGMATERIALS,:MATERIALSCOUNT,:STORAGE_ID,:POSTCOAD,:FINAN_AUDIT_MAN,:FINAN_AUDIT_DATE,:WEIGHTING_TOTAL,:CUS_MEMBERNAME,:ORDER_SOURCE,:TELEPHONE,:PRINTJH,:PRINTKD,:PRINTCK,:DFSTATUS,:CK_TYPE,:CUS_GUID)");
|
||
#endregion
|
||
|
||
#region 参数添加
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":BUSINESSORDERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPORDERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":LOG_COM_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":EXPRESSNO",OracleDbType.Varchar2),
|
||
new OracleParameter(":CS_OPERATOR_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":CS_OPERATOR_DATE", OracleDbType.Date),
|
||
new OracleParameter(":CUSTOMERMEMBERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERPHONE",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERPROVINCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERCITY",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERDISTRICT",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERADDRESS",OracleDbType.Varchar2),
|
||
new OracleParameter(":PAY_DATE", OracleDbType.Date),
|
||
new OracleParameter(":GOODS_NUM", OracleDbType.Decimal),
|
||
new OracleParameter(":GOODS_PRICE", OracleDbType.Decimal),
|
||
new OracleParameter(":EXPRESSMONEY", OracleDbType.Decimal),
|
||
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
||
new OracleParameter(":STATUS", OracleDbType.Char),
|
||
new OracleParameter(":PACKINGWEITH", OracleDbType.Decimal),
|
||
new OracleParameter(":WEIGHED_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":WEIGHED_DATE", OracleDbType.Date),
|
||
new OracleParameter(":PACKING_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":PACKING_DATE", OracleDbType.Date),
|
||
new OracleParameter(":STORAGENAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":DATASOURCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":PACKAGINGMATERIALS",OracleDbType.Varchar2),
|
||
new OracleParameter(":MATERIALSCOUNT",OracleDbType.Decimal),
|
||
new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":POSTCOAD",OracleDbType.Varchar2),
|
||
new OracleParameter(":FINAN_AUDIT_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":FINAN_AUDIT_DATE",OracleDbType.Date),
|
||
new OracleParameter(":WEIGHTING_TOTAL",OracleDbType.Decimal),
|
||
new OracleParameter(":CUS_MEMBERNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":ORDER_SOURCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":TELEPHONE",OracleDbType.Varchar2),
|
||
new OracleParameter(":PRINTJH",OracleDbType.Char),
|
||
new OracleParameter(":PRINTKD",OracleDbType.Char),
|
||
new OracleParameter(":PRINTCK",OracleDbType.Char),
|
||
new OracleParameter(":DFSTATUS",OracleDbType.Char),
|
||
new OracleParameter(":CK_TYPE",OracleDbType.Char),
|
||
new OracleParameter(":CUS_GUID",OracleDbType.Varchar2)};
|
||
parameters[0].Value = model.ORDER_ID;
|
||
parameters[1].Value = model.BUSINESSORDERID;
|
||
parameters[2].Value = model.SHOPORDERID;
|
||
parameters[3].Value = model.SHOPID;
|
||
parameters[4].Value = model.SHOPNAME;
|
||
parameters[5].Value = model.LOG_COM_ID;
|
||
parameters[6].Value = model.EXPRESSNO;
|
||
parameters[7].Value = model.CS_OPERATOR_MAN;
|
||
parameters[8].Value = model.CS_OPERATOR_DATE;
|
||
parameters[9].Value = model.CUSTOMERMEMBERID;
|
||
parameters[10].Value = model.CUSTOMERNAME;
|
||
parameters[11].Value = model.CUSTOMERPHONE;
|
||
parameters[12].Value = model.CUSTOMERPROVINCE;
|
||
parameters[13].Value = model.CUSTOMERCITY;
|
||
parameters[14].Value = model.CUSTOMERDISTRICT;
|
||
parameters[15].Value = model.CUSTOMERADDRESS;
|
||
parameters[16].Value = model.PAY_DATE;
|
||
parameters[17].Value = model.GOODS_NUM;
|
||
parameters[18].Value = model.GOODS_PRICE;
|
||
parameters[19].Value = model.EXPRESSMONEY;
|
||
parameters[20].Value = model.REMARK;
|
||
parameters[21].Value = model.STATUS;
|
||
parameters[22].Value = model.PACKINGWEITH;
|
||
parameters[23].Value = model.WEIGHED_MAN;
|
||
parameters[24].Value = model.WEIGHED_DATE;
|
||
parameters[25].Value = model.PACKING_MAN;
|
||
parameters[26].Value = model.PACKING_DATE;
|
||
parameters[27].Value = model.STORAGENAME;
|
||
parameters[28].Value = model.CREATE_MAN;
|
||
parameters[29].Value = model.DATASOURCE;
|
||
parameters[30].Value = model.Packagingmaterials;
|
||
parameters[31].Value = model.Packagingmaterialscount;
|
||
parameters[32].Value = model.Storage_id;
|
||
parameters[33].Value = model.Postcoad;
|
||
parameters[34].Value = model.Finan_audit_man;
|
||
parameters[35].Value = model.Finan_audit_date;
|
||
parameters[36].Value = model.WEIGHTING_TOTAL;
|
||
parameters[37].Value = model.Cus_membername;
|
||
parameters[38].Value = model.Order_source;
|
||
parameters[39].Value = model.Telephone;
|
||
parameters[40].Value = model.Printjh;
|
||
parameters[41].Value = model.Printkd;
|
||
parameters[42].Value = model.Printck;
|
||
parameters[43].Value = model.Dfstatus;
|
||
parameters[44].Value = model.Ck_type;
|
||
parameters[45].Value = model.Cus_guid;
|
||
#endregion
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
||
|
||
}
|
||
#endregion
|
||
|
||
#region 接口导入
|
||
/// <summary>
|
||
/// 接口导入
|
||
/// </summary>
|
||
/// <param name="or_model">出库通知单实体</param>
|
||
/// <param name="list_del">明细表集合</param>
|
||
/// <param name="str_msg">错误信息</param>
|
||
public void Import(OrdersModel or_model, List<OrderDetailModel> list_del, ref string str_msg)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
List<string> list_str = new List<string>();
|
||
List<OracleParameter[]> list_parameter = new List<OracleParameter[]>();
|
||
List<OrderDetailModel> _list_del = new List<OrderDetailModel>();
|
||
or_model.STATUS = "1";//导入过来的单据已确认直接可以拣货出库 状态为已确认
|
||
|
||
#region 增加SQL
|
||
strSql = new StringBuilder();
|
||
strSql.Append("insert into T_CK_ORDERS(");
|
||
strSql.Append("ORDER_ID,BUSINESSORDERID,SHOPORDERID,SHOPID,SHOPNAME,LOG_COM_ID,EXPRESSNO,CS_OPERATOR_MAN,CS_OPERATOR_DATE,CUSTOMERMEMBERID,CUSTOMERNAME,CUSTOMERPHONE,CUSTOMERPROVINCE,CUSTOMERCITY,CUSTOMERDISTRICT,CUSTOMERADDRESS,PAY_DATE,GOODS_NUM,GOODS_PRICE,EXPRESSMONEY,REMARK,STATUS,PACKINGWEITH,WEIGHED_MAN,WEIGHED_DATE,PACKING_MAN,PACKING_DATE,STORAGENAME,CREATE_MAN,CREATE_DATE,DATASOURCE,PACKAGINGMATERIALS,MATERIALSCOUNT,STORAGE_ID,POSTCOAD,FINAN_AUDIT_MAN,FINAN_AUDIT_DATE,WEIGHTING_TOTAL,CUS_MEMBERNAME,ORDER_SOURCE,TELEPHONE,PRINTJH,PRINTKD,PRINTCK,DFSTATUS,CK_TYPE,CUS_GUID)");
|
||
strSql.Append(" values (");
|
||
strSql.Append(":ORDER_ID,:BUSINESSORDERID,:SHOPORDERID,:SHOPID,:SHOPNAME,:LOG_COM_ID,:EXPRESSNO,:CS_OPERATOR_MAN,:CS_OPERATOR_DATE,:CUSTOMERMEMBERID,:CUSTOMERNAME,:CUSTOMERPHONE,:CUSTOMERPROVINCE,:CUSTOMERCITY,:CUSTOMERDISTRICT,:CUSTOMERADDRESS,:PAY_DATE,:GOODS_NUM,:GOODS_PRICE,:EXPRESSMONEY,:REMARK,:STATUS,:PACKINGWEITH,:WEIGHED_MAN,:WEIGHED_DATE,:PACKING_MAN,:PACKING_DATE,:STORAGENAME,:CREATE_MAN,:CREATE_DATE,:DATASOURCE,:PACKAGINGMATERIALS,:MATERIALSCOUNT,:STORAGE_ID,:POSTCOAD,:FINAN_AUDIT_MAN,:FINAN_AUDIT_DATE,:WEIGHTING_TOTAL,:CUS_MEMBERNAME,:ORDER_SOURCE,:TELEPHONE,:PRINTJH,:PRINTKD,:PRINTCK,:DFSTATUS,:CK_TYPE,:CUS_GUID)");
|
||
#endregion
|
||
|
||
#region 参数添加
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":BUSINESSORDERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPORDERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":LOG_COM_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":EXPRESSNO",OracleDbType.Varchar2),
|
||
new OracleParameter(":CS_OPERATOR_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":CS_OPERATOR_DATE", OracleDbType.Date),
|
||
new OracleParameter(":CUSTOMERMEMBERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERPHONE",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERPROVINCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERCITY",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERDISTRICT",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERADDRESS",OracleDbType.Varchar2),
|
||
new OracleParameter(":PAY_DATE", OracleDbType.Date),
|
||
new OracleParameter(":GOODS_NUM", OracleDbType.Decimal),
|
||
new OracleParameter(":GOODS_PRICE", OracleDbType.Decimal),
|
||
new OracleParameter(":EXPRESSMONEY", OracleDbType.Decimal),
|
||
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
||
new OracleParameter(":STATUS", OracleDbType.Char),
|
||
new OracleParameter(":PACKINGWEITH", OracleDbType.Decimal),
|
||
new OracleParameter(":WEIGHED_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":WEIGHED_DATE", OracleDbType.Date),
|
||
new OracleParameter(":PACKING_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":PACKING_DATE", OracleDbType.Date),
|
||
new OracleParameter(":STORAGENAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":CREATE_DATE", OracleDbType.Date),
|
||
new OracleParameter(":DATASOURCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":PACKAGINGMATERIALS",OracleDbType.Varchar2),
|
||
new OracleParameter(":MATERIALSCOUNT",OracleDbType.Decimal),
|
||
new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":POSTCOAD",OracleDbType.Varchar2),
|
||
new OracleParameter(":FINAN_AUDIT_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":FINAN_AUDIT_DATE",OracleDbType.Date),
|
||
new OracleParameter(":WEIGHTING_TOTAL",OracleDbType.Decimal),
|
||
new OracleParameter(":CUS_MEMBERNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":ORDER_SOURCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":TELEPHONE",OracleDbType.Varchar2),
|
||
new OracleParameter(":PRINTJH",OracleDbType.Char),
|
||
new OracleParameter(":PRINTKD",OracleDbType.Char),
|
||
new OracleParameter(":PRINTCK",OracleDbType.Char),
|
||
new OracleParameter(":DFSTATUS",OracleDbType.Char),
|
||
new OracleParameter(":Ck_type",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUS_GUID",OracleDbType.Varchar2)};
|
||
parameters[0].Value = or_model.ORDER_ID;//流水号
|
||
parameters[1].Value = or_model.BUSINESSORDERID;
|
||
parameters[2].Value = or_model.SHOPORDERID;
|
||
parameters[3].Value = or_model.SHOPID;
|
||
parameters[4].Value = or_model.SHOPNAME;
|
||
parameters[5].Value = or_model.LOG_COM_ID;
|
||
parameters[6].Value = or_model.EXPRESSNO;
|
||
parameters[7].Value = or_model.CS_OPERATOR_MAN;
|
||
parameters[8].Value = or_model.CS_OPERATOR_DATE;
|
||
parameters[9].Value = or_model.CUSTOMERMEMBERID;
|
||
parameters[10].Value = or_model.CUSTOMERNAME;
|
||
parameters[11].Value = or_model.CUSTOMERPHONE;
|
||
parameters[12].Value = or_model.CUSTOMERPROVINCE;
|
||
parameters[13].Value = or_model.CUSTOMERCITY;
|
||
parameters[14].Value = or_model.CUSTOMERDISTRICT;
|
||
parameters[15].Value = or_model.CUSTOMERADDRESS;
|
||
parameters[16].Value = or_model.PAY_DATE;
|
||
parameters[17].Value = or_model.GOODS_NUM;
|
||
parameters[18].Value = or_model.GOODS_PRICE;
|
||
parameters[19].Value = or_model.EXPRESSMONEY;
|
||
parameters[20].Value = or_model.REMARK;
|
||
parameters[21].Value = or_model.STATUS;
|
||
parameters[22].Value = or_model.PACKINGWEITH;
|
||
parameters[23].Value = or_model.WEIGHED_MAN;
|
||
parameters[24].Value = or_model.WEIGHED_DATE;
|
||
parameters[25].Value = or_model.PACKING_MAN;
|
||
parameters[26].Value = or_model.PACKING_DATE;
|
||
parameters[27].Value = or_model.STORAGENAME;
|
||
parameters[28].Value = or_model.CREATE_MAN;
|
||
parameters[29].Value = or_model.CREATE_DATE;
|
||
parameters[30].Value = or_model.DATASOURCE;
|
||
parameters[31].Value = or_model.Packagingmaterials;
|
||
parameters[32].Value = or_model.Packagingmaterialscount;
|
||
parameters[33].Value = or_model.Storage_id;
|
||
parameters[34].Value = or_model.Postcoad;
|
||
parameters[35].Value = or_model.Finan_audit_man;
|
||
parameters[36].Value = or_model.Finan_audit_date;
|
||
parameters[37].Value = or_model.WEIGHTING_TOTAL;
|
||
parameters[38].Value = or_model.Cus_membername;
|
||
parameters[39].Value = or_model.Order_source;
|
||
parameters[40].Value = or_model.Telephone;
|
||
parameters[41].Value = or_model.Printjh;
|
||
parameters[42].Value = or_model.Printkd;
|
||
parameters[43].Value = or_model.Printck;
|
||
parameters[44].Value = or_model.Dfstatus;
|
||
parameters[45].Value = or_model.Ck_type;
|
||
parameters[46].Value = or_model.Cus_guid;
|
||
#endregion
|
||
|
||
list_str.Add(strSql.ToString());
|
||
list_parameter.Add(parameters);
|
||
|
||
foreach (OrderDetailModel del_model in list_del)
|
||
{
|
||
strSql = new StringBuilder();
|
||
strSql.Append("insert into T_CK_ORDERDETAIL(");
|
||
strSql.Append("CK_ID,BUSINESSID,GOOD_ID,SPECIFICATION,GOODS_NUM,REMARK,PAGE_NUM,WEITH,PRICE,SCALE_UNIT,GOODS_TYPE_ID,TOTAL_VOLUME,GVOLUME,UNIT)");
|
||
strSql.Append(" values (");
|
||
strSql.Append(":CK_ID,:BUSINESSID,:GOOD_ID,:SPECIFICATION,:GOODS_NUM,:REMARK,:PAGE_NUM,:WEITH,:PRICE,:SCALE_UNIT,:GOODS_TYPE_ID,:TOTAL_VOLUME,:GVOLUME,:UNIT)");
|
||
OracleParameter[] _parameters = {
|
||
new OracleParameter(":CK_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":BUSINESSID",OracleDbType.Varchar2),
|
||
new OracleParameter(":GOOD_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SPECIFICATION",OracleDbType.Varchar2),
|
||
new OracleParameter(":GOODS_NUM", OracleDbType.Decimal),
|
||
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
||
new OracleParameter(":PAGE_NUM", OracleDbType.Decimal),
|
||
new OracleParameter(":WEITH", OracleDbType.Decimal),
|
||
new OracleParameter(":PRICE",OracleDbType.Decimal),
|
||
new OracleParameter(":SCALE_UNIT",OracleDbType.Char),
|
||
new OracleParameter(":GOODS_TYPE_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":TOTAL_VOLUME",OracleDbType.Decimal),
|
||
new OracleParameter(":GVOLUME",OracleDbType.Decimal),
|
||
new OracleParameter(":UNIT",OracleDbType.Char)};
|
||
_parameters[0].Value = or_model.ORDER_ID;
|
||
_parameters[1].Value = del_model.BUSINESSID;
|
||
_parameters[2].Value = del_model.GOOD_ID;
|
||
_parameters[3].Value = del_model.SPECIFICATION;
|
||
_parameters[4].Value = del_model.GOODS_NUM;
|
||
_parameters[5].Value = del_model.REMARK;
|
||
_parameters[6].Value = del_model.PAGE_NUM;
|
||
_parameters[7].Value = del_model.Weith;
|
||
_parameters[8].Value = del_model.PRICE;
|
||
_parameters[9].Value = del_model.SCALE_UNIT;
|
||
_parameters[10].Value = del_model.GOODS_TYPE_ID;
|
||
_parameters[11].Value = del_model.TOTAL_VOLUME;
|
||
_parameters[12].Value = del_model.GVOLUME;
|
||
_parameters[13].Value = del_model.UNIT;
|
||
|
||
list_str.Add(strSql.ToString());
|
||
list_parameter.Add(_parameters);
|
||
}
|
||
|
||
SystemDataObject.Instance.ExecuteList(list_str, ref str_msg);
|
||
|
||
}
|
||
#endregion
|
||
|
||
#region 修改通知单信息
|
||
/// <summary>
|
||
/// 修改通知单信息
|
||
/// </summary>
|
||
/// <param name="model"></param>
|
||
public void UpdateOrders(OrdersModel model)
|
||
{
|
||
#region 更新SQL
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("update T_CK_ORDERS set ");
|
||
strSql.Append("SHOPORDERID=:SHOPORDERID,");
|
||
strSql.Append("SHOPID=:SHOPID,");
|
||
strSql.Append("SHOPNAME=:SHOPNAME,");
|
||
strSql.Append("LOG_COM_ID=:LOG_COM_ID,");
|
||
strSql.Append("EXPRESSNO=:EXPRESSNO,");
|
||
strSql.Append("CS_OPERATOR_MAN=:CS_OPERATOR_MAN,");
|
||
strSql.Append("CS_OPERATOR_DATE=:CS_OPERATOR_DATE,");
|
||
strSql.Append("CUSTOMERMEMBERID=:CUSTOMERMEMBERID,");
|
||
strSql.Append("CUSTOMERNAME=:CUSTOMERNAME,");
|
||
strSql.Append("CUSTOMERPHONE=:CUSTOMERPHONE,");
|
||
strSql.Append("CUSTOMERPROVINCE=:CUSTOMERPROVINCE,");
|
||
strSql.Append("CUSTOMERCITY=:CUSTOMERCITY,");
|
||
strSql.Append("CUSTOMERDISTRICT=:CUSTOMERDISTRICT,");
|
||
strSql.Append("CUSTOMERADDRESS=:CUSTOMERADDRESS,");
|
||
strSql.Append("PAY_DATE=:PAY_DATE,");
|
||
strSql.Append("GOODS_NUM=:GOODS_NUM,");
|
||
strSql.Append("GOODS_PRICE=:GOODS_PRICE,");
|
||
strSql.Append("EXPRESSMONEY=:EXPRESSMONEY,");
|
||
strSql.Append("REMARK=:REMARK,");
|
||
strSql.Append("STATUS=:STATUS,");
|
||
strSql.Append("PACKINGWEITH=:PACKINGWEITH,");
|
||
strSql.Append("WEIGHED_MAN=:WEIGHED_MAN,");
|
||
strSql.Append("WEIGHED_DATE=:WEIGHED_DATE,");
|
||
strSql.Append("PACKING_MAN=:PACKING_MAN,");
|
||
strSql.Append("PACKING_DATE=:PACKING_DATE,");
|
||
strSql.Append("STORAGENAME=:STORAGENAME,");
|
||
strSql.Append("CREATE_MAN=:CREATE_MAN,");
|
||
strSql.Append("CREATE_DATE=:CREATE_DATE,");
|
||
strSql.Append("DATASOURCE=:DATASOURCE,");
|
||
strSql.Append("BUSINESSORDERID=:BUSINESSORDERID,");
|
||
strSql.Append("STORAGE_ID=:STORAGE_ID,");
|
||
strSql.Append("PACKAGINGMATERIALS=:PACKAGINGMATERIALS,");
|
||
strSql.Append("MATERIALSCOUNT=:MATERIALSCOUNT,");
|
||
strSql.Append("POSTCOAD=:POSTCOAD,");
|
||
strSql.Append("FINAN_AUDIT_MAN=:FINAN_AUDIT_MAN,");
|
||
strSql.Append("FINAN_AUDIT_DATE=:FINAN_AUDIT_DATE,");
|
||
strSql.Append("WEIGHTING_TOTAL=:WEIGHTING_TOTAL,");
|
||
strSql.Append("CUS_MEMBERNAME=:CUS_MEMBERNAME,");
|
||
strSql.Append("ORDER_SOURCE=:ORDER_SOURCE,");
|
||
strSql.Append("TELEPHONE=:TELEPHONE,");
|
||
strSql.Append("PRINTJH=:PRINTJH,");
|
||
strSql.Append("PRINTKD=:PRINTKD,");
|
||
strSql.Append("DFSTATUS=:DFSTATUS,");
|
||
strSql.Append("PRINTCK=:PRINTCK,");
|
||
strSql.Append("CK_TYPE=:CK_TYPE,");
|
||
strSql.Append("CUS_GUID=:CUS_GUID");
|
||
strSql.Append(" where ORDER_ID=:ORDER_ID ");
|
||
#endregion
|
||
|
||
#region 参数添加
|
||
OracleParameter[] parameters = {
|
||
|
||
new OracleParameter(":SHOPORDERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPID",OracleDbType.Varchar2),
|
||
new OracleParameter(":SHOPNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":LOG_COM_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":EXPRESSNO",OracleDbType.Varchar2),
|
||
new OracleParameter(":CS_OPERATOR_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":CS_OPERATOR_DATE", OracleDbType.Date),
|
||
new OracleParameter(":CUSTOMERMEMBERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERPHONE",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERPROVINCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERCITY",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERDISTRICT",OracleDbType.Varchar2),
|
||
new OracleParameter(":CUSTOMERADDRESS",OracleDbType.Varchar2),
|
||
new OracleParameter(":PAY_DATE", OracleDbType.Date),
|
||
new OracleParameter(":GOODS_NUM", OracleDbType.Decimal),
|
||
new OracleParameter(":GOODS_PRICE", OracleDbType.Decimal),
|
||
new OracleParameter(":EXPRESSMONEY", OracleDbType.Decimal),
|
||
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
||
new OracleParameter(":STATUS", OracleDbType.Char),
|
||
new OracleParameter(":PACKINGWEITH", OracleDbType.Decimal),
|
||
new OracleParameter(":WEIGHED_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":WEIGHED_DATE", OracleDbType.Date),
|
||
new OracleParameter(":PACKING_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":PACKING_DATE", OracleDbType.Date),
|
||
new OracleParameter(":STORAGENAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":CREATE_DATE", OracleDbType.Date),
|
||
new OracleParameter(":DATASOURCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":BUSINESSORDERID",OracleDbType.Varchar2),
|
||
new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":PACKAGINGMATERIALS",OracleDbType.Varchar2),
|
||
new OracleParameter(":MATERIALSCOUNT",OracleDbType.Varchar2),
|
||
new OracleParameter(":POSTCOAD",OracleDbType.Varchar2),
|
||
new OracleParameter(":FINAN_AUDIT_MAN",OracleDbType.Varchar2),
|
||
new OracleParameter(":FINAN_AUDIT_DATE",OracleDbType.Date),
|
||
new OracleParameter(":WEIGHTING_TOTAL",OracleDbType.Decimal),
|
||
new OracleParameter(":CUS_MEMBERNAME",OracleDbType.Varchar2),
|
||
new OracleParameter(":ORDER_SOURCE",OracleDbType.Varchar2),
|
||
new OracleParameter(":TELEPHONE",OracleDbType.Varchar2),
|
||
new OracleParameter(":PRINTJH",OracleDbType.Char),
|
||
new OracleParameter(":PRINTKD",OracleDbType.Char),
|
||
new OracleParameter(":DFSTATUS",OracleDbType.Char),
|
||
new OracleParameter(":PRINTCK",OracleDbType.Char),
|
||
new OracleParameter(":CK_TYPE",OracleDbType.Char),
|
||
new OracleParameter(":CUS_GUID",OracleDbType.Varchar2),
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2)};
|
||
|
||
parameters[0].Value = model.SHOPORDERID;
|
||
parameters[1].Value = model.SHOPID;
|
||
parameters[2].Value = model.SHOPNAME;
|
||
parameters[3].Value = model.LOG_COM_ID;
|
||
parameters[4].Value = model.EXPRESSNO;
|
||
parameters[5].Value = model.CS_OPERATOR_MAN;
|
||
parameters[6].Value = model.CS_OPERATOR_DATE;
|
||
parameters[7].Value = model.CUSTOMERMEMBERID;
|
||
parameters[8].Value = model.CUSTOMERNAME;
|
||
parameters[9].Value = model.CUSTOMERPHONE;
|
||
parameters[10].Value = model.CUSTOMERPROVINCE;
|
||
parameters[11].Value = model.CUSTOMERCITY;
|
||
parameters[12].Value = model.CUSTOMERDISTRICT;
|
||
parameters[13].Value = model.CUSTOMERADDRESS;
|
||
parameters[14].Value = model.PAY_DATE;
|
||
parameters[15].Value = model.GOODS_NUM;
|
||
parameters[16].Value = model.GOODS_PRICE;
|
||
parameters[17].Value = model.EXPRESSMONEY;
|
||
parameters[18].Value = model.REMARK;
|
||
parameters[19].Value = model.STATUS;
|
||
parameters[20].Value = model.PACKINGWEITH;
|
||
parameters[21].Value = model.WEIGHED_MAN;
|
||
parameters[22].Value = model.WEIGHED_DATE;
|
||
parameters[23].Value = model.PACKING_MAN;
|
||
parameters[24].Value = model.PACKING_DATE;
|
||
parameters[25].Value = model.STORAGENAME;
|
||
parameters[26].Value = model.CREATE_MAN;
|
||
parameters[27].Value = model.CREATE_DATE;
|
||
parameters[28].Value = model.DATASOURCE;
|
||
parameters[29].Value = model.BUSINESSORDERID;
|
||
parameters[30].Value = model.Storage_id;
|
||
parameters[31].Value = model.Packagingmaterials;
|
||
parameters[32].Value = model.Packagingmaterialscount;
|
||
parameters[33].Value = model.Postcoad;
|
||
parameters[34].Value = model.Finan_audit_man;
|
||
parameters[35].Value = model.Finan_audit_date;
|
||
parameters[36].Value = model.WEIGHTING_TOTAL;
|
||
parameters[37].Value = model.Cus_membername;
|
||
parameters[38].Value = model.Order_source;
|
||
parameters[39].Value = model.Telephone;
|
||
parameters[40].Value = model.Printjh;
|
||
parameters[41].Value = model.Printkd;
|
||
parameters[42].Value = model.Dfstatus;
|
||
parameters[43].Value = model.Printck;
|
||
parameters[44].Value = model.Ck_type;
|
||
parameters[45].Value = model.Cus_guid;
|
||
parameters[46].Value = model.ORDER_ID;
|
||
#endregion
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
||
|
||
}
|
||
public void UpdateLock(string loc)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
|
||
strSql.AppendLine("update T_BASE_STORAGE_AREA_LOCATION set ");
|
||
strSql.AppendLine("outstand1= '" + 1 + "'");
|
||
strSql.AppendLine(" where location_id= '" + loc + "'");
|
||
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
||
}
|
||
#endregion
|
||
|
||
#region 修改通知单信息
|
||
/// <summary>
|
||
/// 修改通知单信息
|
||
/// </summary>
|
||
/// <param name="model"></param>
|
||
public void UpdateOrdersPickNum(OrdersModel model)
|
||
{
|
||
#region 更新SQL
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("update T_CK_ORDERS set ");
|
||
strSql.Append("PICK_NUM=PICK_NUM+:PICK_NUM");
|
||
strSql.Append(" where ORDER_ID=:ORDER_ID ");
|
||
#endregion
|
||
|
||
#region 参数添加
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":PICK_NUM",OracleDbType.Varchar2),
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2)};
|
||
|
||
parameters[0].Value = model.PICK_NUM;
|
||
parameters[1].Value = model.ORDER_ID;
|
||
#endregion
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
||
|
||
}
|
||
#endregion
|
||
|
||
#region 修改通知单信息
|
||
/// <summary>
|
||
/// 修改通知单信息
|
||
/// </summary>
|
||
/// <param name="model"></param>
|
||
public void UpdateOrdersPickOver(string model,string stauts)
|
||
{
|
||
#region 更新SQL
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("update T_CK_ORDERS set ");
|
||
strSql.Append("STATUS='" + stauts + "'");
|
||
strSql.Append(" where ORDER_ID=:ORDER_ID ");
|
||
#endregion
|
||
|
||
#region 参数添加
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2)};
|
||
parameters[0].Value = model;
|
||
#endregion
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
||
|
||
}
|
||
/// <summary>
|
||
/// 修改通知单信息
|
||
/// </summary>
|
||
/// <param name="model"></param>
|
||
public void UpdateOrdersPickSatus(string model)
|
||
{
|
||
#region 更新SQL
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("update T_CK_ORDERS a set ");
|
||
strSql.Append("a. STATUS='3'");
|
||
strSql.Append(" where a. ORDER_ID in(select t.out_ID from T_CK_PICKINGWAVEGOODS t where t.PICKINGID='" + model + "') ");
|
||
#endregion
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
||
|
||
}
|
||
#endregion
|
||
|
||
#region 删除通知单
|
||
/// <summary>
|
||
/// 删除通知单
|
||
/// </summary>
|
||
/// <param name="model"></param>
|
||
public void DelOrders(OrdersModel model)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("delete from T_CK_ORDERS ");
|
||
strSql.Append(" where ORDER_ID=:ORDER_ID");
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2) };
|
||
parameters[0].Value = model.ORDER_ID;
|
||
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
||
|
||
}
|
||
#endregion
|
||
|
||
#region 获取流水号
|
||
/// <summary>
|
||
/// 获取流水号
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public string GetSerialNum()
|
||
{
|
||
string sql = "select NEXT VALUE FOR seq_ck_orders";
|
||
DataSet ds = SystemDataObject.Instance.GetDataSet(sql);
|
||
string str = "CK" + System.DateTime.Now.Date.ToString("yyyyMMdd");
|
||
str += ds.Tables[0].Rows[0][0].ToString();
|
||
return str;
|
||
}
|
||
#endregion
|
||
|
||
/// <summary>
|
||
/// 标记生成过调拨单的出库通知单
|
||
/// </summary>
|
||
public void UpdateRepFlag(string ID)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.Append("update T_CK_ORDERS ");
|
||
strSql.Append(" set REP_FLAG=1");
|
||
strSql.Append(" where ORDER_ID=:ORDER_ID");
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":ORDER_ID",OracleDbType.Varchar2) };
|
||
parameters[0].Value = ID;
|
||
|
||
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
||
|
||
}
|
||
|
||
public DataTable GetGoodsData(string goodsID,string tb)
|
||
{
|
||
string sqlStr = "select a.*,t.GOODS_NAME,c.STORAGE_AREA_NAME from '"+ tb + "' a"
|
||
+" left join T_BASE_GOODS t on a.GOODS_ID = t.GOODS_ID"
|
||
+" left join T_BASE_STORAGE_AREA c on " +
|
||
" a.STORAGE_ID = c.STORAGE_AREA_IDwhere GOODS_ID ='"+goodsID+"'";
|
||
return SystemDataObject.Instance.GetDataTable(sqlStr);
|
||
}
|
||
}
|
||
}
|