/// <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; } }