//zys_2011-10-06 public void UpdateStockOutIdToStockIn(DataTable table) { DataRow[] stockInRows = table.Select(string.Format("STOCKINID IS NOT NULL AND STOCKOUTID <> 0 "), "STOCKINID"); foreach (DataRow row in stockInRows) { SqlCreate sqlCreate = new SqlCreate("AS_STOCK_IN", SqlType.UPDATE); sqlCreate.AppendQuote("STOCKOUTID", row["STOCKOUTID"]); sqlCreate.AppendWhere("STOCKINID", row["STOCKINID"]); ExecuteNonQuery(sqlCreate.GetSQL()); } }
//zys_2011-10-06 public void UpdateStatus(DataTable table) { DataRow[] stockOutRows = table.Select(string.Format("STATE = '1'"), "STOCKOUTID"); foreach (DataRow row in stockOutRows) { SqlCreate sqlCreate = new SqlCreate("AS_STOCK_OUT", SqlType.UPDATE); sqlCreate.AppendQuote("STATE", "1"); sqlCreate.AppendWhere("STOCKOUTID", row["STOCKOUTID"]); ExecuteNonQuery(sqlCreate.GetSQL()); } }