public DataSet SaveDayEnd(DataTable eayEndTable)
{
DownBusinessSystemsDailyBalanceDao dao = new DownBusinessSystemsDailyBalanceDao();
DataTable unitList = dao.GetUnitProduct();
DataSet ds = this.GenerateEmptyTables();
foreach (DataRow row in eayEndTable.Rows)
{
DataRow[] unitRow = unitList.Select(string.Format("unit_list_code='{0}'", row["BRAND_N"].ToString().Trim()));
DataRow masterrow = ds.Tables["WMS_BUSINESS_SYSTEMS_DAILY_BALANCE"].NewRow();
//masterrow["id"] = row["DailyBalanceID"].ToString().Trim();
masterrow["settle_date"] = row["SettleDate"].ToString().Trim();
masterrow["warehouse_code"] = row["WarehouseCode"].ToString().Trim();
masterrow["product_code"] = row["BRAND_N"].ToString().Trim();
masterrow["unit_code"] = unitRow[0]["unit_code04"].ToString();
masterrow["beginning"] = Convert.ToDecimal(row["Beginning"]);
masterrow["entry_amount"] = Convert.ToDecimal(row["EntryAmount"]);
masterrow["delivery_amount"] = Convert.ToDecimal(row["DeliveryAmount"]);
masterrow["profit_amount"] = Convert.ToDecimal(row["ProfitAmount"]);
masterrow["loss_amount"] = Convert.ToDecimal(row["LossAmount"]);
masterrow["ending"] = Convert.ToDecimal(row["Ending"]);
ds.Tables["WMS_BUSINESS_SYSTEMS_DAILY_BALANCE"].Rows.Add(masterrow);
}
return ds;
}
