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