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_PdGrp." + 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_PdGrp.cCode in (" + this.pmGetRngCode() + ")";
}
Report.LocalDataSet.DTSACCHART dtsPrintPreview = new Report.LocalDataSet.DTSACCHART();
string strAcChartFld = " , AcChart1.cCode as QcAcChart, AcChart1.cName as QnAcChart ";
strAcChartFld += " , AcChart2.cCode as QcAcChart2, AcChart2.cName as QnAcChart2 ";
string strSQLStr = "select Master_PdGrp.* " + strAcChartFld + " from " + MapTable.Table.MasterPdGrp;
strSQLStr += " left join Master_AcChart AcChart1 on AcChart1.cRowID = Master_PdGrp.cAccBCash ";
strSQLStr += " left join Master_AcChart AcChart2 on AcChart2.cRowID = Master_PdGrp.cAccBCred ";
strSQLStr += " where ";
strSQLStr += strCriteria + " order by " + strOrderBy;
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QPdGrp", "PdGrp", strSQLStr, ref strErrorMsg))
{
foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QPdGrp"].Rows)
{
DataRow dtrPreview = dtsPrintPreview.XRPACCHART.NewRow();
dtrPreview["cCode"] = dtrPData["cCode"].ToString();
dtrPreview["cName"] = dtrPData["cName"].ToString();
dtrPreview["cName2"] = dtrPData["cName2"].ToString();
dtrPreview["cQcAcChart"] = dtrPData["QcAcChart"].ToString();
dtrPreview["cQnAcChart"] = dtrPData["QnAcChart"].ToString();
dtrPreview["cQcAcChart2"] = dtrPData["QcAcChart2"].ToString();
dtrPreview["cQnAcChart2"] = dtrPData["QnAcChart2"].ToString();
dtsPrintPreview.XRPACCHART.Rows.Add(dtrPreview);
}
if (dtsPrintPreview.XRPACCHART.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);
string strCriteria = "";
string strOrderBy = "";
string strBegValue = ""; string strEndValue = "";
strOrderBy = "Master_Sect." + 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_Sect.cCode in (" + this.pmGetRngCode() + ")";
}
if (this.pATagDept.Count > 0)
{
strCriteria += " and Master_Dept.cCode in (" + this.pmGetRngCode2() + ")";
}
Report.LocalDataSet.DTSACCHART dtsPrintPreview = new Report.LocalDataSet.DTSACCHART();
string strSQLStr = "select BGJOB.CCODE,BGJOB.CNAME,BGJOB.CNAME as QcDept,BGJOB.CNAME as QnDept from " + MapTable.Table.Job;
strSQLStr += " where ";
strSQLStr += strCriteria + " order by " + strOrderBy;
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QSect", "SECT", strSQLStr, ref strErrorMsg))
{
foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QSect"].Rows)
{
DataRow dtrPreview = dtsPrintPreview.XRPACCHART.NewRow();
dtrPreview["cCode"] = dtrPData["cCode"].ToString();
dtrPreview["cName"] = dtrPData["cName"].ToString();
dtrPreview["cName2"] = dtrPData["cName2"].ToString();
dtrPreview["cQcDept"] = dtrPData["QcDept"].ToString();
dtrPreview["cQnDept"] = dtrPData["QnDept"].ToString();
dtsPrintPreview.XRPACCHART.Rows.Add(dtrPreview);
}
if (dtsPrintPreview.XRPACCHART.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);
string strCriteria = "";
string strOrderBy = "";
string strBegValue = ""; string strEndValue = "";
strOrderBy = " Master_AcChart." + this.mstrOrderBy;
if (this.cmbWRng.SelectedIndex == 0)
{
strCriteria = strOrderBy + " between ? and ?";
objSQLHelper.SetPara(new object[] { this.txtBegAcChart.Text.TrimEnd(), this.txtEndAcChart.Text.TrimEnd(), this.txtLevel.Value });
}
else
{
strCriteria = " Master_AcChart.cCode in (" + this.pmGetRngCode() + ")";
objSQLHelper.SetPara(new object[] { this.txtLevel.Value });
}
strCriteria += " and Master_AcChart.nLevel <= ?";
Report.LocalDataSet.DTSACCHART dtsPrintPreview = new Report.LocalDataSet.DTSACCHART();
string strSQLStr = "select * from " + MapTable.Table.MasterAcChart + " where ";
strSQLStr += strCriteria + " order by " + strOrderBy;
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QAcChart", "ACCHART", strSQLStr, ref strErrorMsg))
{
foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QAcChart"].Rows)
{
DataRow dtrPreview = dtsPrintPreview.XRPACCHART.NewRow();
dtrPreview["cCode"] = dtrPData["cCode"].ToString();
dtrPreview["cName"] = dtrPData["cName"].ToString();
dtrPreview["cName2"] = dtrPData["cName2"].ToString();
dtrPreview["cCateg"] = (dtrPData["cCateg"].ToString().TrimEnd() == "D" ? "ºÑªÕ" : "¡ÅØèÁ");
dtrPreview["nLevel"] = Convert.ToInt32(dtrPData["nLevel"]);
string strGroup = "";
switch (dtrPData["cGroup"].ToString())
{
case "1":
strGroup = "ÊÔ¹·ÃѾÂì";
break;
case "2":
strGroup = "˹ÕéÊÔ¹";
break;
case "3":
strGroup = "·Ø¹";
break;
case "4":
strGroup = "ÃÒÂä´é";
break;
case "5":
strGroup = "¤èÒãªé¨èÒÂ";
break;
case "6":
strGroup = "¤èÒãªé¨èÒ¡ÒüÅÔµ";
break;
}
dtrPreview["cGroup"] = strGroup;
dtsPrintPreview.XRPACCHART.Rows.Add(dtrPreview);
}
if (dtsPrintPreview.XRPACCHART.Rows.Count > 0)
{
this.pmPreviewReport(dtsPrintPreview);
}
}
}
