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