Example #1
0
 //保存细表信息
 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;
     }
 }
Example #2
0
 //保存主表信息
 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;
 }