private void pmLoadFormData() { DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dtrBrow != null) { this.mstrEditRowID = dtrBrow["fcSkid"].ToString(); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[] { this.mstrEditRowID }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg)) { DataRow dtrLoadForm = this.dtsDataEnv.Tables[this.mstrRefTable].Rows[0]; this.txtCode.Text = dtrLoadForm["FCCODE"].ToString().TrimEnd(); this.txtName.Text = dtrLoadForm["FCNAME"].ToString().TrimEnd(); this.txtName2.Text = dtrLoadForm["FCNAME2"].ToString().TrimEnd(); //this.txtQcDept.Tag = dtrLoadForm[QEMSectInfo.Field.DeptID].ToString(); //pobjSQLUtil.SetPara(new object[] { this.txtQcDept.Tag }); //if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QProj", QEMDeptInfo.TableName, "select * from " + QEMDeptInfo.TableName + " where fcSkid = ?", ref strErrorMsg)) //{ // this.txtQcDept.Text = this.dtsDataEnv.Tables["QProj"].Rows[0][QEMDeptInfo.Field.Code].ToString().TrimEnd(); // this.txtQnDept.Text = this.dtsDataEnv.Tables["QProj"].Rows[0][QEMDeptInfo.Field.Name].ToString().TrimEnd(); //} //string strLevel = dtrLoadForm[QEMSectInfo.Field.Type].ToString().TrimEnd(); //int intSel = -1; //switch (strLevel) //{ // case "D": // intSel = 0; // break; // case "G": // intSel = 1; // break; //} //this.cmbType.SelectedIndex = intSel; } this.pmLoadOldVar(); } }
private void pmSetBrowView_SUPPL() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); string strFMDBName = App.ConfigurationManager.ConnectionInfo.ERPDBMSName; string strEmplRTab = strFMDBName + ".dbo.EMPLR"; string strStat = "CSTATUS = case {0}.FCSTATUS when 'I' then 'INACTIVE' when '' then 'ACTIVE' end"; string strSQLExec = "select {0}.FCSKID as FCSKID, {0}.FCCODE as CCODE, {0}.FCSNAME as CSNAME, {0}.FCNAME as CNAME, " + strStat + ", {0}.FDINACTIVE as DINACTIVE, {0}.FTDATETIME as DCREATE, {0}.FTLASTUPD as DLASTUPD from {0} "; strSQLExec += " where {0}.FCCORP = ? and {0}.FCISSUPP = 'Y' "; strSQLExec = string.Format(strSQLExec, new string[] { "COOR" }); pobjSQLUtil.NotUpperSQLExecString = true; pobjSQLUtil.SetPara(new object[] { App.gcCorp }); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "SUPPL", "SUPPL", strSQLExec, ref strErrorMsg); }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strFMDBName = App.ConfigurationManager.ConnectionInfo.ERPDBMSName; string strEmplRTab = strFMDBName + ".dbo.EMPLR"; string strSQLExec = "select {0}.FCSKID, {0}.FCCODE, {0}.FCNAME, {0}.FTDATETIME, {0}.FTLASTEDIT, EM1.FCLOGIN as CLOGIN_ADD, EM2.FCLOGIN as CLOGIN_UPD from {0} "; strSQLExec += " left join {1} EM1 ON EM1.FCSKID = {0}.CCREATEBY "; strSQLExec += " left join {1} EM2 ON EM2.FCSKID = {0}.CLASTUPDBY "; strSQLExec += " where {0}.FCCORP = ? and {0}.FCBRANCH = ? and {0}.FCREFTYPE = ? "; strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable, strEmplRTab }); pobjSQLUtil.NotUpperSQLExecString = true; pobjSQLUtil.SetPara(new object[] { App.ActiveCorp.RowID, this.mstrBranchID, this.mstrRefType }); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, "WSBOOK", strSQLExec, ref strErrorMsg); }
private void pmSetBrowView_WHOUSE() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLExec = "select BRANCH.FCCODE as QCBRANCH,EMWHOUSE.FCSKID, EMWHOUSE.FCCODE as CCODE, EMWHOUSE.FCNAME as CNAME, EMWHOUSE.FCNAME2 as CNAME2"; strSQLExec += " , LC1.FCCODE as QCWHLOCA_INPUT, LC2.FCCODE as QCWHLOCA_OUTPUT, LC3.FCCODE as QCWHLOCA_STOCK "; strSQLExec += " , EMWHOUSE.FTLASTUPD as FDCREATE, EMWHOUSE.FTDATETIME as FDLASTUPDBY "; strSQLExec += " from WHOUSE as EMWHOUSE "; strSQLExec += " left join BRANCH on BRANCH.FCSKID = EMWHOUSE.FCBRANCH "; strSQLExec += " left join WHLOCATION LC1 on LC1.FCSKID = EMWHOUSE.FCWHLOCA_INPUT "; strSQLExec += " left join WHLOCATION LC2 on LC2.FCSKID = EMWHOUSE.FCWHLOCA_OUTPUT "; strSQLExec += " left join WHLOCATION LC3 on LC3.FCSKID = EMWHOUSE.FCWHLOCA_STOCK "; strSQLExec += " where EMWHOUSE.FCCORP = ? "; pobjSQLUtil.SetPara(new object[] { App.ActiveCorp.RowID }); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "WHOUSE", "WHOUSE", strSQLExec, ref strErrorMsg); }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLExec = "select MFMCType.CROWID, MFMCType.CCODE, MFMCType.CNAME, MFMCType.CNAME2, MFMCType.DCREATE, MFMCType.DLASTUPDBY, EM1.CLOGIN as CLOGIN_ADD, EM2.CLOGIN as CLOGIN_UPD from {0} MFMCType "; strSQLExec += " left join {1} EM1 ON EM1.CROWID = MFMCType.CCREATEBY "; strSQLExec += " left join {1} EM2 ON EM2.CROWID = MFMCType.CLASTUPDBY "; strSQLExec += " where MFMCType.CCORP = ? and MFMCType.CTYPE = ? "; strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable, "APPLOGIN" }); if (this.mstrFixType != string.Empty) { this.mstrType = this.mstrFixType; } pobjSQLUtil.SetPara(new object[] { App.ActiveCorp.RowID, this.mstrType }); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, "MFMCType", strSQLExec, ref strErrorMsg); }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); //string strSQLExec = "select BGCHARTHD.CROWID, BGCHARTHD.CCODE, BGCHARTHD.CNAME from BGCHARTHD where CCORP = ? and CTYPE = ? "; string strSQLExec = ""; strSQLExec = "select "; strSQLExec += " BGCHARTHD.CROWID, BGCHARTHD.CCODE, BGCHARTHD.CNAME, PRCHART.CCODE as QCPRNAME, PRCHART.CNAME as QNPRNAME"; strSQLExec += " , BGBALANCE.NBGYEAR , BGBALANCE.NAMT , BGBALANCE.NRECVAMT , (BGBALANCE.NAMT - BGBALANCE.NRECVAMT) as NBALAMT "; strSQLExec += " from BGBALANCE "; strSQLExec += " left join BGCHARTHD on BGCHARTHD.CROWID = BGBALANCE.CBGCHARTHD "; strSQLExec += " left join BGCHARTHD PRCHART on PRCHART.CROWID = BGCHARTHD.CPRBGCHART "; strSQLExec += " where BGBALANCE.CCORP = ? and BGBALANCE.CJOB = ? and BGBALANCE.NBGYEAR = ? "; object[] pAPara = new object[] { App.ActiveCorp.RowID, this.mstrJob, this.mintBGYear }; pobjSQLUtil.SetPara(pAPara); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, this.mstrRefTable, strSQLExec, ref strErrorMsg); }
public DataRow RetrieveValue() { DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dtrBrow == null) { return(null); } string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[1] { dtrBrow["cRowID"].ToString() }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QVFLD_Table", this.mstrRefTable, "select * from " + this.mstrRefTable + " where cRowID = ? ", ref strErrorMsg)) { return(this.dtsDataEnv.Tables["QVFLD_Table"].Rows[0]); } return(null); }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strFMDBName = App.ConfigurationManager.ConnectionInfo.ERPDBMSName; string strEmplRTab = strFMDBName + ".dbo.EMPLR"; string strSQLExec = "select {0}.CROWID, {0}.CCODE, {0}.CNAME, {0}.DCREATE, {0}.DLASTUPD, EM1.FCLOGIN as CLOGIN_ADD, EM2.FCLOGIN as CLOGIN_UPD from {0} "; strSQLExec += " left join {1} EM1 ON EM1.FCSKID = {0}.CCREATEBY "; strSQLExec += " left join {1} EM2 ON EM2.FCSKID = {0}.CLASTUPDBY "; strSQLExec += " where {0}.CCORP = ? "; strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable, strEmplRTab }); //pobjSQLUtil.SetPara(pAPara); pobjSQLUtil.NotUpperSQLExecString = true; pobjSQLUtil.SetPara(new object[] { App.gcCorp }); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, "PdClass", strSQLExec, ref strErrorMsg); }
private void pmBlankFormData() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where 0=1", ref strErrorMsg); pobjSQLUtil.SetPara(new object[] { this.mstrRefType }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QRefType", "DOCTYPE", "select * from DOCTYPE where cCode = ?", ref strErrorMsg)) { DataRow dtrRefType = this.dtsDataEnv.Tables["QRefType"].Rows[0]; this.txtQcRefType.Text = dtrRefType["cCode"].ToString().TrimEnd(); this.txtQnRefType.Text = dtrRefType["cName"].ToString().TrimEnd(); } this.mstrEditRowID = ""; this.txtCode.Text = ""; this.txtName.Text = ""; this.txtName2.Text = ""; this.txtName2.Text = ""; }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strFMDBName = App.ConfigurationManager.ConnectionInfo.ERPDBMSName; string strEmplRTab = strFMDBName + ".dbo.EMPLR"; //string strSQLExec = "select EMCOOR.CROWID, EMCOOR.CCODE, EMCOOR.CNAME, EMCOOR.CNAME2, EMCOOR.DCREATE, EMCOOR.DLASTUPDBY, EM1.CLOGIN as CLOGIN_ADD, EM2.CLOGIN as CLOGIN_UPD from {0} EMCOOR "; //strSQLExec += " left join {1} EM1 ON EM1.fcSkid = EMCOOR.CCREATEBY "; //strSQLExec += " left join {1} EM2 ON EM2.fcSkid = EMCOOR.CLASTUPDBY "; string strSQLExec = "select EMCOOR.FCSKID, EMCOOR.FCCODE, EMCOOR.FCNAME, EMCOOR.FCNAME2, EMCOOR.FTDATETIME as FDCREATE, EMCOOR.FTLASTUPD as FDLASTUPDBY from {0} EMCOOR "; strSQLExec += " where EMCOOR.FCCORP = ? and FCISSUPP = 'Y'"; strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable }); pobjSQLUtil.SetPara(new object[] { App.ActiveCorp.RowID }); pobjSQLUtil.NotUpperSQLExecString = true; pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, "EMCOOR", strSQLExec, ref strErrorMsg); }
private void pmLoadFormData() { DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dtrBrow != null) { this.mstrEditRowID = dtrBrow["fcSkid"].ToString(); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[] { this.mstrEditRowID }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg)) { DataRow dtrLoadForm = this.dtsDataEnv.Tables[this.mstrRefTable].Rows[0]; this.txtCode.Text = dtrLoadForm["fcCode"].ToString().TrimEnd(); this.txtName.Text = dtrLoadForm["fcName"].ToString().TrimEnd(); this.txtName2.Text = dtrLoadForm["fcName2"].ToString().TrimEnd(); } this.pmLoadOldVar(); } }
private bool pmCheckHasUsed(string inRowID, string inCode, ref string ioErrorMsg) { string strErrorMsg = ""; bool bllHasUsed = false; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); WS.Data.Agents.cDBMSAgent objSQLHelper2 = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); objSQLHelper.SetPara(new object[] { App.gcCorp, inRowID }); if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkUsed", this.mstrRefTable, "select * from " + MapTable.Table.MasterCoor + " where cCorp = ? and cBizType = ? ", ref strErrorMsg)) { DataRow dtrUsed = this.dtsDataEnv.Tables["QChkUsed"].Rows[0]; ioErrorMsg = "ÅÙ¡¤éÒ : (" + dtrUsed["cCode"].ToString().TrimEnd() + ")" + dtrUsed["cName"].ToString().TrimEnd(); bllHasUsed = true; } if (bllHasUsed) { ioErrorMsg = "äÁèÊÒÁÒöź¢éÍÁÙÅä´éà¹×èͧ¨Ò¡ÁÕ¡ÒÃÍéÒ§ÍÔ§¶Ö§ã¹ " + ioErrorMsg; } return(bllHasUsed); }
private static void pmSuBeSmartMRPGroup( WS.Data.Agents.cDBMSAgent inSQLHelper , string inCorp , string inBranch , string inType , int inBGYear , string inSect , string inJob , string inQcBGChart , ref decimal ioAmt, ref decimal ioRecvAmt, ref decimal ioUseAmt, ref decimal ioBalAmt) { string strSumCode = inQcBGChart.TrimEnd() + "%"; string strErrorMsg = ""; string strSQLText = "select "; strSQLText += " sum(BGBALANCE.NAMT) as AMT "; strSQLText += " ,sum(BGBALANCE.NRECVAMT) as RECVAMT "; strSQLText += " ,sum(BGBALANCE.NUSEAMT) as USEAMT "; strSQLText += " ,sum(BGBALANCE.NAMT - BGBALANCE.NRECVAMT) as BALAMT "; strSQLText += " from " + QBGBalanceInfo.TableName; strSQLText += " left join BGCHARTHD on BGCHARTHD.CROWID = BGBALANCE.CBGCHARTHD "; strSQLText += " left join BGCHARTHD PRCHART on PRCHART.CROWID = BGCHARTHD.CPRBGCHART "; strSQLText += " where BGBALANCE.CCORP = ? AND BGBALANCE.CBRANCH = ? AND BGBALANCE.CTYPE = ? AND BGBALANCE.NBGYEAR = ? AND BGBALANCE.CSECT = ? AND BGBALANCE.CJOB = ? "; strSQLText += " AND BGCHARTHD.CCODE like ? "; ioAmt = 0; ioRecvAmt = 0; ioUseAmt = 0; ioBalAmt = 0; WS.Data.Agents.cDBMSAgent objSQLHelper = inSQLHelper; objSQLHelper.SetPara(new object[] { inCorp, inBranch, inType, inBGYear, inSect, inJob, strSumCode }); if (objSQLHelper.SQLExec(ref BudgetHelper.dtsDataEnv, "QSumBG", QBGBalanceInfo.TableName, strSQLText, ref strErrorMsg)) { foreach (DataRow dtrBGBal in BudgetHelper.dtsDataEnv.Tables["QSumBG"].Rows) { ioAmt += Convert.IsDBNull(dtrBGBal["AMT"]) ? 0 : Convert.ToDecimal(dtrBGBal["AMT"]); ioRecvAmt += Convert.IsDBNull(dtrBGBal["RECVAMT"]) ? 0 : Convert.ToDecimal(dtrBGBal["RECVAMT"]); ioUseAmt += Convert.IsDBNull(dtrBGBal["USEAMT"]) ? 0 : Convert.ToDecimal(dtrBGBal["USEAMT"]); ioBalAmt += Convert.IsDBNull(dtrBGBal["BALAMT"]) ? 0 : Convert.ToDecimal(dtrBGBal["BALAMT"]); } } }
private bool pmCheckHasUsed(string inRowID, string inCode, ref string ioErrorMsg) { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strMsg1 = "ไม่สามารถลบได้เนื่องจาก"; string strMsg2 = ""; bool bllHasUsed = true; if (objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) && objSQLHelper.SQLExec(ref this.dtsDataEnv, "QHasUsed", this.mstrRefTable, "select * from " + MapTable.Table.BudTranHD + " where cSect = ? ", ref strErrorMsg)) { //strMsg2 = "(" + this.dtsDataEnv.Tables["QHasUsed"].Rows[0]["cCode"].ToString().TrimEnd() + ") " + this.dtsDataEnv.Tables["QHasUsed"].Rows[0]["cName"].ToString().TrimEnd(); ioErrorMsg = strMsg1 + "มี Transaction อ้างถึงแล้ว"; } else { bllHasUsed = false; } return(bllHasUsed); }
private void pmLoadFormData() { DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dtrBrow != null) { this.mstrEditRowID = dtrBrow["cRowID"].ToString(); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[] { this.mstrEditRowID }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where cRowID = ?", ref strErrorMsg)) { DataRow dtrLoadForm = this.dtsDataEnv.Tables[this.mstrRefTable].Rows[0]; this.txtCode.Text = dtrLoadForm[QAppRoleInfo.Field.Code].ToString().TrimEnd(); this.txtName.Text = dtrLoadForm[QAppRoleInfo.Field.Name].ToString().TrimEnd(); this.txtName2.Text = dtrLoadForm[QAppRoleInfo.Field.Name2].ToString().TrimEnd(); string strLevel = dtrLoadForm[QAppRoleInfo.Field.Level].ToString().TrimEnd(); int intSel = -1; switch (strLevel) { case "O": intSel = 0; break; case "M": intSel = 1; break; case "T": intSel = 2; break; } this.cmbLevel.SelectedIndex = intSel; } this.pmLoadOldVar(); } }
private void pmLoadWorkCenterItem() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLStr = "select * from MFWKCTRHD where CROWID in (select CWKCTRH from MFWORDERIT_OPPLAN where CWORDERH in (" + this.mstrDefaSQL_MOrderH + " ) group by CWKCTRH)"; objSQLHelper.SetPara(new object[] { App.ActiveCorp.RowID, this.mstrBranch, this.mstrPlant, this.mstrRefType, this.mstrBook, this.mdttBegDate, this.mdttEndDate }); if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QLoadWkCtr", "MFWKCTRHD", strSQLStr, ref strErrorMsg)) { //Loop for Load WorkCenter Cap foreach (DataRow dtrWkCtr in this.dtsDataEnv.Tables["QLoadWkCtr"].Rows) { decimal decCapPerHour = Convert.ToDecimal(dtrWkCtr["NCAPACITY"]); DataRow dtrNewWkCtr = this.dtsDataEnv.Tables[this.mstrTemWkCtrCap].NewRow(); dtrNewWkCtr["QcWorkCtr"] = dtrWkCtr["cCode"].ToString(); dtrNewWkCtr["QnWorkCtr"] = dtrWkCtr["cName"].ToString(); dtrNewWkCtr["CapPerHour"] = decCapPerHour; this.dtsDataEnv.Tables[this.mstrTemWkCtrCap].Rows.Add(dtrNewWkCtr); foreach (DataRow dtrWorkCal in this.dtsDataEnv.Tables[this.mstrTemWorkCal].Rows) { decimal decWorkHour = Convert.ToDecimal(dtrWorkCal["TotWkHour"]); decimal decCapPerDay = decCapPerHour * decWorkHour; //DataRow[] dtaSel = this.dtsDataEnv.Tables[mstrTemMapField].Select("CDATE = '" + dtrWorkCal["CDATE"].ToString()+ "'"); string strFldName = this.pmGetMapField(dtrWorkCal["CDATE"].ToString()); if (strFldName.Trim() != string.Empty) { //string strFldName = dtaSel[0]["cField"].ToString(); dtrNewWkCtr[strFldName] = Convert.ToDecimal(dtrNewWkCtr[strFldName]) + decCapPerDay; } } } } }
private void pmSetBrowView() { object[] pAPara = null; string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLExec = ""; strSQLExec = "select "; strSQLExec += " MFWORDERHD.CROWID, MFWORDERHD.CCODE, MFWORDERHD.CREFNO, MFWORDERHD.DDATE"; strSQLExec += " from MFWORDERHD "; strSQLExec += " where MFWORDERHD.CCORP = ? and MFWORDERHD.CBRANCH = ? and MFWORDERHD.CPLANT = ? and MFWORDERHD.CREFTYPE = ? and MFWORDERHD.CMFGBOOK = ? "; //if (this.mstrSortKey == "CCODE") //{ // strSQLExec += " and MFWORDERHD.DDATE between ? and ? "; // pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranch, this.mstrPlant, this.mstrRefType, this.mstrBook }; //} //else //{ // strSQLExec += " and MFWORDERHD.CCODE between ? and ? "; // pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranch, this.mstrRefType, this.mstrBook, this.mstrJob, this.mintBGYear }; //} if (this.mstrFilterStep.Trim() != "") { strSQLExec += this.mstrFilterStep; } else { strSQLExec += " and MFWORDERHD.CSTAT <> 'C' and MFWORDERHD.CMSTEP <> 'P' "; } pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranch, this.mstrPlant, this.mstrRefType, this.mstrBook }; pobjSQLUtil.SetPara(pAPara); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, this.mstrRefTable, strSQLExec, ref strErrorMsg); }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLExec = this.mstrBrowViewSQLStr; //strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable }); if (this.mAPara != null && this.mAPara.Length > 0) { pobjSQLUtil.SetPara(this.mAPara); } pobjSQLUtil.NotUpperSQLExecString = true; pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, this.mstrRefTable, strSQLExec, ref strErrorMsg); DataColumn dtcTagValue = new DataColumn("CTAGVALUE", Type.GetType("System.Boolean")); dtcTagValue.DefaultValue = false; this.dtsDataEnv.Tables[this.mstrBrowViewAlias].Columns.Add(dtcTagValue); }
private void pmLoadFormData() { DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dtrBrow != null) { this.mstrEditRowID = dtrBrow["cRowID"].ToString(); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[] { this.mstrEditRowID }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where cRowID = ?", ref strErrorMsg)) { DataRow dtrLoadForm = this.dtsDataEnv.Tables[this.mstrRefTable].Rows[0]; this.txtCode.Text = dtrLoadForm[QBGYearInfo.Field.Code].ToString().TrimEnd(); this.txtDesc.Text = dtrLoadForm[QBGYearInfo.Field.Desc].ToString().TrimEnd(); this.chkIsActive.Checked = (dtrLoadForm[QBGYearInfo.Field.IsActive].ToString().TrimEnd() == "Y"); this.txtYear.Value = Convert.ToInt32(dtrLoadForm[QBGYearInfo.Field.Year]) + 543; this.chkIsLock.Checked = (dtrLoadForm[QBGYearInfo.Field.IsLock].ToString().TrimEnd() == "Y"); } this.pmLoadOldVar(); } }
private void pmLoadWorkCalendarIT() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); int intRow = 0; pobjSQLUtil.SetPara(new object[] { this.mstrEditRowID, "" }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QWkCtrIT", "WkCtrIT", "select * from " + this.mstrITable + " where cWkCtrH = ? and cType = ? order by cSeq", ref strErrorMsg)) { foreach (DataRow dtrWkCtrIT in this.dtsDataEnv.Tables["QWkCtrIT"].Rows) { DataRow dtrNewRow = this.dtsDataEnv.Tables[this.mstrTemWorkHr].NewRow(); intRow++; //dtrNewRow["nRecNo"] = intRow; dtrNewRow["cRowID"] = dtrWkCtrIT["cRowID"].ToString(); dtrNewRow["cMachine"] = dtrWkCtrIT["cResource"].ToString(); this.dtsDataEnv.Tables[this.mstrTemWorkHr].Rows.Add(dtrNewRow); } } }
private void pmAddRow_OPPlanCap(DataRow inSource) { DataRow dr = this.dtsDataEnv.Tables[this.mstrTemOPPlanCap].NewRow(); dr["QcWorkCtr"] = inSource["QcWorkCtr"].ToString(); dr["Code_MO"] = "MO" + inSource["QcBook"].ToString().Trim() + "/" + inSource["CCODE"].ToString(); dr["StartDate"] = Convert.ToDateTime(inSource["dStart"]); dr["DueDate"] = Convert.ToDateTime(inSource["dDueDate"]); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLStr = "select * from MFWKCTRHD where CROWID = ?"; //CWKCTRH decimal decCapPerHour = 0; objSQLHelper.SetPara(new object[] { inSource["CWKCTRH"].ToString() }); if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QWkCtr", "MFWKCTRHD", strSQLStr, ref strErrorMsg)) { //Loop for Load WorkCenter Cap foreach (DataRow dtrWkCtr in this.dtsDataEnv.Tables["QWkCtr"].Rows) { decCapPerHour = Convert.ToDecimal(dtrWkCtr["NCAPACITY"]); } } string strFldName = this.pmGetMapField(Convert.ToDateTime(inSource["DDATE"]).ToString("yyyyMMdd")); if (strFldName.Trim() != string.Empty) { dr[strFldName] = decCapPerHour * Convert.ToDecimal(inSource["nUseHour"]); } this.dtsDataEnv.Tables[mstrTemOPPlanCap].Rows.Add(dr); }
private void pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strFMDBName = App.ConfigurationManager.ConnectionInfo.ERPDBMSName; string strEmplRTab = strFMDBName + ".dbo.EMPLR"; //string strSQLExec = "select {0}.CROWID, {0}.CCODE, {0}.CNAME, {0}.DCREATE, {0}.DLASTUPD, EM1.FCLOGIN as CLOGIN_ADD, EM2.FCLOGIN as CLOGIN_UPD from {0} "; //string strSQLExec = "select {0}.CROWID, {0}.CCODE, {0}.CNAME, EM1.FCLOGIN as CLOGIN_ADD, EM2.FCLOGIN as CLOGIN_UPD from {0} where CCORP = ? "; //strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable }); string strSQLExec = "select BGDEPT.CROWID, BGDEPT.CCODE, BGDEPT.CNAME from BGDEPT where CCORP = ? "; object[] pAPara = new object[] { App.gcCorp }; pobjSQLUtil.SetPara(pAPara); // pobjSQLUtil.NotUpperSQLExecString = true; //pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, "Master_Dept", strSQLExec, ref strErrorMsg); //string strSQLExec = "select BGDEPT.CROWID, BGDEPT.CCODE, BGDEPT.CNAME from BGDEPT where CCORP = ? "; //strSQLExec = string.Format(strSQLExec, new string[] { this.mstrRefTable }); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias, this.mstrRefTable, strSQLExec, ref strErrorMsg); }
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["cCreateBy"] = App.FMAppUserID; } dtrSaveInfo["fcCorp"] = App.gcCorp; dtrSaveInfo["fcBranch"] = this.mstrBranchID; dtrSaveInfo["fcSkid"] = this.mstrEditRowID; dtrSaveInfo["fcRefType"] = this.mstrRefType; dtrSaveInfo["fcCode"] = this.txtCode.Text.TrimEnd(); dtrSaveInfo["FCNAME"] = this.txtName.Text.TrimEnd(); dtrSaveInfo["FCNAME2"] = this.txtName2.Text.TrimEnd(); dtrSaveInfo["fcFChr"] = AppUtil.StringHelper.GetFChr(this.txtName.Text.TrimEnd()); dtrSaveInfo["cLastUpdBy"] = App.FMAppUserID; dtrSaveInfo["fcWHouse"] = this.txtQcWHouse.Tag.ToString(); int intSel = this.cmbRunCodeType.SelectedIndex; string strType = ""; switch (intSel) { case 0: strType = "1"; break; case 1: strType = "2"; break; case 2: strType = "3"; break; } dtrSaveInfo["FCDOCRUNFM"] = strType; 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 pmSetBrowView() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strSQLExec = "select * from BGChartHD where cPRBGChart = ? order by BGChartHD.cCode"; if (this.mstrBGChartGrp != string.Empty) { this.dtsDataEnv.Tables[this.mstrBrowViewAlias].Rows.Clear(); //"select cPRBGChart from BGChartHD where cPRBGChart = ? order by BGChartHD.cCode" decimal decAmt = 0; decimal decRecvAmt = 0; decimal decUseAmt = 0; decimal decBalAmt = 0; DataRow dtrBGChart = null; string strPRChart = ""; pobjSQLUtil.SetPara(new object[] { this.mstrBGChartGrp }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QGrp1", "BGCHARTHD", "select * from BGChartHD where cRowID = ? ", ref strErrorMsg)) { dtrBGChart = this.dtsDataEnv.Tables["QGrp1"].Rows[0]; strPRChart = dtrBGChart["cPRBGChart"].ToString(); if (strPRChart.Trim() == string.Empty) { //Parent Chart เป็นว่าง ๆ แสดงว่าเป็นประเภทหมวดซึ่ง Sum ได้เลย BudgetHelper.SuBeSmartMRPGroup(pobjSQLUtil , App.ActiveCorp.RowID, this.mstrBranch, this.mstrType, this.mintBGYear, this.mstrSect, this.mstrJob, dtrBGChart["cCode"].ToString() , ref decAmt, ref decRecvAmt, ref decUseAmt, ref decBalAmt); DataRow dtrBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].NewRow(); dtrBrow["Type"] = "1"; dtrBrow["QcBGChart"] = dtrBGChart["cCode"].ToString(); dtrBrow["QnBGChart"] = dtrBGChart["cName"].ToString(); dtrBrow["nBGAmt"] = decAmt; dtrBrow["nUseAmt"] = decRecvAmt; dtrBrow["nBalAmt"] = decBalAmt; this.dtsDataEnv.Tables[this.mstrBrowViewAlias].Rows.Add(dtrBrow); } else { pobjSQLUtil.SetPara(new object[] { strPRChart }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QGrp1", "BGCHARTHD", "select * from BGChartHD where cRowID = ? ", ref strErrorMsg)) { dtrBGChart = this.dtsDataEnv.Tables["QGrp1"].Rows[0]; BudgetHelper.SuBeSmartMRPGroup(pobjSQLUtil , App.ActiveCorp.RowID, this.mstrBranch, this.mstrType, this.mintBGYear, this.mstrSect, this.mstrJob, dtrBGChart["cCode"].ToString() , ref decAmt, ref decRecvAmt, ref decUseAmt, ref decBalAmt); DataRow dtrBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].NewRow(); dtrBrow["Type"] = "1"; dtrBrow["QcBGChart"] = dtrBGChart["cCode"].ToString(); dtrBrow["QnBGChart"] = dtrBGChart["cName"].ToString(); dtrBrow["nBGAmt"] = decAmt; dtrBrow["nUseAmt"] = decRecvAmt; dtrBrow["nBalAmt"] = decBalAmt; this.dtsDataEnv.Tables[this.mstrBrowViewAlias].Rows.Add(dtrBrow); } //กรณีมี Parent จะดึงรหัสใน Parent เดียวกันมาแสดง pobjSQLUtil.SetPara(new object[] { strPRChart }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QGrp1", "BGCHARTHD", "select * from BGChartHD where cPRBGChart = ? ", ref strErrorMsg)) { foreach (DataRow dtrP1Brow in this.dtsDataEnv.Tables["QGrp1"].Rows) { dtrBGChart = dtrP1Brow; BudgetHelper.SuBeSmartMRPGroup(pobjSQLUtil , App.ActiveCorp.RowID, this.mstrBranch, this.mstrType, this.mintBGYear, this.mstrSect, this.mstrJob, dtrBGChart["cCode"].ToString() , ref decAmt, ref decRecvAmt, ref decUseAmt, ref decBalAmt); DataRow dtrBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].NewRow(); dtrBrow["Type"] = "2"; dtrBrow["QcBGChart"] = dtrBGChart["cCode"].ToString(); dtrBrow["QnBGChart"] = dtrBGChart["cName"].ToString(); dtrBrow["nBGAmt"] = decAmt; dtrBrow["nUseAmt"] = decRecvAmt; dtrBrow["nBalAmt"] = decBalAmt; this.dtsDataEnv.Tables[this.mstrBrowViewAlias].Rows.Add(dtrBrow); } } } } } }
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["cCreateBy"] = App.FMAppUserID; } dtrSaveInfo["fcCorp"] = App.ActiveCorp.RowID; dtrSaveInfo["fcSkid"] = this.mstrEditRowID; dtrSaveInfo["fcType"] = "G"; dtrSaveInfo["fcCode"] = this.txtCode.Text.TrimEnd(); dtrSaveInfo["fcName"] = this.txtName.Text.TrimEnd(); //dtrSaveInfo["cFChr"] = AppUtil.StringHelper.GetFChr(this.txtName.Text.TrimEnd()); dtrSaveInfo["fcName2"] = this.txtName2.Text.TrimEnd(); //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, "FCSKID", bllIsNewRow, ref strSQLUpdateStr, ref pAPara); this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran); //Business.Entity.QMasterUM QRefChild = new QMasterUM(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(); } }
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 pmSetBrowView2() { UIBase.WaitWind("Loading รายการสินค้า..."); string strErrorMsg = " "; string strSQLStr = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); object[] pAPara = null; pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranch, this.mstrRefType, this.mstrCoor, this.mstrProd, this.mstrBook }; strSQLStr = " "; strSQLStr += " select "; strSQLStr += " (select H.FCREFNO from ORDERH H where H.FCSKID = ORDERI.FCORDERH) as FCREFNO "; strSQLStr += " , (select H.FCCODE from ORDERH H where H.FCSKID = ORDERI.FCORDERH) as FCCODE "; strSQLStr += " , (select H.FDDATE from ORDERH H where H.FCSKID = ORDERI.FCORDERH) as FDDATE "; strSQLStr += " , (select P.FCCODE from PROD P where P.FCSKID = ORDERI.FCPROD) as QCPROD "; strSQLStr += " , (select P.FCNAME from PROD P where P.FCSKID = ORDERI.FCPROD) as QNPROD "; strSQLStr += " , (select C.FCCODE from COOR C where C.FCSKID = ORDERI.FCCOOR) as QCCOOR "; strSQLStr += " , (select C.FCNAME from COOR C where C.FCSKID = ORDERI.FCCOOR) as QNCOOR "; strSQLStr += " , sum(ORDERI.FNBACKQTY) as FNBACKQTY "; strSQLStr += " , ORDERI.FCSKID, ORDERI.FCORDERH , ORDERI.FCCOOR, ORDERI.FCPROD"; strSQLStr += " from ORDERI "; strSQLStr += " left join PROD on PROD.FCSKID = ORDERI.FCPROD "; strSQLStr += " left join COOR on COOR.FCSKID = ORDERI.FCCOOR "; strSQLStr += " left join ORDERH on ORDERH.FCSKID = ORDERI.FCORDERH "; //strSQLStr += " left join BOOK on BOOK.FCSKID = BOOK.FCBOOK "; strSQLStr += " where ORDERI.FCCORP = ? "; strSQLStr += " and ORDERI.FCBRANCH = ? "; strSQLStr += " and ORDERI.FCREFTYPE = ? "; strSQLStr += " and ORDERI.FCSTEP <> 'P' "; strSQLStr += " and ORDERI.FCSTEP <> 'L' "; strSQLStr += " and ORDERI.FCCOOR = ? "; strSQLStr += " and ORDERI.FCPROD = ? "; strSQLStr += " and ORDERI.FNBACKQTY <> 0 "; strSQLStr += " and ORDERH.FCBOOK = ? "; strSQLStr += " group by ORDERI.FCSKID, ORDERI.FCORDERH , ORDERI.FCCOOR, ORDERI.FCPROD "; strSQLStr += " order by FCREFNO,QCPROD,QCCOOR "; pobjSQLUtil.SetPara(pAPara); pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrBrowViewAlias2, this.mstrRefTable, strSQLStr, ref strErrorMsg); for (int i = 0; i < this.dtsDataEnv.Tables[this.mstrBrowViewAlias2].Rows.Count; i++) { DataRow dtrBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias2].Rows[i]; decimal decCutQty = pmSumCutQty2(dtrBrow["FCSKID"].ToString()); decimal decBackQty = Convert.ToDecimal(dtrBrow["FNBACKQTY"]); decimal decMOQty = decBackQty - decCutQty; dtrBrow["FNBACKQTY"] = decMOQty; if (decMOQty <= 0) { //this.dtsDataEnv.Tables[this.mstrBrowViewAlias2].Rows[i].Delete(); this.dtsDataEnv.Tables[this.mstrBrowViewAlias2].Rows.RemoveAt(i); } } DataColumn dtcTagValue = new DataColumn("CTAGVALUE", Type.GetType("System.Boolean")); dtcTagValue.DefaultValue = false; this.dtsDataEnv.Tables[this.mstrBrowViewAlias2].Columns.Add(dtcTagValue); UIBase.WaitClear(); }
private static void pmSaveKeepLog(WS.Data.Agents.cDBMSAgent inSQLHelper, Entity.KeepLogType inType, string inTaskName, string inCode, string inName, string inAppUser, string inLoginName, string inOldCode, string inOldName) { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = inSQLHelper; objSQLHelper.SetPara(new object[] { inTaskName }); if (objSQLHelper.SQLExec(ref KeepLogAgent.dtsDataEnv, "QAppObj", MapTable.Table.AppObj, "select * from " + MapTable.Table.AppObj + " where cTaskName = ?", ref strErrorMsg)) { DataRow dtrAppObj = KeepLogAgent.dtsDataEnv.Tables["QAppObj"].Rows[0]; //string strMenuName = dtrAppObj["cText"].ToString(); string strMenuName = dtrAppObj["cDesc"].ToString(); string strUpdType = ""; switch (inType) { case Entity.KeepLogType.Insert: strUpdType = BusinessEnum.gc_KEEPLOG_TYPE_INSERT; break; case Entity.KeepLogType.Update: strUpdType = BusinessEnum.gc_KEEPLOG_TYPE_UPDATE; break; case Entity.KeepLogType.Delete: strUpdType = BusinessEnum.gc_KEEPLOG_TYPE_DELETE; break; case Entity.KeepLogType.LogIn: strUpdType = BusinessEnum.gc_KEEPLOG_TYPE_LOG_IN; break; case Entity.KeepLogType.LogOut: strUpdType = BusinessEnum.gc_KEEPLOG_TYPE_LOG_OUT; break; case Entity.KeepLogType.Print: strUpdType = BusinessEnum.gc_KEEPLOG_TYPE_PRINT; break; } DataRow dtrSaveInfo = null; objSQLHelper.SQLExec(ref KeepLogAgent.dtsDataEnv, mstrRefTable, mstrRefTable, "select * from " + mstrRefTable + " where 0=1", ref strErrorMsg); dtrSaveInfo = KeepLogAgent.dtsDataEnv.Tables[mstrRefTable].NewRow(); WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance(); dtrSaveInfo["cRowID"] = objConn.RunRowID(mstrRefTable); dtrSaveInfo["cCorp"] = KeepLogAgent.CORPID; dtrSaveInfo["cType"] = strUpdType; dtrSaveInfo["cTaskName"] = inTaskName; //=> à»ÅÕèÂ¹ä» Select join ¡Ñº AppObj.cDesc1 á·¹ //dtrSaveInfo["cMenuName"] = strMenuName.TrimEnd(); dtrSaveInfo["cCode"] = inCode; dtrSaveInfo["cName"] = inName; dtrSaveInfo["cOldCode"] = inOldCode; dtrSaveInfo["cOldName"] = inOldName; dtrSaveInfo["cLoginName"] = inLoginName; dtrSaveInfo["cMachine"] = System.Environment.MachineName; dtrSaveInfo["cCreateBy"] = inAppUser; string strSQLUpdateStr = ""; object[] pAPara = null; cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "CROWID", true, ref strSQLUpdateStr, ref pAPara); objSQLHelper.SetPara(pAPara); objSQLHelper.SQLExec(strSQLUpdateStr, ref strErrorMsg); } }