private void UpdateReCalValue(ACS320_Process resultDo)
{
if (this.InvokeRequired)
{
this.Invoke((Action)(() =>
{
txtActualMOH.DecimalValue = resultDo.ActMOH;
txtActualCapacity.DecimalValue = resultDo.ActCapaUsed;
txtActualMOHRate.DecimalValue = resultDo.ActCostRate;
txtSoldLiter.DecimalValue = resultDo.SoldLiter;
txtEndLiter.DecimalValue = resultDo.EndingLiter;
txtSoldLiterOEM.DecimalValue = resultDo.SoldLiterOEM;
txtEndLiterOEM.DecimalValue = resultDo.EndingLiterOEM;
}));
return;
}
}
public ACS320_Process CalculateData(int year, int period, string byUser, SqlInfoMessageEventHandler infoMessageHandler = null)
{
SqlConnection conn = new SqlConnection(AppConfig.ConnectionString);
conn.FireInfoMessageEventOnUserErrors = true; // This flag allow receive message realtime.
SqlData db = new SqlData(conn);
try
{
db.BeginTrans();
//#####################
//# Process Calcualte
//# While processing, reponse progress periodically.
//#####################
conn.InfoMessage += infoMessageHandler;
ACS320_Process result = StoreProcedure.sp_ACS320_Process_CalculateData(db, year, period, byUser);
//#####################
//# Update Calculation Status
//#####################
conn.InfoMessage -= infoMessageHandler;
StoreProcedure.sp_ACS320_Update_ProcessControl(db, year, period, byUser);
db.CommitTrans();
return(result);
}
catch (Exception ex)
{
if (db.HasTransaction)
{
db.RollbackTrans();
}
throw;
}
finally
{
db.Close();
}
}
private void UpdateProgressValue(ACS320_Process resultDo)
{
if (this.InvokeRequired)
{
this.Invoke((Action)(() =>
{
txtActualMOH.DecimalValue = resultDo.ActMOH;
txtActualCapacity.DecimalValue = resultDo.ActCapaUsed;
txtActualMOHRate.DecimalValue = resultDo.ActCostRate;
txtSoldLiter.DecimalValue = resultDo.SoldLiter;
txtEndLiter.DecimalValue = resultDo.EndingLiter;
txtSoldLiterOEM.DecimalValue = resultDo.SoldLiterOEM;
txtEndLiterOEM.DecimalValue = resultDo.EndingLiterOEM;
txtActualMOH.Enabled = true;
txtActualCapacity.Enabled = true;
txtSoldLiter.Enabled = true;
txtEndLiter.Enabled = true;
txtSoldLiterOEM.Enabled = true;
txtEndLiterOEM.Enabled = true;
bool bRecal = AppEnvironment.Permission.AllowPermission(AppEnvironment.UserLogin, this.GetType().FullName, "ReCalculate");
if (bRecal)
{
btnRecal.Enabled = true;
}
else
{
btnRecal.Enabled = false;
}
}));
return;
}
}
public ACS320_Process ReCalculateData(int year, int period, decimal pActMOH, decimal pActCapaUsed, decimal pSoldLiter, decimal pEndingLiter, decimal pSoldLiterOEM, decimal pEndingLiterOEM, string byUser)
{
ACS320_Process result = StoreProcedure.sp_ACS320_Process_ReCal(AppEnvironment.Database, year, period, pActMOH, pActCapaUsed, pSoldLiter, pEndingLiter, pSoldLiterOEM, pEndingLiterOEM, byUser);
return(result);
}
