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.txtSName.Text = dtrLoadForm["fcSName"].ToString().TrimEnd(); this.txtName2.Text = dtrLoadForm["fcName2"].ToString().TrimEnd(); this.txtSName2.Text = dtrLoadForm["fcSName2"].ToString().TrimEnd(); //this.txtAddr11.Text = dtrLoadForm[QCoorInfo.Field.Addr1].ToString().TrimEnd(); //this.txtAddr12.Text = dtrLoadForm[QCoorInfo.Field.Addr2].ToString().TrimEnd(); //this.txtAddr21.Text = dtrLoadForm[QCoorInfo.Field.Addr12].ToString().TrimEnd(); //this.txtAddr22.Text = dtrLoadForm[QCoorInfo.Field.Addr22].ToString().TrimEnd(); this.txtTel.Text = dtrLoadForm[QCoorInfo.Field.TelNo].ToString().TrimEnd(); //this.txtFax.Text = dtrLoadForm[QCoorInfo.Field.FaxNo].ToString().TrimEnd(); string gcTemStr01 = (Convert.IsDBNull(dtrLoadForm["fmMemData"]) ? "" : dtrLoadForm["fmMemData"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData2"]) ? "" : dtrLoadForm["fmMemData2"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData3"]) ? "" : dtrLoadForm["fmMemData3"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData4"]) ? "" : dtrLoadForm["fmMemData4"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData5"]) ? "" : dtrLoadForm["fmMemData5"].ToString().TrimEnd()); this.txtAddr11.Text = BizRule.GetMemData(gcTemStr01, x_CMAd11); this.txtAddr21.Text = BizRule.GetMemData(gcTemStr01, x_CMAd21); //this.txtAddr31.Text = BizRule.GetMemData(gcTemStr01, x_CMAd31); this.txtAddr12.Text = BizRule.GetMemData(gcTemStr01, x_CMAd12); this.txtAddr22.Text = BizRule.GetMemData(gcTemStr01, x_CMAd22); //this.txtAddr32.Text = BizRule.GetMemData(gcTemStr01, x_CMAd32); this.txtFax.Text = BizRule.GetMemData(gcTemStr01, x_CMFax); this.txtZip.Text = dtrLoadForm["fcZip"].ToString().TrimEnd(); this.txtTel.Text = BizRule.GetMemData(gcTemStr01, x_CMTel); this.txtTaxID.Text = BizRule.GetMemData(gcTemStr01, x_CMTaxId); } this.pmLoadOldVar(); } }
private void pmLoadRemark(string inProd) { this.mstrRemark1 = ""; this.mstrRemark2 = ""; this.mstrRemark3 = ""; this.mstrRemark4 = ""; this.mstrRemark5 = ""; this.mstrRemark6 = ""; this.mstrRemark7 = ""; this.mstrRemark8 = ""; this.mstrRemark9 = ""; this.mstrRemark10 = ""; string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); pobjSQLUtil.SetPara(new object[] { inProd }); if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QProdX4", "PRODX4", "select * from ProdX4 where fcProd = ?", ref strErrorMsg)) { DataRow dtrProdX4 = this.dtsDataEnv.Tables["QProdX4"].Rows[0]; string gcTemStr01 = (Convert.IsDBNull(dtrProdX4["fmMemData"]) ? "" : dtrProdX4["fmMemData"].ToString().TrimEnd()); string gcTemStr02 = (Convert.IsDBNull(dtrProdX4["fmMemData2"]) ? "" : dtrProdX4["fmMemData2"].ToString().TrimEnd()); string gcTemStr03 = (Convert.IsDBNull(dtrProdX4["fmMemData3"]) ? "" : dtrProdX4["fmMemData3"].ToString().TrimEnd()); string gcTemStr04 = (Convert.IsDBNull(dtrProdX4["fmMemData4"]) ? "" : dtrProdX4["fmMemData4"].ToString().TrimEnd()); string gcTemStr05 = (Convert.IsDBNull(dtrProdX4["fmMemData5"]) ? "" : dtrProdX4["fmMemData5"].ToString().TrimEnd()); this.mstrRemark1 = BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem); this.mstrRemark2 = BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem2); this.mstrRemark3 = BizRule.GetMemData(gcTemStr02, frmProd.xdCMRem3); this.mstrRemark4 = BizRule.GetMemData(gcTemStr02, frmProd.xdCMRem4); this.mstrRemark5 = BizRule.GetMemData(gcTemStr03, frmProd.xdCMRem5); this.mstrRemark6 = BizRule.GetMemData(gcTemStr03, frmProd.xdCMRem6); this.mstrRemark7 = BizRule.GetMemData(gcTemStr04, frmProd.xdCMRem7); this.mstrRemark8 = BizRule.GetMemData(gcTemStr04, frmProd.xdCMRem8); this.mstrRemark9 = BizRule.GetMemData(gcTemStr05, frmProd.xdCMRem9); this.mstrRemark10 = BizRule.GetMemData(gcTemStr05, frmProd.xdCMRem10); } }
public static void SetActiveCorp(DataRow inCorp) { App.gcCorp = inCorp["fcSkid"].ToString(); App.gcCorpName = inCorp["fcName"].ToString().TrimEnd(); App.gcCorpName2 = inCorp["fcName2"].ToString().TrimEnd(); App.gcCorpSaleVATType = (inCorp["fcVatType"].ToString() != string.Empty ? inCorp["fcVatType"].ToString() : "1"); App.gdStartCorpDate = Convert.ToDateTime(inCorp["fdCalDate"]); BeSmartMRP.Business.Agents.KeepLogAgent.CORPID = inCorp["fcSkid"].ToString(); System.Data.DataSet dtsCorp = new System.Data.DataSet(); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); WS.Data.Agents.cDBMSAgent objSQLHelper2 = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); objSQLHelper2.SetPara(new object[] { App.AppUserID }); if (objSQLHelper2.SQLExec(ref dtsCorp, "QEmplR", "EMPLR", "select * from AppLogin where cRowID = ? ", ref strErrorMsg)) { DataRow dtrEmpl = dtsCorp.Tables["QEmplR"].Rows[0]; App.mLocale_UI = UIHelper.AppEnum.GetLocaleEnum(dtrEmpl[QAppLogInInfo.Field.Locale_UI].ToString().TrimEnd()); App.mLocale_Report = UIHelper.AppEnum.GetLocaleEnum(dtrEmpl[QAppLogInInfo.Field.Locale_Report].ToString().TrimEnd()); string strLocale = "en-US"; switch (App.mLocale_UI) { case AppLocale.th_TH: strLocale = "th-TH"; break; case AppLocale.en_US: strLocale = "en-US"; break; } pmSetAppCulture(strLocale); } ActiveCorp.RowID = inCorp["fcSkid"].ToString(); ActiveCorp.CorpChar = inCorp["fcCorpChar"].ToString(); ActiveCorp.Code = inCorp["fcCode"].ToString(); ActiveCorp.Name = inCorp["fcName"].ToString().TrimEnd(); ActiveCorp.Name2 = inCorp["fcName2"].ToString().TrimEnd(); ActiveCorp.StartAppDate = Convert.ToDateTime(inCorp["fdCalDate"]); ActiveCorp.Address1 = inCorp["fcAddr1"].ToString().TrimEnd(); ActiveCorp.Address2 = inCorp["fcAddr2"].ToString().TrimEnd(); ActiveCorp.Address12 = inCorp["fcAddr12"].ToString().TrimEnd(); ActiveCorp.Address22 = inCorp["fcAddr22"].ToString().TrimEnd(); ActiveCorp.ShowFormulaCompo = (inCorp["fcShowComp"].ToString().TrimEnd() != string.Empty ? inCorp["fcShowComp"].ToString() : "1"); ActiveCorp.TelNo = inCorp["fcTel"].ToString().TrimEnd(); ActiveCorp.FaxNo = inCorp["fcFax"].ToString().TrimEnd(); //ActiveCorp.TaxID = inCorp["fcTaxID"].ToString().TrimEnd(); ActiveCorp.TaxID = inCorp["FCTRADENO"].ToString().TrimEnd(); ActiveCorp.SaleVATIsOut = (inCorp["fcVatIsOut"].ToString() != string.Empty ? inCorp["fcVatIsOut"].ToString() : "Y"); ActiveCorp.SaleVATType = (inCorp["fcVatType"].ToString() != string.Empty ? inCorp["fcVatType"].ToString() : "1"); ActiveCorp.SCtrlStock = (inCorp["fcCtrlStoc"].ToString().TrimEnd() != string.Empty ? inCorp["fcCtrlStoc"].ToString().TrimEnd() : "1"); ActiveCorp.CostMethod_Goods = (inCorp["fcGoodsCos"].ToString().TrimEnd() != string.Empty ? inCorp["fcGoodsCos"].ToString().TrimEnd() : "A"); ActiveCorp.CostMethod_Rawmat = (inCorp["fcRawCost"].ToString().TrimEnd() != string.Empty ? inCorp["fcRawCost"].ToString().TrimEnd() : "A"); objSQLHelper.SetPara(new object[1] { inCorp["fcSect"].ToString() }); if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Sect", "Sect", "select * from Sect where fcSkid = ? ", ref strErrorMsg)) { App.ActiveCorp.DefaultSectID = dtsCorp.Tables["QVFLD_Sect"].Rows[0]["fcSkid"].ToString(); objSQLHelper.SetPara(new object[1] { dtsCorp.Tables["QVFLD_Sect"].Rows[0]["fcDept"].ToString() }); if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Dept", "Dept", "select * from Dept where fcSkid = ?", ref strErrorMsg)) { App.ActiveCorp.DefaultDeptID = dtsCorp.Tables["QVFLD_Dept"].Rows[0]["fcSkid"].ToString(); } } objSQLHelper.SetPara(new object[1] { inCorp["fcProj"].ToString() }); if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Proj", "Proj", "select * from Proj where fcSkid = ? ", ref strErrorMsg)) { App.ActiveCorp.DefaultProjectID = dtsCorp.Tables["QVFLD_Proj"].Rows[0]["fcSkid"].ToString(); } objSQLHelper.SetPara(new object[1] { inCorp["fcJob"].ToString() }); if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Job", "Job", "select * from Job where fcSkid = ? ", ref strErrorMsg)) { App.ActiveCorp.DefaultJobID = dtsCorp.Tables["QVFLD_Job"].Rows[0]["fcSkid"].ToString(); } App.ActiveCorp.MMQtyFormatString = "#,###,###.0000"; App.ActiveCorp.PriceFormatString = "#,###,###.0000"; string strQtyPict = inCorp["fcQtyPict"].ToString(); string[] aText = strQtyPict.Split(".".ToCharArray()); if (aText.Length > 1) { App.ActiveCorp.QtyFormatString = AppUtil.StringHelper.ChrTran(aText[0].Trim(), "9", "#") + "." + AppUtil.StringHelper.ChrTran(aText[1].Trim(), "9", "0"); } else { App.ActiveCorp.QtyFormatString = AppUtil.StringHelper.ChrTran(aText[0].Trim(), "9", "#"); } string strRemark = (Convert.IsDBNull(inCorp["fmMemData"]) ? "" : inCorp["fmMemData"].ToString().TrimEnd()); strRemark += (Convert.IsDBNull(inCorp["fmMemData2"]) ? "" : inCorp["fmMemData2"].ToString().TrimEnd()); string strCorpVouCentMode = BizRule.GetMemData(strRemark, "VRM"); string strCorpVouRunLen = BizRule.GetMemData(strRemark, "VLN"); int intCorpVouRunLen = 4; try { intCorpVouRunLen = Convert.ToInt32(strCorpVouRunLen); } catch { } //App.ActiveCorp.CorpVouCentMode = (strCorpVouCentMode == "" ? "1" : strCorpVouCentMode); //App.ActiveCorp.CorpVouRunLen = (intCorpVouRunLen < 4 ? 4 : intCorpVouRunLen); }
private void pmPrintData() { Cursor currentCursor = Cursor.Current; Cursor.Current = Cursors.WaitCursor; App.MoreProcess = true; App.AppMessage = "Start Extract Data..."; string strSQLStr = "select TRADETRM.FCCODE as QcTradeTrm,TRADETRM.FCNAME as QnTradeTrm"; strSQLStr = strSQLStr + " ,Coor.fcCode as QcCoor,Coor.fcName as QnCoor,Coor.fcPersonTy,COOR.FMMEMDATA as FMCMMEMDATA,COOR.FMMEMDATA2 as FMCMMEMDATA2,COOR.FMMEMDATA3 as FMCMMEMDATA3,COOR.FMMEMDATA4 as FMCMMEMDATA4,COOR.FMMEMDATA5 as FMCMMEMDATA5"; strSQLStr = strSQLStr + " ,GLRef.* from GLRef "; strSQLStr = strSQLStr + " left join BOOK on Book.fcSkid = GLRef.fcBook "; strSQLStr = strSQLStr + " left join COOR on COOR.FCSKID = GLREF.FCCOOR "; strSQLStr = strSQLStr + " left join TRADETRM on GLREF.FCTRADETRM = TRADETRM.FCSKID "; strSQLStr = strSQLStr + " where GLRef.fcCorp = ? "; strSQLStr = strSQLStr + " and GLRef.fcBranch = ? "; strSQLStr = strSQLStr + " and GLRef.fcVatType in ( select VatType.fcCode from VatType where VatType.fcCode between ? and ?) "; strSQLStr = strSQLStr + " and GLRef.fdReceDate between ? and ? "; strSQLStr = strSQLStr + " and GLRef.fcRfType in ('F', 'S', 'E', 'K')"; strSQLStr = strSQLStr + " and GLRef.fcVatDue = 'Y' "; strSQLStr = strSQLStr + " and GLRef.FCISHOLD = '' "; strSQLStr = strSQLStr + this.mstrBookPrefix; strSQLStr = strSQLStr + " order by GLRef.fdDate, GLRef.fcRefNo"; Report.LocalDataSet.DTSPVAT dtsPrintPreview = new Report.LocalDataSet.DTSPVAT(); string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); DateTime dttBegDate = new DateTime(this.txtBegDate.DateTime.Year, this.txtBegDate.DateTime.Month, 1); //DateTime dttEndDate = new DateTime(this.txtEndDate.DateTime.Year, this.txtEndDate.DateTime.Month + 1, 1).AddDays(-1); DateTime dttEndDate = new DateTime(this.txtEndDate.DateTime.Year, this.txtEndDate.DateTime.Month, 1).AddMonths(1).AddDays(-1); //MessageBox.Show(dttEndDate.ToString("dd/MM/yyyy")); objSQLHelper.SetPara(new object[] { App.ActiveCorp.RowID, this.txtQcBranch.Tag.ToString(), this.txtBegVat.Text, this.txtEndVat.Text, dttBegDate.Date, dttEndDate.Date }); if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QGLRef", "GLRef", strSQLStr, ref strErrorMsg)) { foreach (DataRow dtrGLRef in this.dtsDataEnv.Tables["QGLRef"].Rows) { DataRow dtrPreview = dtsPrintPreview.XRPVAT.NewRow(); string strDetail = ""; string strRemark = (Convert.IsDBNull(dtrGLRef["fmMemData"]) ? "" : dtrGLRef["fmMemData"].ToString().TrimEnd()); strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData2"]) ? "" : dtrGLRef["fmMemData2"].ToString().TrimEnd()); strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData3"]) ? "" : dtrGLRef["fmMemData3"].ToString().TrimEnd()); strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData4"]) ? "" : dtrGLRef["fmMemData4"].ToString().TrimEnd()); if (dtrGLRef["fmMemData5"] != null) { strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData5"]) ? "" : dtrGLRef["fmMemData5"].ToString().TrimEnd()); } //strDetail = BizRule.GetMemData(strRemark, "Det"); strDetail = dtrGLRef["QnCoor"].ToString().Trim(); string gcTemStr01 = (Convert.IsDBNull(dtrGLRef["fmCmMemData"]) ? "" : dtrGLRef["fmCmMemData"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData2"]) ? "" : dtrGLRef["fmCmMemData2"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData3"]) ? "" : dtrGLRef["fmCmMemData3"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData4"]) ? "" : dtrGLRef["fmCmMemData4"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData5"]) ? "" : dtrGLRef["fmCmMemData5"].ToString().TrimEnd()); string strMTaxID = BizRule.GetMemData(gcTemStr01, "MId"); string strTaxID = BizRule.GetMemData(gcTemStr01, "Tax"); string strBizType = BizRule.GetMemData(gcTemStr01, "TBu"); string strTax = ""; if (dtrGLRef["QcCoor"].ToString().Trim() == "-") { strTax = dtrGLRef["fcRecvMan"].ToString().Trim(); } else { if (dtrGLRef["fcPersonTy"].ToString() == "Y") { strTax = strTaxID; } else { strTax = strMTaxID; } } //App.WriteEventsLog2(dtrGLRef["fcRefNo"].ToString()); //decimal decAmt = Convert.ToDecimal(dtrGLRef["fnAmtKe"]) - Convert.ToDecimal(dtrGLRef["nCostAdj1"]) - Convert.ToDecimal(dtrGLRef["nCostAdj2"]); decimal decAmt = Convert.ToDecimal(dtrGLRef["fnAmtKe"]); //decimal decAmt = Convert.ToDecimal(dtrGLRef["fnAmtKe"]); decimal decVATAmt = Convert.ToDecimal(dtrGLRef["fnVatAmt"]); decAmt = decAmt * Convert.ToDecimal(dtrGLRef["fnXRate"]) * (dtrGLRef["fcRfType"].ToString() == "F" ? -1 : 1); decVATAmt = decVATAmt * (dtrGLRef["fcRfType"].ToString() == "F" ? -1 : 1); if (dtrGLRef["fcStat"].ToString() == "C") { decAmt = 0; decVATAmt = 0; } dtrPreview["CSTAT"] = dtrGLRef["fcStat"].ToString(); dtrPreview["CVATTYPE"] = dtrGLRef["fcVatType"].ToString(); dtrPreview["DDATE"] = Convert.ToDateTime(dtrGLRef["fdDate"]); dtrPreview["CREFTYPE"] = dtrGLRef["fcRefType"].ToString(); dtrPreview["CREFNO"] = dtrGLRef["fcRefNo"].ToString(); dtrPreview["CDETAIL"] = strDetail; dtrPreview["NAMT"] = decAmt; dtrPreview["NVATAMT"] = decVATAmt; //fcRecvMan dtrPreview["TaxID"] = strTax; if (!Convert.IsDBNull(dtrGLRef["QCTradeTrm"])) { dtrPreview["QCTRADETRM"] = dtrGLRef["QcTradeTrm"].ToString().TrimEnd(); dtrPreview["QNTRADETRM"] = dtrGLRef["QnTradeTrm"].ToString().TrimEnd(); } dtrPreview["BIZTYPE"] = strBizType; dtsPrintPreview.XRPVAT.Rows.Add(dtrPreview); } this.pmPreviewReport(dtsPrintPreview); } else { //this.EndReport(); MessageBox.Show("ไม่มีข้อมูล"); } }
private void pmPrintData() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); string strCriteria = ""; string strOrderBy = ""; string strBegValue = ""; string strEndValue = ""; strOrderBy = "Master_Coor." + this.mstrOrderBy; if (this.cmbWRng.SelectedIndex == 0) { strCriteria = strOrderBy + " between ? and ?"; objSQLHelper.SetPara(new object[] { this.txtBegCode.Text.TrimEnd(), this.txtEndCode.Text.TrimEnd() }); } else { strCriteria = " Master_Coor.cCode in (" + this.pmGetRngCode() + ")"; } Report.LocalDataSet.DTSPCOOR dtsPrintPreview = new Report.LocalDataSet.DTSPCOOR(); string strSQLStr = "select Master_Coor.* from " + MapTable.Table.MasterCoor; strSQLStr += " where "; strSQLStr += strCriteria + " order by " + strOrderBy; if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QCoor", "Coor", strSQLStr, ref strErrorMsg)) { foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QCoor"].Rows) { DataRow dtrPreview = dtsPrintPreview.XRPCOOR.NewRow(); dtrPreview["cCode"] = dtrPData["cCode"].ToString(); dtrPreview["cName"] = dtrPData["cName"].ToString(); dtrPreview["cName2"] = dtrPData["cName2"].ToString(); string gcTemStr01 = (Convert.IsDBNull(dtrPData["cMemData"]) ? "" : dtrPData["cMemData"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData2"]) ? "" : dtrPData["cMemData2"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData3"]) ? "" : dtrPData["cMemData3"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData4"]) ? "" : dtrPData["cMemData4"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData5"]) ? "" : dtrPData["cMemData5"].ToString().TrimEnd()); string strCTName = dtrPData["cContactN"].ToString().TrimEnd(); string strAddr11 = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMAd11); string strAddr21 = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMAd21); string strAddr31 = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMAd31); string strZip = dtrPData["cZip"].ToString().TrimEnd(); string strTel = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMTel); string strFax = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMFax); decimal decCredTerm = Convert.ToInt32(dtrPData["nCredTerm"]); decimal decCredLim = Convert.ToDecimal(dtrPData["nCredLim"]); dtrPreview["cCtName"] = strCTName; dtrPreview["cAddr"] = strAddr11 + " " + strAddr21 + " " + strAddr31 + " " + strZip; dtrPreview["cTel"] = strTel; dtrPreview["cFax"] = strFax; dtrPreview["nCredTerm"] = decCredTerm; dtrPreview["nCredLim"] = decCredLim; dtsPrintPreview.XRPCOOR.Rows.Add(dtrPreview); } if (dtsPrintPreview.XRPCOOR.Rows.Count > 0) { this.pmPreviewReport(dtsPrintPreview); } } }
private void pmPrintData() { string strErrorMsg = ""; WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside); WS.Data.Agents.cDBMSAgent pobjSQLUtil2 = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside); string strCriteria = ""; string strOrderBy = ""; string strBegValue = ""; string strEndValue = ""; strOrderBy = "Master_Prod." + this.mstrOrderBy; string strOrderBy2 = ""; switch (this.cmbPOrderBy.SelectedIndex) { case 0: strOrderBy2 = "Master_PdGrp.cCode, Master_Prod.cType, Master_Prod.cCode"; break; case 1: strOrderBy2 = "Master_PdGrp.cCode, Master_Prod.cType, Master_Prod.cName, Master_Prod.cCode"; break; case 2: strOrderBy2 = "Master_Prod.cCode"; break; case 3: strOrderBy2 = "Master_Prod.cName"; break; } strOrderBy = "Master_Prod." + this.mstrOrderBy; if (this.cmbWRng.SelectedIndex == 0) { strCriteria = strOrderBy + " between ? and ?"; objSQLHelper.SetPara(new object[] { this.txtBegCode.Text.TrimEnd(), this.txtEndCode.Text.TrimEnd() }); } else { strCriteria = " Master_Prod.cCode in (" + this.pmGetRngCode() + ")"; } if (this.pATagPdType.Count > 0) { strCriteria += " and Master_Prod.cType in (" + this.pmGetRngCode2() + ")"; } if (this.pATagPdGrp.Count > 0) { strCriteria += " and Master_PdGrp.cCode in (" + this.pmGetRngCode3() + ")"; } Report.LocalDataSet.DTSPPROD dtsPrintPreview = new Report.LocalDataSet.DTSPPROD(); string strAcChartFld = " , AcChart1.cCode as QcAcChart, AcChart1.cName as QnAcChart "; strAcChartFld += " , AcChart2.cCode as QcAcChart2, AcChart2.cName as QnAcChart2 "; strAcChartFld += " , Master_PdGrp.cCode as QcPdGrp, Master_PdGrp.cName as QnPdGrp "; strAcChartFld += " , Master_UM.cCode as QcUM, Master_UM.cName as QnUM "; string strSQLStr = "select Master_Prod.* " + strAcChartFld + " from " + MapTable.Table.MasterProd; strSQLStr += " left join Master_PdGrp on Master_PdGrp.cRowID = Master_Prod.cPdGrp "; strSQLStr += " left join Master_UM on Master_UM.cRowID = Master_Prod.cUM "; strSQLStr += " left join Master_AcChart AcChart1 on AcChart1.cRowID = Master_Prod.cAccBCash "; strSQLStr += " left join Master_AcChart AcChart2 on AcChart2.cRowID = Master_Prod.cAccBCred "; strSQLStr += " where "; strSQLStr += strCriteria + " order by " + strOrderBy2; if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QProd", "Prod", strSQLStr, ref strErrorMsg)) { foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QProd"].Rows) { DataRow dtrPreview = dtsPrintPreview.XRPPROD.NewRow(); dtrPreview["cCode"] = dtrPData["cCode"].ToString(); dtrPreview["cName"] = dtrPData["cName"].ToString(); dtrPreview["cSName"] = dtrPData["cSName"].ToString(); dtrPreview["cName2"] = dtrPData["cName2"].ToString(); dtrPreview["cQcPdGrp"] = dtrPData["QcPdGrp"].ToString(); dtrPreview["cQnPdGrp"] = dtrPData["QnPdGrp"].ToString(); dtrPreview["cQcUM"] = dtrPData["QcUM"].ToString(); dtrPreview["cQnUM"] = dtrPData["QnUM"].ToString(); dtrPreview["cQcAcChart"] = dtrPData["QcAcChart"].ToString(); dtrPreview["cQnAcChart"] = dtrPData["QnAcChart"].ToString(); dtrPreview["cQcAcChart2"] = dtrPData["QcAcChart2"].ToString(); dtrPreview["cQnAcChart2"] = dtrPData["QnAcChart2"].ToString(); pobjSQLUtil2.SetPara(new object[] { dtrPData["cType"].ToString() }); if (pobjSQLUtil2.SQLExec(ref this.dtsDataEnv, "QPdType", "PDTYPE", "select * from PRODTYPE where FCCODE = ?", ref strErrorMsg)) { DataRow dtrPdType = this.dtsDataEnv.Tables["QPdType"].Rows[0]; dtrPreview["cQcPdType"] = dtrPdType["fcCode"].ToString(); dtrPreview["cQnPdType"] = dtrPdType["fcName"].ToString(); } dtrPreview["cVatIsOut"] = (dtrPData["cVatIsOut"].ToString() == "Y" ? "N" : "Y"); dtrPreview["cCtrlStock"] = dtrPData["cCtrlStoc"].ToString(); string gcTemStr01 = (Convert.IsDBNull(dtrPData["cMemData"]) ? "" : dtrPData["cMemData"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData2"]) ? "" : dtrPData["cMemData2"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData3"]) ? "" : dtrPData["cMemData3"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData4"]) ? "" : dtrPData["cMemData4"].ToString().TrimEnd()); gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData5"]) ? "" : dtrPData["cMemData5"].ToString().TrimEnd()); string strRemark1 = BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem2); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem3); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem4); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem5); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem6); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem7); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem8); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem9); strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem10); dtrPreview["cRemark"] = strRemark1; dtsPrintPreview.XRPPROD.Rows.Add(dtrPreview); } if (dtsPrintPreview.XRPPROD.Rows.Count > 0) { this.pmPreviewReport(dtsPrintPreview); } } }