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