private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select fcSkid from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
dtrSaveInfo["cCreateBy"] = App.FMAppUserID;
}
dtrSaveInfo["cCorp"] = App.gcCorp;
dtrSaveInfo["fcSkid"] = this.mstrEditRowID;
dtrSaveInfo["cRefType"] = this.mstrRefType;
dtrSaveInfo["fcCode"] = this.txtCode.Text.TrimEnd();
dtrSaveInfo["FCNAME"] = this.txtName.Text.TrimEnd();
dtrSaveInfo["FCNAME2"] = this.txtName2.Text.TrimEnd();
dtrSaveInfo["cFChr"] = AppUtil.StringHelper.GetFChr(this.txtName.Text.TrimEnd());
dtrSaveInfo["cLastUpdBy"] = App.FMAppUserID;
dtrSaveInfo["FTLASTEDIT"] = objSQLHelper.GetDBServerDateTime();;
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
this.mSaveDBAgent2 = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
this.mSaveDBAgent2.AppID = App.AppID;
this.mdbConn2 = this.mSaveDBAgent2.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
this.mdbConn2.Open();
this.mdbTran2 = this.mdbConn2.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "fcSkid", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
this.mdbTran2.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtName.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
this.mdbTran2.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
this.mdbConn2.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select cRowID from " + this.mstrRefTable + " where cRowID = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
dtrSaveInfo[MapTable.ShareField.CreateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.CreateDate] = objSQLHelper.GetDBServerDateTime();
}
// Control Field ·Õè·Ø¡ Form µéͧÁÕ
dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
// Control Field ·Õè·Ø¡ Form µéͧÁÕ
dtrSaveInfo[QBGTypeInfo.Field.CorpID] = App.ActiveCorp.RowID;
dtrSaveInfo[QBGTypeInfo.Field.Code] = this.txtCode.Text.TrimEnd();
dtrSaveInfo[QBGTypeInfo.Field.Name] = this.txtName.Text.TrimEnd();
dtrSaveInfo[QBGTypeInfo.Field.Name2] = this.txtName2.Text.TrimEnd();
string strCateg = "";
switch (this.cmbCateg.SelectedIndex)
{
case 0:
strCateg = SysDef.gc_BGCHART_CATEG_HR;
break;
case 1:
strCateg = SysDef.gc_BGCHART_CATEG_OPERATE;
break;
case 2:
strCateg = SysDef.gc_BGCHART_CATEG_INVEST;
break;
case 3:
strCateg = SysDef.gc_BGCHART_CATEG_SUPPORT;
break;
case 4:
strCateg = SysDef.gc_BGCHART_CATEG_OTHER;
break;
}
dtrSaveInfo[QBGTypeInfo.Field.Category] = strCateg;
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "CROWID", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtName.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select fcSkid from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
//dtrSaveInfo[MapTable.ShareField.CreateBy] = App.FMAppUserID;
//dtrSaveInfo[MapTable.ShareField.CreateDate] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo["FTDATETIME"] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo["FTLASTUPD"] = objSQLHelper.GetDBServerDateTime();
}
// Control Field ที่ทุก Form ต้องมี
//dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
//dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
//dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo[MapTable.ShareField.fcSkid] = this.mstrEditRowID;
dtrSaveInfo["FTLASTUPD"] = objSQLHelper.GetDBServerDateTime();
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[QCoorInfo.Field.CorpID] = App.ActiveCorp.RowID;
dtrSaveInfo[QCoorInfo.Field.Code] = this.txtCode.Text.TrimEnd();
dtrSaveInfo[QCoorInfo.Field.Name] = this.txtName.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr1] = this.txtAddr11.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr2] = this.txtAddr12.Text.TrimEnd();
dtrSaveInfo[QCoorInfo.Field.Name2] = this.txtName2.Text.TrimEnd();
dtrSaveInfo["fcSName"] = this.txtSName.Text.TrimEnd();
dtrSaveInfo["fcSName2"] = this.txtSName2.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr12] = this.txtAddr21.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr22] = this.txtAddr22.Text.TrimEnd();
dtrSaveInfo[QCoorInfo.Field.TelNo] = this.txtTel.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.FaxNo] = this.txtFax.Text.TrimEnd();
string gcTemStr01 = BizRule.SetMemData(this.txtAddr11.Text.Trim(), x_CMAd11);
gcTemStr01 += BizRule.SetMemData(this.txtAddr21.Text.Trim(), x_CMAd21);
//gcTemStr01 += BizRule.SetMemData(this.txtAddr31.Text.Trim(), x_CMAd31);
gcTemStr01 += BizRule.SetMemData(this.txtAddr12.Text.Trim(), x_CMAd12);
gcTemStr01 += BizRule.SetMemData(this.txtAddr22.Text.Trim(), x_CMAd22);
//gcTemStr01 += BizRule.SetMemData(this.txtAddr32.Text.Trim(), x_CMAd32);
gcTemStr01 += BizRule.SetMemData(this.txtTel.Text.Trim(), x_CMTel);
gcTemStr01 += BizRule.SetMemData(this.txtFax.Text.Trim(), x_CMFax);
gcTemStr01 += BizRule.SetMemData(this.txtTaxID.Text.Trim(), x_CMTaxId);
string gcTemStr02, gcTemStr03, gcTemStr04, gcTemStr05, gcTemStr06;
int intVarCharLen = 500;
gcTemStr02 = (gcTemStr01.Length > 0 ? StringHelper.SubStr(gcTemStr01, 1, intVarCharLen) : DBEnum.NullString);
gcTemStr03 = (gcTemStr01.Length > intVarCharLen ? StringHelper.SubStr(gcTemStr01, intVarCharLen + 1, intVarCharLen) : DBEnum.NullString);
gcTemStr04 = (gcTemStr01.Length > intVarCharLen * 2 ? StringHelper.SubStr(gcTemStr01, intVarCharLen * 2 + 1, intVarCharLen) : DBEnum.NullString);
gcTemStr05 = (gcTemStr01.Length > intVarCharLen * 3 ? StringHelper.SubStr(gcTemStr01, intVarCharLen * 3 + 1, intVarCharLen) : DBEnum.NullString);
gcTemStr06 = (gcTemStr01.Length > intVarCharLen * 4 ? StringHelper.SubStr(gcTemStr01, intVarCharLen * 4 + 1, intVarCharLen) : DBEnum.NullString);
dtrSaveInfo["fmMemData"] = gcTemStr02;
dtrSaveInfo["fmMemData2"] = gcTemStr03;
dtrSaveInfo["fmMemData3"] = gcTemStr04;
dtrSaveInfo["fmMemData4"] = gcTemStr05;
dtrSaveInfo["fmMemData5"] = gcTemStr06;
dtrSaveInfo["fcIsSupp"] = "Y";
dtrSaveInfo["fcZip"] = this.txtZip.Text.TrimEnd();
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "fcSkid", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtName.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select fcSkid from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
//dtrSaveInfo[MapTable.ShareField.CreateBy] = App.FMAppUserID;
//dtrSaveInfo[MapTable.ShareField.CreateDate] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo["FTLASTUPD"] = objSQLHelper.GetDBServerDateTime();
}
// Control Field ที่ทุก Form ต้องมี
//dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
//dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
//dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo[MapTable.ShareField.fcSkid] = this.mstrEditRowID;
dtrSaveInfo["FTLASTUPD"] = objSQLHelper.GetDBServerDateTime();
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[QEMSectInfo.Field.CorpID] = App.ActiveCorp.RowID;
dtrSaveInfo[QEMSectInfo.Field.Code] = this.txtCode.Text.TrimEnd();
dtrSaveInfo[QEMSectInfo.Field.Name] = this.txtName.Text.TrimEnd();
dtrSaveInfo[QEMSectInfo.Field.Name2] = this.txtName2.Text.TrimEnd();
dtrSaveInfo[QEMSectInfo.Field.DeptID] = this.txtQcDept.Tag.ToString();
//string strLevel = "";
//switch (this.cmbType.SelectedIndex)
//{
// case 0:
// strLevel = "D";
// break;
// case 1:
// strLevel = "G";
// break;
//}
//dtrSaveInfo[QEMSectInfo.Field.Type] = strLevel;
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "fcSkid", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtName.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
//DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
DataRow dtrSaveInfo = null;
if (objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
objSQLHelper.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where cRowID = ?", ref strErrorMsg))
{
bllIsNewRow = false;
dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].Rows[0];
}
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
// Control Field ที่ทุก Form ต้องมี
//Sum work hour and OT hour
decimal decSumWorkHr = (from p1 in this.dtsDataEnv.Tables[this.mstrTemWorkHr].AsEnumerable()
select new { TotHour = p1["nWorkHR"] }).Sum(p1 => Convert.ToDecimal(p1.TotHour));
decimal decSumOTHr = (from p1 in this.dtsDataEnv.Tables[this.mstrTemWorkHr].AsEnumerable()
select new { TotHour = p1["nOTHR"] }).Sum(p1 => Convert.ToDecimal(p1.TotHour));
dtrSaveInfo["NTOTWORKHR"] = decSumWorkHr;
dtrSaveInfo["NTOTOTHR"] = decSumOTHr;
dtrSaveInfo["CWORKHOUR"] = this.mstrWkHour;
dtrSaveInfo["CHOLIDAY"] = this.mstrHoliday;
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "CROWID", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.pmUpdateWorkCenterIT(this.mstrTemWorkHr);
this.mdbTran.Commit();
bllIsCommit = true;
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = null;
objSQLHelper.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where 0 = 1", ref strErrorMsg);
dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
dtrSaveInfo[MapTable.ShareField.CreateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.CreateDate] = objSQLHelper.GetDBServerDateTime();
this.dtsDataEnv.Tables[this.mstrRefTable].Rows.Add(dtrSaveInfo);
this.mstrCode = this.txtDate.DateTime.Year.ToString("0000");
this.mstrName = this.txtDate.DateTime.Year.ToString("0000");
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[QEMStdWorkHourInfo.Field.CorpID] = App.ActiveCorp.RowID;
dtrSaveInfo[QEMStdWorkHourInfo.Field.Code] = this.mstrCode;
dtrSaveInfo[QEMStdWorkHourInfo.Field.Name] = this.mstrName;
dtrSaveInfo[QEMStdWorkHourInfo.Field.Date] = new DateTime(this.txtDate.DateTime.Year, 1, 1);
dtrSaveInfo[QEMStdWorkHourInfo.Field.Year] = this.txtDate.DateTime.Year;
dtrSaveInfo[QEMStdWorkHourInfo.Field.PlantID] = this.txtQcPlant.Tag.ToString();
//Sum work hour and OT hour
decimal decSumWorkHr = (from p1 in this.dtsDataEnv.Tables[this.mstrTemPd].AsEnumerable()
where p1["cType"].ToString().Trim() == ""
select new { TotHour = p1["nTotHour"] }).Sum(p1 => Convert.ToDecimal(p1.TotHour));
decimal decSumOTHr = (from p1 in this.dtsDataEnv.Tables[this.mstrTemPd].AsEnumerable()
where p1["cType"].ToString().Trim() == "O"
select new { TotHour = p1["nTotHour"] }).Sum(p1 => Convert.ToDecimal(p1.TotHour));
dtrSaveInfo["NTOTWORKHR"] = decSumWorkHr;
dtrSaveInfo["NTOTOTHR"] = decSumOTHr;
dtrSaveInfo["CWORKHOUR"] = this.txtQcStdWorkHr.Tag.ToString();
dtrSaveInfo["CHOLIDAY"] = this.txtQcHoliday.Tag.ToString();
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "CROWID", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.pmUpdateWorkCalIT();
this.mdbTran.Commit();
bllIsCommit = true;
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select cRowID from " + this.mstrRefTable + " where cRowID = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
dtrSaveInfo[MapTable.ShareField.CreateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.CreateDate] = objSQLHelper.GetDBServerDateTime();
}
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[QBGYearInfo.Field.CorpID] = App.ActiveCorp.RowID;
dtrSaveInfo[QBGYearInfo.Field.Code] = this.txtCode.Text.TrimEnd();
dtrSaveInfo[QBGYearInfo.Field.Desc] = this.txtDesc.Text.TrimEnd();
dtrSaveInfo[QBGYearInfo.Field.IsActive] = (this.chkIsActive.Checked ? "Y" : "N");
dtrSaveInfo[QBGYearInfo.Field.Year] = Convert.ToInt32(this.txtYear.Value) - 543;
dtrSaveInfo[QBGYearInfo.Field.IsLock] = (this.chkIsLock.Checked ? "Y" : "N");
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "CROWID", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtDesc.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtDesc.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtDesc.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtDesc.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select cRowID from " + this.mstrRefTable + " where cRowID = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
dtrSaveInfo["cCreateBy"] = App.FMAppUserID;
}
string strGroup = "";
switch (this.cmbType.SelectedIndex)
{
case 0:
strGroup = "1";
break;
case 1:
strGroup = "2";
break;
case 2:
strGroup = "3";
break;
case 3:
strGroup = "4";
break;
case 4:
strGroup = "5";
break;
case 5:
strGroup = "6";
break;
}
string strCateg = "";
switch (this.cmbCateg.SelectedIndex)
{
case 0:
strCateg = "G";
break;
case 1:
strCateg = "D";
break;
}
dtrSaveInfo["cRowID"] = this.mstrEditRowID;
dtrSaveInfo["cCode"] = this.txtCode.Text.TrimEnd();
dtrSaveInfo["cName"] = this.txtName.Text.TrimEnd();
dtrSaveInfo["cFChr"] = AppUtil.StringHelper.GetFChr(this.txtName.Text.TrimEnd());
dtrSaveInfo["cName2"] = this.txtName2.Text.TrimEnd();
dtrSaveInfo["cGroup"] = strGroup;
dtrSaveInfo["cCateg"] = strCateg;
dtrSaveInfo["nLevel"] = this.txtCode.Text.TrimEnd().Length;
dtrSaveInfo["cLastUpdBy"] = App.FMAppUserID;
dtrSaveInfo["dLastUpd"] = objSQLHelper.GetDBServerDateTime();;
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
this.mSaveDBAgent2 = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
this.mSaveDBAgent2.AppID = App.AppID;
this.mdbConn2 = this.mSaveDBAgent2.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
this.mdbConn2.Open();
this.mdbTran2 = this.mdbConn2.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "CROWID", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
Business.Entity.QMasterAcChart QRefChild = new QMasterAcChart(App.ConnectionString, App.DatabaseReside);
QRefChild.SetSaveDBAgent(this.mSaveDBAgent, this.mdbConn, this.mdbTran);
QRefChild.SetSaveDBAgent2(this.mSaveDBAgent2, this.mdbConn2, this.mdbTran2);
QRefChild.SaveChildTable(dtrSaveInfo, this.mstrOldCode);
this.mdbTran.Commit();
this.mdbTran2.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtName.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
this.mdbTran2.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
this.mdbConn2.Close();
}
}