//保存细表信息 public DataSet SaveSortingOrderDetail(DataRow[] detaildt) { DataSet ds = this.GenerateEmptyTables(); try { foreach (DataRow row in detaildt.ToArray()) { DataRow detailrow = ds.Tables["WMS_SORT_ORDER_DETAIL"].NewRow(); detailrow["order_detail_id"] = row["OrderDetailID"].ToString().Trim(); detailrow["order_id"] = row["OrderID"].ToString().Trim().Trim(); detailrow["product_code"] = row["ProductCode"].ToString().Trim(); detailrow["product_name"] = row["ProductName"].ToString().Trim(); detailrow["unit_code"] = row["UNIT_CODE02"].ToString(); detailrow["unit_name"] = "条" ; detailrow["demand_quantity"] = Convert.ToDecimal(row["RealQuantity"]); detailrow["real_quantity"] = Convert.ToDecimal(row["RealQuantity"]); detailrow["price"] = Convert.ToDecimal(row["TRADE_PRICE"]); detailrow["amount"] = Convert.ToDecimal(row["AMOUNT_PRICE"]); detailrow["unit_quantity"] = row["QUANTITY01"].ToString(); ds.Tables["WMS_SORT_ORDER_DETAIL"].Rows.Add(detailrow); } return ds; } catch (Exception e) { string s = e.Message; return null; } }
//保存主表信息 public DataSet SaveSortingOrder(DataRow[] masterdt) { DataSet ds = this.GenerateEmptyTables(); foreach (DataRow row in masterdt.ToArray()) { DataRow masterrow = ds.Tables["WMS_SORT_ORDER"].NewRow(); masterrow["order_id"] = row["OrderID"].ToString().Trim();//订单编号 masterrow["company_code"] = row["COMPANY_CODE"].ToString().Trim(); //所属单位编号 masterrow["sale_region_code"] = row["SALE_REGION_CODE"].ToString().Trim();//营销部编号 masterrow["order_date"] = row["OrderDate"].ToString();//订单日期 masterrow["order_type"] = row["SALE_SCOPE"].ToString().Trim();//订单类型 masterrow["customer_code"] = row["CustomerCode"].ToString().Trim();//客户编号 masterrow["customer_name"] = row["CustomerName"].ToString().Trim();//客户名称 masterrow["quantity_sum"] = Convert.ToDecimal(row["QuantitySum"].ToString());//总数量 masterrow["amount_sum"] = 0; masterrow["detail_num"] = 0; masterrow["deliver_order"] = row["DeliverOrder"]; masterrow["DeliverDate"] = DateTime.Now.ToString("yyyyMMdd"); masterrow["description"] = ""; masterrow["is_active"] = "1"; masterrow["update_time"] = DateTime.Now; masterrow["deliver_line_code"] = row["DIST_BILL_ID"].ToString();// row["DELIVERLINECODE"].ToString();// +"_" + row["DIST_BILL_ID"].ToString(); masterrow["dist_bill_id"] = row["DIST_BILL_ID"].ToString(); ds.Tables["WMS_SORT_ORDER"].Rows.Add(masterrow); } return ds; }