/// <summary>
/// PIU08_1報表(列印鈕)
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable PUR09_1(ArrayList ParameterList)
{
#region
PURModel.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB);
DataTable Dt = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByPrint,ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
return Dt;
}
#endregion
}
// 品項載入(續)
private void Item_Load2()
{
string vPICK_SELECT_1 = "0";
string vPICK_SELECT_2 = "0";
if (this.chkPICK_SELECT_1.Checked == true) //正常品
{
vPICK_SELECT_1 = "1";
ViewState["DelDataType"] = "1";
}
if (this.chkPICK_SELECT_2.Checked == true) //客服查補
{
vPICK_SELECT_2 = "1";
ViewState["DelDataType"] = "2";
}
if ((vPICK_SELECT_1 == "1") && (vPICK_SELECT_2 == "1"))
ViewState["DelDataType"] = "3";
Session["PUR091_Pick" + PageTimeStamp.Value] = null;
//第一次查詢，PKG_VDS_PUR_PUR09.LoadDeliveryGoods
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtPLAN_ACCEPT_DATE.Text, "string", false));
ParameterList.Add(GetValueSetParameter(vPICK_SELECT_1, "int", false));
ParameterList.Add(GetValueSetParameter(vPICK_SELECT_2, "int", false));
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(DateTime.Now.ToString(), "datetime", false));
PURModel.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB);
DataTable Dt = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByLOAD, ParameterList);
string msg = "";
for (int i = 0; i < Dt.Rows.Count; i++)
{
string strCheckMsg = ChkDupData(Dt.Rows[i]["ST_ACCEPT_DATE"].ToString(), Dt.Rows[i]["VIRTUAL_CODE"].ToString(), Dt.Rows[i]["PERIOD"].ToString(), txtPICK_BATCH.Text.Trim(), ViewState["DelDataType"].ToString());
if (strCheckMsg != "")
{
msg += strCheckMsg;
Dt.Rows[i].Delete();
}
}
Dt.AcceptChanges();
Session["PUR091_MST" + PageTimeStamp.Value] = Dt;
if (msg != "") ErrorMsgLabel.Text = msg;
if (Dt == null || Dt.Rows.Count == 0)
{
LabelQueryRecordCount.Text = "";
this.hid_PICK_CNT.Value = "0";
this.hid_RESTRAIN_CNT.Value = "0";
if (msg == "")
ErrorMsgLabel.Text = "查無資料";
this.hid_PageStatus.Text = "EMPTY";
GridView1.DataSource = null;
GridView1.DataBind();
SetToolBar(true, false, false, false, false);
}
else
{
LabelQueryRecordCount.Text = "品項數：理貨品：" + Dt.Rows.Count + "筆 管制品：0筆";
this.hid_PICK_CNT.Value = Dt.Rows.Count.ToString();
this.hid_RESTRAIN_CNT.Value = "0";
this.hid_PageStatus.Text = "EDIT";
GridView1.DataSource = Dt;
GridView1.DataBind();
foreach (DataRow dr in Dt.Rows)
{
AddNewChannel(dr["VIRTUAL_CODE"].ToString(), dr["PERIOD"].ToString(), txtPLAN_ACCEPT_DATE.Text, txtPICK_BATCH.Text, "0", "");
}
SetToolBar(true, false, true, false, false);
}
SetPageStatus();
}
// 列印
protected void btnPrint_Click(object sender, EventArgs e)
{
ErrorMsgLabel.Text = "";
try
{
PURModel.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB);
string vPICK_SELECT_1 = "0";
string vPICK_SELECT_2 = "0";
//固定傳 1
vPICK_SELECT_1 = "1";
vPICK_SELECT_2 = "1";
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtPLAN_ACCEPT_DATE.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtPICK_BATCH.Text, "string", false));
ParameterList.Add(GetValueSetParameter(vPICK_SELECT_1, "int", false));
ParameterList.Add(GetValueSetParameter(vPICK_SELECT_2, "int", false));
DataTable Dt_Print = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByPrint, ParameterList);
if (Dt_Print.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "PUR091.aspx", "alert(' 查無資料 ');", true);
return;
}
ShowReport(Dt_Print);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
//指定日期匯入(續)
private void LoadFromDate1(string importDate)
{
string vPICK_SELECT_1 = "0";
string vPICK_SELECT_2 = "0";
if (this.chkPICK_SELECT_1.Checked == true) //正常品
vPICK_SELECT_1 = "1";
if (this.chkPICK_SELECT_2.Checked == true) //客服查補
vPICK_SELECT_2 = "1";
DataTable dtMST = new DataTable();
//第一次查詢，為了餵給BCO.InsertMaster Dt資料
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(importDate, "string", false));
ParameterList.Add(GetValueSetParameter("1", "int", false)); //只取得正常品的資料
ParameterList.Add(GetValueSetParameter("0", "int", false));
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(DateTime.Now.ToString(), "datetime", false));
PURModel.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB);
DataTable dtQuery = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByLOAD, ParameterList);//PKG_VDS_PUR_PUR09.LoadDeliveryGoods
if (Session["PUR091_MST" + PageTimeStamp.Value] != null && Session["PUR091_MST" + PageTimeStamp.Value] != "")
dtMST = (DataTable)Session["PUR091_MST" + PageTimeStamp.Value];
string msg = "";
bool bDel = false;
//已存在的資料就不再寫入了
for (int i = 0; i < dtQuery.Rows.Count; i++)
{
bDel = false;
dtQuery.Rows[i]["ST_ACCEPT_DATE"] = txtPLAN_ACCEPT_DATE.Text;
if (dtMST.Rows.Count > 0)
{
DataRow[] FindExists = dtMST.Select("VIRTUAL_CODE = '" + dtQuery.Rows[i]["VIRTUAL_CODE"].ToString() + "' and PERIOD = '" + dtQuery.Rows[i]["PERIOD"].ToString() + "'");
if (FindExists.Length > 0)
{
msg += "品號: " + dtQuery.Rows[i]["VIRTUAL_CODE"].ToString() + " 期別:" + dtQuery.Rows[i]["PERIOD"].ToString() + " 已存在門市進貨日:" + txtPLAN_ACCEPT_DATE.Text + " 同批次中 <br \\>";
dtQuery.Rows[i].Delete();
bDel = true;
}
}
if (bDel == false)
{
string strCheckMsg = ChkDupData(txtPLAN_ACCEPT_DATE.Text, dtQuery.Rows[i]["VIRTUAL_CODE"].ToString(), dtQuery.Rows[i]["PERIOD"].ToString(), txtPICK_BATCH.Text.Trim(), ViewState["DelDataType"].ToString());
if (strCheckMsg != "")
{
msg += strCheckMsg;
dtQuery.Rows[i].Delete();
}
}
}
dtQuery.AcceptChanges();
if (msg != "") ErrorMsgLabel.Text = msg;
if (dtQuery.Rows.Count > 0)
{
if (hid_PageStatus.Text == "EMPTY")
hid_PageStatus.Text = "EDIT";
LoadFromDate2(dtQuery);
}
else
{
if (msg == "") ErrorMsgLabel.Text = "無資料可載入 !!";
}
}
