private bool CheckInvDeclareType(string strYM)
{
//判斷此筆資料是否已媒體申報
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strYM);
return BCO.CheckInvDeclareType(ParameterList);
}
private bool CheckInvExist(string strINV_NO)
{
//判斷此筆資料是否作廢
bool bResult = false;
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strINV_NO);
DataTable dt = BCO.CheckInvExist(ParameterList);
if (dt.Rows.Count == 0) //沒有資料=沒有作廢
bResult = false;
else
bResult = true;
return bResult;
}
private bool CheckInvData(string strINV_NO)
{
//檢查發票資料是否被折讓折抵
bool bResult = false;
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strINV_NO);
DataTable dt = BCO.CheckInvData(ParameterList);
if (dt.Rows.Count == 0)
bResult = false;
else
bResult = true;
return bResult;
}
private int CHGInvByChange(GridViewRow grdRow)
{
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
//@發票號碼、@型式、@結帳統編、@品名、@銷售金額、@稅額、@抬頭、@更新日期、@更新人、@原始更新日期、@原始更新人
HiddenField hdfINV_NO = (HiddenField)grdRow.FindControl("hdfINV_NO");
HiddenField hdfUPDATEDATE = (HiddenField)grdRow.FindControl("hdfUPDATEDATE");
HiddenField hdfUPDATEUID = (HiddenField)grdRow.FindControl("hdfUPDATEUID");
TextBox txtVOUCH_RFNO = (TextBox)grdRow.FindControl("txtVOUCH_RFNO");
TextBox txtTITLE = (TextBox)grdRow.FindControl("txtTITLE");
TextBox txtITEM_NAME = (TextBox)grdRow.FindControl("txtITEM_NAME");
TextBox txtINV_UAMT = (TextBox)grdRow.FindControl("txtINV_UAMT");
TextBox txtINV_TAX = (TextBox)grdRow.FindControl("txtINV_TAX");
TextBox txtINV_AMT = (TextBox)grdRow.FindControl("txtINV_AMT");
DropDownList slp_INV_FORM = (DropDownList)((ASP.sys_slp_slp_codefile_ascx)grdRow.FindControl("slp_INV_FORM")).FindControl("D1");
ParameterList.Clear();
ParameterList.Add(hdfINV_NO.Value);
ParameterList.Add(hdfType.Value);
ParameterList.Add(txtVOUCH_RFNO.Text);
ParameterList.Add(slp_INV_FORM.SelectedValue);
ParameterList.Add(txtTITLE.Text);
ParameterList.Add(txtITEM_NAME.Text);
ParameterList.Add(txtINV_UAMT.Text);
ParameterList.Add(txtINV_TAX.Text);
ParameterList.Add(txtINV_AMT.Text);
ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(hdfUPDATEDATE.Value);
ParameterList.Add(hdfUPDATEUID.Value);
return BCO.CHGInvByChange(ParameterList, null);
}
private int CancelInvByChange(GridViewRow grdRow)
{
HiddenField hdfINV_NO = (HiddenField)grdRow.FindControl("hdfINV_NO");
HiddenField hdfUPDATEDATE = (HiddenField)grdRow.FindControl("hdfUPDATEDATE");
HiddenField hdfUPDATEUID = (HiddenField)grdRow.FindControl("hdfUPDATEUID");
ASP.wui_slp_slp_slpdate_ascx slp_CANCEL_DATE = (ASP.wui_slp_slp_slpdate_ascx)grdRow.FindControl("slp_CANCEL_DATE");
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ParameterList.Clear();
ParameterList.Add(hdfINV_NO.Value);
ParameterList.Add(slp_CANCEL_DATE.Text);
ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(hdfUPDATEDATE.Value);
ParameterList.Add(hdfUPDATEUID.Value);
return BCO.CancelInvByChange(ParameterList, null);
}
protected void btnCommit_Click(object sender, EventArgs e)
{
GV_WriteToCache();
ErrorMsgLabel.Text = "";
if (CheckSumAmt() == false)
{
ErrorMsgLabel.Text = "異動失敗，換開發票之銷售金額總合需與原發票金額相同";
}
else if (CheckChanMonthClose(SLP_SLPDate1.Text.Replace("/", "").Substring(0, 6)) == true)
{
ErrorMsgLabel.Text = "字軌已月結，無法金額換開";
}
else if (CheckZero() == false)
{
ErrorMsgLabel.Text = "銷售金額欄位不得小於1";
}
else
{
string SessionName_DT = "CAA22DT_" + PageTimeStamp.Value;
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ParameterList.Clear();
ParameterList.Add(txtINV_NO.Text.Trim());
ParameterList.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(hdfUPDATEDATE_Q.Value);
ParameterList.Add(hdfUPDATEUID_Q.Value);
ParameterList.Add((DataTable)Session[SessionName_DT]);
ParameterList.Add(SLP_SLPDate1.Text);
ParameterList.Add(SLP_INVOICE_TYPE.Text);
BCO.CHGInvOneToMore(ParameterList);
ErrorMsgLabel.Text = "換開成功";
ViewState["SaveOK"] = "OK";
Disable_Commit();
Load_MoreData(txtINV_NO.Text.Trim());
UpdatePanelGV1.Update();
}
up_ErrorMsg.Update();
}
private void Load_MoreData(string strINV_NO)
{
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strINV_NO);
DataTable dt = BCO.QueryInvoiceByMore(ParameterList);
string SessionName_DT = "CAA22DT_" + PageTimeStamp.Value;
Session[SessionName_DT] = dt;
GridView1.PageSize = 1000;
GridView1.PageIndex = 0;
Bind_Data();
EmptyGridFix(GridView1);
}
private void Query_Data()
{
//0.@結帳年月
//1.@店號
//2.@結帳統編
//3.@統一編號
//4.@原開立日期
//5.@原發票金額_OP 0:> 1:= 2:<
//6.@原發票金額
//7.@商品群分類
//8.@稅別
//9.@發票性質
//10.@發票號碼
CAAModel.ProcessInvoiceChange BCO = new CAAModel.ProcessInvoiceChange(ConntionDB);
ArrayList ParameterList = new ArrayList(); //因為原來的ParameterList是全域變數放到Viewstate後會跟著變動,所以自己在宣告一個
ParameterList.Clear();
if (ViewState["Para_Query"] == null)
{
ParameterList.Add(SLP_YearMonth1.Text);
ParameterList.Add(SLP_Store1.Text);
ParameterList.Add(txtPAY_RFNO.Text);
ParameterList.Add(txtVOUCH_RFNO.Text);
ParameterList.Add(SLP_SLPDate1.Text);
ParameterList.Add(SLP_SLPNumber1.Operator);
ParameterList.Add(SLP_SLPNumber1.Text);
ParameterList.Add(SLP_RootNo1.Text);
ParameterList.Add(rblTaxType.SelectedValue);
ParameterList.Add(SLP_INVOICE_TYPE.Text);
ParameterList.Add(txtINV_NO.Text.Trim());
Int32 iTopRownum;
Int32.TryParse(TextBoxRowCountLimit.Text.Trim(), out iTopRownum);
ParameterList.Add(iTopRownum.ToString());
ViewState["Para_Query"] = ParameterList;
}
else
{
ParameterList = (ArrayList)ViewState["Para_Query"];
}
DataTable dt = BCO.QueryInvoiceByChange(ParameterList);
string SessionName_DT = "CAA22DT_" + PageTimeStamp.Value;
Session[SessionName_DT] = dt;
if (dt.Rows.Count > 0)
{
hdfType.Value = SLP_EnumBase1.Text;
switch (SLP_EnumBase1.Text.Trim())
{
case "1": //"一對多換開"
Bind_OneToMore(dt);
break;
case "2": //"金額換開":
case "3": //"統編換開":
case "4": //"品名換開":
case "5": //"發票作廢":
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 20 : (int.Parse(TextBoxPagesize.Text) < 0) ? 20 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
Bind_Data();
break;
}
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
ErrorMsgLabel.Text = "查無資料";
}
up_ErrorMsg.Update();
UpdatePanelCommit.Update();
}
