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 { /// /// 查询销售订单 /// /// 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); } /// /// 审核 和反审核 /// /// 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); } /// /// 查询采购订单 /// /// /// 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); } /// /// 新增采购明细 /// /// 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); } /// /// 新增采购单 /// /// 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); } /// /// 关闭单据 /// /// /// 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); } /// /// 查询为处理的采购计划 /// /// 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); } /// /// 增加采购计划 /// /// 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); } /// /// 根据时间查询订单数据 /// /// /// /// 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); } /// /// 查询通知单 /// /// 通知单实体 /// 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 新增通知单信息 /// /// 新增通知单信息 /// /// 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 接口导入 /// /// 接口导入 /// /// 出库通知单实体 /// 明细表集合 /// 错误信息 public void Import(OrdersModel or_model, List list_del, ref string str_msg) { StringBuilder strSql = new StringBuilder(); List list_str = new List(); List list_parameter = new List(); List _list_del = new List(); 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 修改通知单信息 /// /// 修改通知单信息 /// /// 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 修改通知单信息 /// /// 修改通知单信息 /// /// 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 修改通知单信息 /// /// 修改通知单信息 /// /// 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); } /// /// 修改通知单信息 /// /// 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 删除通知单 /// /// 删除通知单 /// /// 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 获取流水号 /// /// 获取流水号 /// /// 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 /// /// 标记生成过调拨单的出库通知单 /// 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); } } }