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;
}
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["cDept"] = this.txtQcDept.Tag.ToString();
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.QMasterSect QRefChild = new QMasterSect(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.txtQcDept.Text.TrimEnd());
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 bool pmDeleteRow(string inRowID, string inCode, string inName, ref string ioErrorMsg)
{
bool bllIsCommit = false;
bool bllResult = false;
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 strErrorMsg = "";
//Delete Child Table
Business.Entity.QMasterSect QRefChild = new QMasterSect(App.ConnectionString, App.DatabaseReside);
QRefChild.SetSaveDBAgent(this.mSaveDBAgent, this.mdbConn, this.mdbTran);
QRefChild.SetSaveDBAgent2(this.mSaveDBAgent2, this.mdbConn2, this.mdbTran2);
QRefChild.DeleteChildTable(inCode);
object[] pAPara = new object[1] {
inRowID
};
this.mSaveDBAgent.BatchSQLExec("delete from " + this.mstrRefTable + " where cRowID = ?", pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
this.mdbTran2.Commit();
bllIsCommit = true;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Delete, TASKNAME, inCode, inName, App.FMAppUserID, App.AppUserName);
bllResult = true;
}
catch (Exception ex)
{
ioErrorMsg = ex.Message;
bllResult = false;
if (!bllIsCommit)
{
this.mdbTran.Rollback();
this.mdbTran2.Rollback();
}
App.WriteEventsLog(ex);
}
finally
{
this.mdbConn.Close();
this.mdbConn2.Close();
}
return(bllResult);
}