private void pmPrintData()
{
string strSQLStr = "select cProd, sum(Sale_Qty) as SumQty from STOCK02 where cCorp = ? and QcProd between ? and ? and dDate between ? and ? group by cProd ";
Report.LocalDataSet.DTSPSTMOVE dtsPrintPreview = new Report.LocalDataSet.DTSPSTMOVE();
string strErrorMsg = "";
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);
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
App.MoreProcess = true;
App.AppMessage = "Start Extract Data...";
DateTime dttBegDate = DateTime.Now;
DateTime dttEndDate = DateTime.Now;
dttBegDate = this.txtBegDate.DateTime; // new DateTime(this.txtBegDate.DateTime.Year, 1, 1);
dttEndDate = this.txtEndDate.DateTime; // new DateTime(this.txtEndDate.DateTime.Year, 12, 13);
objSQLHelper.SetPara(new object[] { App.gcCorp, this.txtBegQcProd.Text.TrimEnd(), this.txtEndQcProd.Text.TrimEnd(), dttBegDate.Date, dttEndDate.Date });
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QGLRef", "GLRef", strSQLStr, ref strErrorMsg))
{
DataRow dtrPreview = null;
foreach (DataRow dtrGLRef in this.dtsDataEnv.Tables["QGLRef"].Rows)
{
if (App.MoreProcess == false)
{
break;
}
objSQLHelper2.SetPara(new object[] { dtrGLRef["cProd"].ToString() });
if (objSQLHelper2.SQLExec(ref this.dtsDataEnv, "QProd", "PROD", "select * from PROD where FCSKID = ?", ref strErrorMsg))
{
DataRow dtrProd = this.dtsDataEnv.Tables["QProd"].Rows[0];
dtrPreview = dtsPrintPreview.XRPSTMOVE.NewRow();
decimal decBfQty = 0;
this.pmGetStockAtDate(dtrGLRef["cProd"].ToString(), this.txtEndDate.DateTime.Date, ref decBfQty);
dtrPreview["cQcProd"] = dtrProd["fcCode"].ToString().TrimEnd();
dtrPreview["cQnProd"] = dtrProd["fcName"].ToString().TrimEnd();
dtrPreview["nQty"] = decBfQty;
dtrPreview["nStdPrice"] = this.pmToDecimal(dtrProd, "fnPrice");
dtrPreview["nSaleQty"] = this.pmToDecimal(dtrGLRef, "SumQty");
dtsPrintPreview.XRPSTMOVE.Rows.Add(dtrPreview);
}
}
this.pmPreviewReport(dtsPrintPreview);
}
}
private void pmPrintData2()
{
string strFld = " REFPROD.FCPROD , REFPROD.FCREFTYPE,FCIOTYPE, sum(REFPROD.FNQTY*REFPROD.FNUMQTY) as FNSUMQTY , sum(REFPROD.FNCOSTAMT) as FNSUMCOST";
string strSQLStr = "select " + strFld + " from REFPROD ";
strSQLStr = strSQLStr + " left join WHOUSE on WHOUSE.FCSKID = REFPROD.FCWHOUSE ";
strSQLStr = strSQLStr + " left join PROD on PROD.FCSKID = REFPROD.FCPROD ";
strSQLStr = strSQLStr + " left join PDGRP on PDGRP.FCSKID = PROD.FCPDGRP ";
strSQLStr = strSQLStr + " where REFPROD.FCCORP = ? and REFPROD.FCBRANCH = ? ";
strSQLStr = strSQLStr + " and REFPROD.FDDATE between ? and ? ";
strSQLStr = strSQLStr + " and REFPROD.FCSTAT <> 'C' ";
strSQLStr = strSQLStr + " and WHOUSE.FCTYPE = ' ' ";
strSQLStr = strSQLStr + " and PDGRP.FCCORP = ? and PDGRP.FCTYPE = 'G' and PDGRP.FCCODE between ? and ? ";
strSQLStr = strSQLStr + " group by REFPROD.FCPROD , REFPROD.FCREFTYPE, REFPROD.FCIOTYPE";
Report.LocalDataSet.DTSPSTMOVE dtsPrintPreview = new Report.LocalDataSet.DTSPSTMOVE();
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
//stop = false;
//thread = new Thread(new ThreadStart(StartPrint));
//thread.Start();
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
App.MoreProcess = true;
App.AppMessage = "Start Extract Data...";
//this.pmCreateBFStock();
objSQLHelper.SetPara(new object[] { App.gcCorp, this.mstrBranch, this.txtBegDate.DateTime.Date, this.txtEndDate.DateTime.Date, App.gcCorp, this.txtBegQcPdGrp.Text.TrimEnd(), this.txtEndQcPdGrp.Text.TrimEnd() });
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QGLRef", "GLRef", strSQLStr, ref strErrorMsg))
{
string strPrefix = "";
string strRefType = "";
DataRow dtrPreview = null;
foreach (DataRow dtrGLRef in this.dtsDataEnv.Tables["QGLRef"].Rows)
{
if (App.MoreProcess == false)
{
break;
}
if (strPrefix != dtrGLRef["fcProd"].ToString())
{
strPrefix = dtrGLRef["fcProd"].ToString();
dtrPreview = dtsPrintPreview.XRPSTMOVE.NewRow();
string strQcProd = "";
string strQnProd = "";
string strQcSect = "";
objSQLHelper.SetPara(new object[] { dtrGLRef["fcProd"].ToString() });
string strSQLExec_Prod = "select Prod.fcCode, Prod.fcName, Prod.fcSName, UM.fcName as cQnUM, PdGrp.fcCode as cQcPdGrp, PdGrp.fcName as cQnPdGrp from Prod ";
strSQLExec_Prod += " left join UM on UM.fcSkid = Prod.fcUm ";
strSQLExec_Prod += " left join PDGRP on PDGRP.fcSkid = Prod.fcPdGrp ";
strSQLExec_Prod += " where Prod.fcSkid = ? ";
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QProd", "PROD", strSQLExec_Prod, ref strErrorMsg))
{
DataRow dtrProd = this.dtsDataEnv.Tables["QProd"].Rows[0];
strQcProd = dtrProd["fcCode"].ToString();
dtrPreview["cQnUm"] = dtrProd["cQnUm"].ToString().TrimEnd();
if (Convert.IsDBNull(dtrProd["cQcPdGrp"]))
{
dtrPreview["cQcPdGrp"] = "9999999";
dtrPreview["cQnPdGrp"] = "Not Specific";
}
else
{
dtrPreview["cQcPdGrp"] = dtrProd["cQcPdGrp"].ToString().TrimEnd();
dtrPreview["cQnPdGrp"] = dtrProd["cQnPdGrp"].ToString().TrimEnd();
}
}
//App.AppMessage = "¡ÓÅѧ¾ÔÁ¾ì¢éÍÁÙÅ ÊÔ¹¤éÒ : \r\n" + "(" + strQcProd.TrimEnd() + ")" + strQnProd.TrimEnd();
decimal decBFQty = 0; decimal decBFAmt = 0;
this.pmCreateBFStock2(dtrGLRef["fcProd"].ToString());
this.pmGetBFStock(strQcProd, strQcSect, ref decBFQty, ref decBFAmt);
dtrPreview["nBfQty"] = decBFQty;
dtrPreview["nBfAmt"] = decBFAmt;
dtrPreview["nQty_IN"] = 0;
dtrPreview["nQty_Out"] = 0;
dtrPreview["nQty_Ret"] = 0;
dtrPreview["nAmt_In"] = 0;
dtrPreview["nAmt_Out"] = 0;
dtrPreview["nAmt_Ret"] = 0;
bool bllIsPrn = true;
dtsPrintPreview.XRPSTMOVE.Rows.Add(dtrPreview);
}
strRefType = dtrGLRef["fcRefType"].ToString();
switch (strRefType)
{
case "BI":
case "BR":
dtrPreview["nQty_IN"] = Convert.ToDecimal(dtrPreview["nQty_IN"]) + Convert.ToDecimal(dtrGLRef["fnSumQty"]);
dtrPreview["nAmt_IN"] = Convert.ToDecimal(dtrPreview["nAmt_IN"]) + Convert.ToDecimal(dtrGLRef["fnSumCost"]);
break;
case "BC":
case "BM":
dtrPreview["nQty_Ret"] = Convert.ToDecimal(dtrPreview["nQty_Ret"]) + Convert.ToDecimal(dtrGLRef["fnSumQty"]);
dtrPreview["nAmt_Ret"] = Convert.ToDecimal(dtrPreview["nAmt_Ret"]) + Convert.ToDecimal(dtrGLRef["fnSumCost"]);
break;
case "RW":
case "RX":
dtrPreview["nQty_IN"] = Convert.ToDecimal(dtrPreview["nQty_IN"]) + Convert.ToDecimal(dtrGLRef["fnSumQty"]);
dtrPreview["nAmt_IN"] = Convert.ToDecimal(dtrPreview["nQty_IN"]) + Convert.ToDecimal(dtrGLRef["fnSumCost"]);
break;
case "WR":
case "WX":
case "SI":
case "SR":
dtrPreview["nQty_Out"] = Convert.ToDecimal(dtrPreview["nQty_Out"]) + Convert.ToDecimal(dtrGLRef["fnSumQty"]);
dtrPreview["nAmt_Out"] = Convert.ToDecimal(dtrPreview["nAmt_Out"]) + Convert.ToDecimal(dtrGLRef["fnSumCost"]);
break;
}
}
this.dataGridView1.DataSource = dtsPrintPreview.XRPSTMOVE;
this.pmPreviewReport(dtsPrintPreview);
}
}
private void pmPrintData()
{
string strSQLStr = "select * from STOCK01 where cCorp = ? and QcPdGrp between ? and ? and dDate between ? and ? order by QcPdGrp, dDate";
Report.LocalDataSet.DTSPSTMOVE dtsPrintPreview = new Report.LocalDataSet.DTSPSTMOVE();
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
App.MoreProcess = true;
App.AppMessage = "Start Extract Data...";
DateTime dttBegDate = DateTime.Now;
DateTime dttEndDate = DateTime.Now;
dttBegDate = this.txtBegDate.DateTime; // new DateTime(this.txtBegDate.DateTime.Year, 1, 1);
dttEndDate = this.txtEndDate.DateTime; // new DateTime(this.txtEndDate.DateTime.Year, 12, 13);
objSQLHelper.SetPara(new object[] { App.gcCorp, this.txtBegQcPdGrp.Text.TrimEnd(), this.txtEndQcPdGrp.Text.TrimEnd(), dttBegDate.Date, dttEndDate.Date });
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QGLRef", "GLRef", strSQLStr, ref strErrorMsg))
{
DataRow dtrPreview = null;
foreach (DataRow dtrGLRef in this.dtsDataEnv.Tables["QGLRef"].Rows)
{
if (App.MoreProcess == false)
{
break;
}
//¨Ó¹Ç¹
dtrPreview = dtsPrintPreview.XRPSTMOVE.NewRow();
decimal decBfQty = 0;
decimal decBfAmt = 0;
this.pmCreateBFStock01(dtrGLRef["cPdGrp"].ToString(), ref decBfQty, ref decBfAmt);
dtrPreview["cQcPdType"] = "1";
dtrPreview["cQcPdGrp"] = dtrGLRef["QcPdGrp"].ToString().TrimEnd();
dtrPreview["cQnPdGrp"] = dtrGLRef["QnPdGrp"].ToString().TrimEnd();
dtrPreview["nBfQty"] = decBfQty;
dtrPreview["nQty_IN"] = Convert.ToDecimal(dtrGLRef["Qty_IN"]);
dtrPreview["nQty_OUT"] = Convert.ToDecimal(dtrGLRef["Qty_OUT"]);
dtrPreview["nQty_RET"] = Convert.ToDecimal(dtrGLRef["Qty_RET"]);
dtsPrintPreview.XRPSTMOVE.Rows.Add(dtrPreview);
dtrPreview = dtsPrintPreview.XRPSTMOVE.NewRow();
//ÁÙŤèÒ
dtrPreview["cQcPdType"] = "2";
dtrPreview["cQcPdGrp"] = dtrGLRef["QcPdGrp"].ToString().TrimEnd();
dtrPreview["cQnPdGrp"] = dtrGLRef["QnPdGrp"].ToString().TrimEnd();
dtrPreview["nBfAmt"] = decBfAmt;
dtrPreview["nAmt_IN"] = Convert.ToDecimal(dtrGLRef["Amt_IN"]);
dtrPreview["nAmt_OUT"] = Convert.ToDecimal(dtrGLRef["Amt_OUT"]);
dtrPreview["nAmt_RET"] = Convert.ToDecimal(dtrGLRef["Amt_RET"]);
dtsPrintPreview.XRPSTMOVE.Rows.Add(dtrPreview);
}
this.pmPreviewReport(dtsPrintPreview);
}
}
