protected void btnSETTLE_CANCLE_Click(object sender, EventArgs e) { try { string[] bResult; string strCHECK = Check_PageCondition(true); if (strCHECK != "") { ErrorMsgLabel.Text = strCHECK; return; } else { #region 呼叫BCO CAMModel.CAMCommon bco1 = new CAMModel.CAMCommon(); ParameterList.Clear(); ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_YM.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_DATE.StartDate, "date", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_DATE.EndDate, "date", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtPAY_RFNO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtRFNO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_STORE.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_RootNo.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(rdoPAY_TYPE1.Checked ? "1" : (rdoPAY_TYPE2.Checked ? "2" : "3"), "string", false)); ParameterList.Add(bco1.GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slpPROMOTE_ID_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slpPROMOTE_ID_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtBUS_NO.Text, "string", false)); CAMModel.ProcessStoresMonthCounting bco = new CAMModel.ProcessStoresMonthCounting(ConntionDB); bResult = bco.CancelStoreCloseCounting(ParameterList); //20121121 曾怡婷確認取消帳差計算 //ParameterList.Clear(); //ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_YM.Text, "string", false)); //ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_DATE.StartDate, "date", false)); //ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_DATE.EndDate, "date", false)); //ParameterList.Add(bco1.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //bco.ProcessAcctDiff(ParameterList); if (bResult[2] == "0")//成功 { ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", string.Format("alert('解除結算成功:成功復原筆數" + bResult[0] + "筆,無法復原筆數" + bResult[1] + "筆 [執行時間:" + System.DateTime.Now.ToString("yyyy/MM/dd hh:mm") + "]');"), true); } else//失敗 { ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", string.Format("alert('解除結算失敗:" + bResult[3] + " [執行時間:" + System.DateTime.Now.ToString("yyyy/MM/dd hh:mm") + "]');"), true); } #endregion } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }
protected void btnUnSETTLE_Check_Click(object sender, EventArgs e) { try { string strCHECK = Check_PageCondition(false); if (strCHECK != "") { ErrorMsgLabel.Text = strCHECK; return; } else { #region 呼叫BCO CAMModel.ProcessStoresMonthCounting bco = new CAMModel.ProcessStoresMonthCounting(ConntionDB); ParameterList.Clear(); ParameterList.Add(bco.GetValueSetParameter(SLP_SETTLE_YM.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(SLP_SETTLE_DATE.StartDate, "date", false)); ParameterList.Add(bco.GetValueSetParameter(SLP_SETTLE_DATE.EndDate, "date", false)); ParameterList.Add(bco.GetValueSetParameter(slp_GROUP_NO_S.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(slp_GROUP_NO_E.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(txtPAY_RFNO.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(txtRFNO.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(slp_STORE.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(SLP_RootNo.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(rdoPAY_TYPE1.Checked ? "1" : (rdoPAY_TYPE2.Checked ? "2" : "3"), "string", false)); ParameterList.Add(bco.GetValueSetParameter(slpPROMOTE_ID_S.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(slpPROMOTE_ID_E.Text, "string", false)); ParameterList.Add(bco.GetValueSetParameter(txtBUS_NO.Text, "string", false)); DataTable dtResult = bco.GetUnSETTLE_Check(ParameterList); if (dtResult.Rows.Count == 0) { ScriptManager.RegisterStartupScript(UpdatePanel11, this.GetType(), "ClientScript", string.Format("alert('查無資料');"), true); } else { Export_Excel(dtResult); } #endregion } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }
protected void btnOVER_Click(object sender, EventArgs e) { try { string strCHECK = Check_PageCondition(false); if (strCHECK != "") { ErrorMsgLabel.Text = strCHECK; return; } else { #region 呼叫BCO CAMModel.CAMCommon bco1 = new CAMModel.CAMCommon(); ParameterList.Clear(); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtPAY_RFNO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtRFNO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_STORE.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_RootNo.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slpPROMOTE_ID_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slpPROMOTE_ID_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtBUS_NO.Text, "string", false)); DataTable dt = new DataTable(); CAMModel.ProcessStoresMonthCounting bco = new CAMModel.ProcessStoresMonthCounting(ConntionDB); dt = bco.GetCAM14R01Data(ParameterList); if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { ShowReport(dt, ((Button)sender).CommandName); } #endregion } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }
protected void btnTRAN_CNT_Click(object sender, EventArgs e) { try { double dblSETTLED = 0; double dblUNSETTLE = 0; double dblTOTALSETTLE = 0; string strCHECK = Check_PageCondition(true); if (strCHECK != "") { ErrorMsgLabel.Text = strCHECK; return; } else { #region 呼叫BCO CAMModel.CAMCommon bco1 = new CAMModel.CAMCommon(); ParameterList.Clear(); ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_YM.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_DATE.StartDate, "date", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_SETTLE_DATE.EndDate, "date", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtPAY_RFNO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtRFNO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_STORE.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_RootNo.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(rdoPAY_TYPE1.Checked ? "1" : (rdoPAY_TYPE2.Checked ? "2" : "3"), "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slpPROMOTE_ID_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slpPROMOTE_ID_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtBUS_NO.Text, "string", false)); DataTable dt = new DataTable(); CAMModel.ProcessStoresMonthCounting bco = new CAMModel.ProcessStoresMonthCounting(ConntionDB); dt = bco.CheckNotCountingTransactionQuality(ParameterList); for (int k = 0; k <= dt.Rows.Count - 1; k++) { if (dt.Rows[k]["AC_STATUS"].ToString() == "1" || dt.Rows[k]["AC_STATUS"].ToString() == "2")//1.未彙總結算,2.進行彙總結算中 { dblUNSETTLE += double.Parse(dt.Rows[k]["AC_STATUS_QTY"].ToString()); } else if ( dt.Rows[k]["AC_STATUS"].ToString() == "4" || dt.Rows[k]["AC_STATUS"].ToString() == "5" || dt.Rows[k]["AC_STATUS"].ToString() == "6" || dt.Rows[k]["AC_STATUS"].ToString() == "7" )//4.已彙總結算,5.人為註記已結算,6.已開立銷項發票,7.已開立銷項折讓 { dblSETTLED += double.Parse(dt.Rows[k]["AC_STATUS_QTY"].ToString()); } else { //其它非規範狀態都不計算 //CASE:進貨單未確定出入庫0 } dblTOTALSETTLE += double.Parse(dt.Rows[k]["AC_STATUS_QTY"].ToString()); } RightMsgLabel.Text = "總數" + dblTOTALSETTLE.ToString() + "筆,已結" + dblSETTLED.ToString() + "筆,未結" + dblUNSETTLE.ToString() + "筆 [執行時間:" + System.DateTime.Now.ToString("yyyy/MM/dd hh:mm") + "]"; #endregion } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }