//保存细表信息
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;
}
