protected void btnExec_Click(object sender, EventArgs e)
{
string[] bResult;
try
{
if (IsValid)
{
#region 呼叫BCO
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(slp_SETTLE_YM.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_INVOICE_MONTH.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_INVOICE_DATE.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_GROUP_NO_S.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_GROUP_NO_E.Text, "string", false));
ParameterList.Add(GetValueSetParameter(txtPAY_RFNO.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_STORE.Text, "string", false));
ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false));
BCO.ProcessGetForm bco = new BCO.ProcessGetForm(ConntionDB);
bResult = bco.GetFormRecord(ParameterList);
if (bResult[0] == "0")//成功
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.GetType(), "ClientScript", string.Format("alert('執行作業完成，請跑檢核報表確認是否成功!');"), true);//20110218 RIKA修改完成訊息
}
else//失敗
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.GetType(), "ClientScript", string.Format("alert('發票折讓開立失敗：" + bResult[1] + "');"), true);
}
}
else
{
UpdatePanel1.Update();
throw new Exception("驗證失敗!");
}
#endregion
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
ErrorMsgLabel.Text = ex.Message;
}
finally { Finally_Function(); }
}
protected void but_Print_Click(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(slp_SETTLE_YM.Text, "string", false));
// ParameterList.Add(GetValueSetParameter(slp_INVOICE_MONTH.Text, "string", false));
// ParameterList.Add(GetValueSetParameter(slp_INVOICE_DATE.Text, "date", false));
ParameterList.Add(GetValueSetParameter(slp_GROUP_NO_S.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_GROUP_NO_E.Text, "string", false));
ParameterList.Add(GetValueSetParameter(txtPAY_RFNO.Text, "string", false));
ParameterList.Add(GetValueSetParameter(slp_STORE.Text, "string", false));
DataTable dt = new DataTable();
BCO.ProcessGetForm bco = new BCO.ProcessGetForm(ConntionDB);
dt = bco.GetDiffRecord(ParameterList);
if (dt.Rows.Count == 0)
{
this.ErrorMsgLabel.Text = "查無資料";
return;
}
else
{
dt.TableName = "CRCAA27R01";
ds.Tables.Add(dt.Copy());
DataTable dt1 = new DataTable();
BCO.ProcessGetForm bco1 = new BCO.ProcessGetForm(ConntionDB);
dt1 = bco1.GetDiffRecord1(ParameterList);
DataTable dt2 = new DataTable();
dt2 = dt1.Copy();
dt2.Clear();
dt2.TableName = "CRCAA27R01_1";
if (dt1.Rows.Count > 0)
{
string strGROUP = "";
string strSTORE = "";
string strSTORE_NAME = "";
string strRFNO = "";
string strMEMO = "";
string strMEMO_TMP = "";
decimal dSUM_AMT = 0;
strGROUP = dt1.Rows[0]["GROUP_NO"].ToString();
strSTORE = dt1.Rows[0]["STORE_ID"].ToString();
strSTORE_NAME = dt1.Rows[0]["STORENAME"].ToString();
strRFNO = dt1.Rows[0]["RFNO"].ToString();
foreach (DataRow dr in dt1.Rows)
{
if (strGROUP == dr["GROUP_NO"].ToString() && strSTORE == dr["STORE_ID"].ToString() && strRFNO == dr["RFNO"].ToString())
{
dSUM_AMT = dSUM_AMT + Convert.ToDecimal(dr["SUM_AMT"]);
if (strMEMO_TMP != dr["MEMO"].ToString())
{
if (strMEMO == "")
{
strMEMO = dr["MEMO"].ToString();
}
else
{
strMEMO += "；" + dr["MEMO"].ToString();
}
}
strMEMO_TMP = dr["MEMO"].ToString();
}
else
{
DataRow dr1 = dt2.NewRow();
dr1["CHK_TYPE"] = "全部";
dr1["GROUP_NO"] = strGROUP;
dr1["STORE_ID"] = strSTORE;
dr1["STORENAME"] = strSTORE_NAME;
dr1["RFNO"] = strRFNO;
dr1["SUM_AMT"] = dSUM_AMT;
dr1["MEMO"] = strMEMO;
dt2.Rows.Add(dr1);
strGROUP = dr["GROUP_NO"].ToString();
strSTORE = dr["STORE_ID"].ToString();
strSTORE_NAME = dr["STORENAME"].ToString();
strRFNO = dr["RFNO"].ToString();
strMEMO = dr["MEMO"].ToString();
strMEMO_TMP = dr["MEMO"].ToString();
dSUM_AMT = Convert.ToDecimal(dr["SUM_AMT"]);
}
}
DataRow dr2 = dt2.NewRow();
dr2["CHK_TYPE"] = "全部";
dr2["GROUP_NO"] = strGROUP;
dr2["STORE_ID"] = strSTORE;
dr2["STORENAME"] = strSTORE_NAME;
dr2["RFNO"] = strRFNO;
dr2["SUM_AMT"] = dSUM_AMT;
dr2["MEMO"] = strMEMO;
dt2.Rows.Add(dr2);
}
ds.Tables.Add(dt2.Copy());
ShowReport(ds);
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
finally { Finally_Function(); }
}
// 元件顯示及使用屬性初始設定
private void Initialization_Component()
{
rdoQUERY_DATE1.Checked = true;
rdoQUERY_DATE2.Checked = false;
rdoQUERY_STORE1.Checked = true;
rdoQUERY_STORE2.Checked = false;
rdoQUERY_STORE3.Checked = false;
slp_SETTLE_YM.IsRequired = true;
slp_INVOICE_MONTH.IsRequired = true;//20100208 Rika 新增發票年月
slp_INVOICE_MONTH.ReadOnly = false;//20100208 Rika 新增發票年月
slp_INVOICE_DATE.IsRequired = false;
slp_INVOICE_DATE.ReadOnly = true;
slp_GROUP_NO_S.IsRequired = true;
slp_GROUP_NO_E.IsRequired = true;
slp_STORE.IsRequired = false;
rfv_PAY_RFNO.Enabled = false;
slp_STORE.ReadOnly = true;
txtPAY_RFNO.ReadOnly = true;
txtPAY_RFNO.CssClass = "readtxtbox";
BCO.ProcessGetForm bco = new BCO.ProcessGetForm(ConntionDB);
slp_SETTLE_YM.Text = bco.GetPSSCloseYN();
}
