protected void btnDiscExcel_Click(object sender, EventArgs e)
{
try
{
this.btnDiscExcel.Attributes.Add("onclick", "OffPanel('" + this.ErrorMsgLabel.ClientID + "');");
string type = "";
if (rdoType4.Checked)
{
#region 折讓單套印
type = "4";
string errMsg = "";
bool errored = false;
string objID = null;
if (SLP_SLPDateRange.StartDate.Length > 0 && SLP_SLPDateRange.EndDate.Length > 0)
if (DateTime.Parse(SLP_SLPDateRange.StartDate) > DateTime.Parse(SLP_SLPDateRange.EndDate))
{
errMsg += "發票/折讓日期起日不可大於迄日";
errored = true;
objID = ((ASP.wui_slp_slp_slpdate_ascx)((ASP.wui_slp_slp_slpdaterange_ascx)SLP_SLPDateRange).FindControl("SLP_SLPDate1")).FindControl("TextBoxCode").ClientID;
}
if (SLP_VendorBase1.Text.Trim().Length > 0 && SLP_VendorBase2.Text.Trim().Length > 0)
if (string.Compare(SLP_VendorBase1.Text.Trim(), SLP_VendorBase2.Text.Trim()) > 0)
{
if (!errored)
{
errMsg += "廠商統編起號不可大於迄號";
errored = true;
objID = ((TextBox)((ASP.vdm_slp_slp_vendorbase_ascx)SLP_VendorBase1).FindControl("TextBoxCode")).ClientID;
}
}
if (SLP_SLPDateRange1.StartDate.Length > 0 && SLP_SLPDateRange1.EndDate.Length > 0)
if (DateTime.Parse(SLP_SLPDateRange1.StartDate) > DateTime.Parse(SLP_SLPDateRange1.EndDate))
{
if (!errored)
{
errMsg += "入帳日期起日不可大於迄日";
errored = true;
objID = ((ASP.wui_slp_slp_slpdate_ascx)((ASP.wui_slp_slp_slpdaterange_ascx)SLP_SLPDateRange1).FindControl("SLP_SLPDate1")).FindControl("TextBoxCode").ClientID;
//objID = ((TextBox)((WUI.SLP.SLPDate)this.SLP_SLPDateRange1.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode")).ClientID;
}
}
if (SLP_VendorDisc1.Text.Trim().Length > 0 && SLP_VendorDisc2.Text.Trim().Length > 0)
if (string.Compare(SLP_VendorDisc1.Text.Trim(), SLP_VendorDisc2.Text.Trim()) > 0)
{
if (!errored)
{
errMsg += "折讓單號起號不可大於迄號";
errored = true;
objID = ((TextBox)((ASP.vam_slp_slp_vendordisc_ascx)SLP_VendorDisc1).FindControl("TextBoxCode")).ClientID;
}
}
if (errMsg.Length > 0)
{
ErrorMsgLabel.Text = errMsg;
string s_Return_String = string.Empty;
s_Return_String = @"
function CAACommon_set_Focus( )
{
try
{
document.getElementById('" + objID + @"').select();
document.getElementById('" + objID + @"').focus();
}
catch(err){setTimeout('CAACommon_set_Focus( )', 100);}
}
CAACommon_set_Focus( );
";
ScriptManager.RegisterStartupScript(this, this.GetType(), "VAM121.aspx", s_Return_String, true);
return;
}
ParameterList.Clear();
ParameterList.Add(SLP_SLPDateRange.StartDate);
ParameterList.Add(SLP_SLPDateRange.EndDate);
ParameterList.Add(SLP_VendorBase1.Text.Trim());
ParameterList.Add(SLP_VendorBase2.Text.Trim());
ParameterList.Add(SLP_EnumBase.Text); //課稅別
ParameterList.Add(SLP_SLPDateRange1.StartDate); //入帳日期(起)
ParameterList.Add(SLP_SLPDateRange1.EndDate); //入帳日期(迄)
ParameterList.Add(SLP_VendorDisc1.Text);
ParameterList.Add(SLP_VendorDisc2.Text);
ParameterList.Add(ddlTRANS_TAX.Text);
BCO.RecordingDiscountInvoiceFormat bco = new BCO.RecordingDiscountInvoiceFormat(ConntionDB);
DataTable dt = bco.ExportDiscountInvoiceFormat(ParameterList);
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "VAM121.aspx", "alert('查無資料');", true);
return;
}
GenDiscExcel(dt);
#endregion
}
else
{
ErrorMsgLabel.Text = "非折讓單套印選項";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
protected void btnTran_Click(object sender, EventArgs e)
{
try
{
this.btnTran.Attributes.Add("onclick", "OffPanel('" + this.ErrorMsgLabel.ClientID + "');");
string type = "";
if (rdoType4.Checked)
{
#region 折讓單套印
type = "4";
string errMsg = "";
bool errored = false;
string objID = null;
if (SLP_SLPDateRange.StartDate.Length > 0 && SLP_SLPDateRange.EndDate.Length > 0)
if (DateTime.Parse(SLP_SLPDateRange.StartDate) > DateTime.Parse(SLP_SLPDateRange.EndDate))
{
errMsg += "發票/折讓日期起日不可大於迄日";
errored = true;
objID = ((ASP.wui_slp_slp_slpdate_ascx)((ASP.wui_slp_slp_slpdaterange_ascx)SLP_SLPDateRange).FindControl("SLP_SLPDate1")).FindControl("TextBoxCode").ClientID;
}
if (SLP_VendorBase1.Text.Trim().Length > 0 && SLP_VendorBase2.Text.Trim().Length > 0)
if (string.Compare(SLP_VendorBase1.Text.Trim(), SLP_VendorBase2.Text.Trim()) > 0)
{
if (!errored)
{
errMsg += "廠商統編起號不可大於迄號";
errored = true;
objID = ((TextBox)((ASP.vdm_slp_slp_vendorbase_ascx)SLP_VendorBase1).FindControl("TextBoxCode")).ClientID;
}
}
if (SLP_SLPDateRange1.StartDate.Length > 0 && SLP_SLPDateRange1.EndDate.Length > 0)
if (DateTime.Parse(SLP_SLPDateRange1.StartDate) > DateTime.Parse(SLP_SLPDateRange1.EndDate))
{
if (!errored)
{
errMsg += "入帳日期起日不可大於迄日";
errored = true;
objID = ((ASP.wui_slp_slp_slpdate_ascx)((ASP.wui_slp_slp_slpdaterange_ascx)SLP_SLPDateRange1).FindControl("SLP_SLPDate1")).FindControl("TextBoxCode").ClientID;
}
}
if (SLP_VendorDisc1.Text.Trim().Length > 0 && SLP_VendorDisc2.Text.Trim().Length > 0)
if (string.Compare(SLP_VendorDisc1.Text.Trim(), SLP_VendorDisc2.Text.Trim()) > 0)
{
if (!errored)
{
errMsg += "折讓單號起號不可大於迄號";
errored = true;
objID = ((TextBox)((ASP.vam_slp_slp_vendordisc_ascx)SLP_VendorDisc1).FindControl("TextBoxCode")).ClientID;
}
}
if (errMsg.Length > 0)
{
ErrorMsgLabel.Text = errMsg;
string s_Return_String = string.Empty;
s_Return_String = @"
function CAACommon_set_Focus( )
{
try
{
document.getElementById('" + objID + @"').select();
document.getElementById('" + objID + @"').focus();
}
catch(err){setTimeout('CAACommon_set_Focus( )', 100);}
}
CAACommon_set_Focus( );
";
ScriptManager.RegisterStartupScript(this, this.GetType(), "VAM121.aspx", s_Return_String, true);
return;
}
ParameterList.Clear();
ParameterList.Add(SLP_SLPDateRange.StartDate);
ParameterList.Add(SLP_SLPDateRange.EndDate);
ParameterList.Add(SLP_VendorBase1.Text.Trim());
ParameterList.Add(SLP_VendorBase2.Text.Trim());
ParameterList.Add(SLP_EnumBase.Text); //課稅別
ParameterList.Add(SLP_SLPDateRange1.StartDate); //入帳日期(起)
ParameterList.Add(SLP_SLPDateRange1.EndDate); //入帳日期(迄)
ParameterList.Add(SLP_VendorDisc1.Text);
ParameterList.Add(SLP_VendorDisc2.Text);
ParameterList.Add(ddlTRANS_TAX.Text);
BCO.RecordingDiscountInvoiceFormat bco = new BCO.RecordingDiscountInvoiceFormat(ConntionDB);
DataTable dt = bco.QueryDiscountInvoiceFormat(ParameterList);
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "VAM121.aspx", "alert('查無資料');", true);
return;
}
ShowReport(dt, type);
#endregion
}
else
{
#region 檢查條件
this.ErrorMsgLabel.Text = "";
string s_CheckPage = CheckPage();
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
return;
}
#endregion
#region 傳入參數
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.SLP_SLPDateRange.StartDate.ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_SLPDateRange.EndDate.ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_VendorBase1.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_VendorBase2.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_EnumBase.Text.Trim(), "int", false));
ParameterList.Add(GetValueSetParameter(this.SLP_SLPDateRange1.StartDate.ToString(), "string", false));
ParameterList.Add(GetValueSetParameter(this.SLP_SLPDateRange1.EndDate.ToString(), "string", false));
#endregion
DataTable dtA = new DataTable();
DataTable dtB = new DataTable();
if (this.rdoType1.Checked == true)
{
BCO.RecordingPurchaseInvoice bco = new BCO.RecordingPurchaseInvoice(ConntionDB);
dtA = bco.QueryPurchaseInvoice(ParameterList);
if (dtA.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "VAM121.aspx", "alert('查無資料');", true);
return;
}
string sINV_NO = "";
for (int i = 0; i < dtA.Rows.Count; i++)
{
if (dtA.Rows[i]["INV_NO"].ToString() == sINV_NO)
{
DataRow drA = dtA.Rows[i];
drA.BeginEdit();
drA["INV_UAMT"] = System.DBNull.Value;
drA["INV_TAX"] = System.DBNull.Value;
drA.EndEdit();
}
sINV_NO = dtA.Rows[i]["INV_NO"].ToString();
}
ShowReportA(dtA, dtB, "XLS", "VAM121R");
}
else if (this.rdoType2.Checked == true)
{
BCO.RecordingDiscountInvoice bco = new BCO.RecordingDiscountInvoice(ConntionDB);
dtB = bco.QueryDiscountInvoice(ParameterList);
if (dtB.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "VAM121.aspx", "alert('查無資料');", true);
return;
}
string sDISC_NO = "";
for (int i = 0; i < dtB.Rows.Count; i++)
{
if (dtB.Rows[i]["DISC_NO"].ToString() == sDISC_NO)
{
DataRow drB = dtB.Rows[i];
drB.BeginEdit();
drB["DISC_UAMT"] = System.DBNull.Value;
drB["DISC_TAX"] = System.DBNull.Value;
drB.EndEdit();
}
sDISC_NO = dtB.Rows[i]["DISC_NO"].ToString();
}
ShowReportA(dtA, dtB, "XLS", "VAM122R");
}
else if (this.rdoType3.Checked == true)
{
BCO.RecordingPurchaseInvoice bco = new BCO.RecordingPurchaseInvoice(ConntionDB);
dtA = bco.QueryPurchaseInvoice(ParameterList);
string sINV_NO = "";
for (int i = 0; i < dtA.Rows.Count; i++)
{
if (dtA.Rows[i]["INV_NO"].ToString() == sINV_NO)
{
DataRow drA = dtA.Rows[i];
drA.BeginEdit();
drA["INV_UAMT"] = System.DBNull.Value;
drA["INV_TAX"] = System.DBNull.Value;
drA.EndEdit();
}
sINV_NO = dtA.Rows[i]["INV_NO"].ToString();
}
BCO.RecordingDiscountInvoice bco1 = new BCO.RecordingDiscountInvoice(ConntionDB);
dtB = bco1.QueryDiscountInvoice(ParameterList);
string sDISC_NO = "";
for (int i = 0; i < dtB.Rows.Count; i++)
{
if (dtB.Rows[i]["DISC_NO"].ToString() == sDISC_NO)
{
DataRow drB = dtB.Rows[i];
drB.BeginEdit();
drB["DISC_UAMT"] = System.DBNull.Value;
drB["DISC_TAX"] = System.DBNull.Value;
drB.EndEdit();
}
sDISC_NO = dtB.Rows[i]["DISC_NO"].ToString();
}
if (dtA.Rows.Count == 0 && dtB.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "VAM121.aspx", "alert('查無資料');", true);
return;
}
ShowReportA(dtA, dtB, "XLS", "VAM123R");
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally { }
}
