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