/// <summary>
/// 保存订单明细到虚拟表，创联
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public DataSet SaveSortingOrderDetails(DataTable detaildt)
{
DownSortingOrderDao dao = new DownSortingOrderDao();
DataTable unitList = dao.GetUnitProduct();
DataSet ds = this.GenerateEmptyTables();
try
{
int i = 0;
foreach (DataRow row in detaildt.Rows)
{
DataRow detailrow = ds.Tables["DWV_OUT_ORDER_DETAIL"].NewRow();
i++;
detailrow["order_detail_id"] = row["ORDER_DETAIL_ID"].ToString().Trim() + i;
detailrow["order_id"] = row["ORDER_ID"].ToString().Trim();
detailrow["product_code"] = row["BRAND_CODE"].ToString().Trim();
detailrow["product_name"] = row["BRAND_NAME"].ToString().Trim();
detailrow["unit_code"] = row["BRAND_UNIT_CODE"].ToString();
detailrow["unit_name"] = row["BRAND_UNIT_NAME"].ToString().Trim();;
detailrow["demand_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["real_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["price"] = Convert.ToDecimal(row["PRICE"]);
detailrow["amount"] = Convert.ToDecimal(row["AMOUNT"]);
detailrow["unit_quantity"] = 50;
ds.Tables["DWV_OUT_ORDER_DETAIL"].Rows.Add(detailrow);
}
return(ds);
}
catch (Exception e)
{
string s = e.Message;
return(null);
}
}
/// <summary>
/// 保存订单明细到虚拟表，传来DataTable
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public DataSet SaveSortingOrderDetail(DataRow[] detaildt)
{
DownSortingOrderDao dao = new DownSortingOrderDao();
DataTable unitList = dao.GetUnitProduct();
DataSet ds = this.GenerateEmptyTables();
try
{
int i = 0;
foreach (DataRow row in detaildt)
{
DataRow[] list = unitList.Select(string.Format("unit_list_code='{0}'", row["BRANDCODE"].ToString().Trim()));
DataRow detailrow = ds.Tables["DWV_OUT_ORDER_DETAIL"].NewRow();
i++;
string newcode = i.ToString();
for (int j = 0; j < 5 - i.ToString().Length; j++)
{
newcode = "0" + newcode;
}
detailrow["order_detail_id"] = row["ORDER_DETAIL_ID"].ToString().Trim() + newcode;
detailrow["order_id"] = row["ORDERID"].ToString().Trim();
detailrow["product_code"] = row["BRANDCODE"].ToString().Trim();
detailrow["product_name"] = row["BRAND_NAME"].ToString().Trim();
detailrow["unit_code"] = list[0]["unit_code02"].ToString();
detailrow["unit_name"] = row["BRAND_UNIT_NAME"].ToString().Trim();;
detailrow["demand_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["real_quantity"] = Convert.ToDecimal(row["QUANTITY"]);
detailrow["price"] = Convert.ToDecimal(row["PRICE"]);
detailrow["amount"] = Convert.ToDecimal(row["AMOUNT"]);
detailrow["unit_quantity"] = 50;
ds.Tables["DWV_OUT_ORDER_DETAIL"].Rows.Add(detailrow);
}
return(ds);
}
catch (Exception e)
{
string s = e.Message;
return(null);
}
}
