private void GeneratePO(NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo, NZString strLocCDFrom, NZString strLocCDTo, NZInt iPOInterval)
{
Database db = null;
TmpPurchaseOrderDAO dao = null;
try {
db = Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction(IsolationLevel.Serializable);
dao = new TmpPurchaseOrderDAO(db);
dao.GeneratePO(null, dtmFrom, dtmTo, strItemCDFrom, strItemCDTo, strLocCDFrom, strLocCDTo, Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine, iPOInterval);
db.Commit();
}
catch (Exception) {
db.Rollback();
throw;
}
finally {
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
}
public DataTable LoadGeneratePO(NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo, NZString strLocCDFrom, NZString strLocCDTo, NZInt iPOInterval)
{
GeneratePO(dtmFrom, dtmTo, strItemCDFrom, strItemCDTo, strLocCDFrom, strLocCDTo, iPOInterval);
TmpPurchaseOrderDAO dao = new TmpPurchaseOrderDAO(Common.CurrentDatabase);
DataTable dt = dao.LoadTmpGeneratePO(null, Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine);
return(dt);
}
