//匯出
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
this.ErrorMsgLabel.Text = "";
string s_CheckPage = CheckPage(sender);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
return;
}
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter((this.ddlPAY_TYPE.Text == "" ? "0" : ddlPAY_TYPE.Text), "int", this.CheckBoxLikeSearch.Checked));
//ParameterList.Add(0); //PAY_TYPE欄位，先放0，待SLP有值後再用上面的Code
ParameterList.Add(GetValueSetParameter(this.txtCOL_DAYS.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtCNT_NO.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.EndDate, "date", false));
//是否停止往來
if (this.rdoSTOP_DATE1.Checked == true)
ParameterList.Add(GetValueSetParameter("1", "string", false));
else if (this.rdoSTOP_DATE2.Checked == true)
ParameterList.Add(GetValueSetParameter("2", "string", false));
else
ParameterList.Add(GetValueSetParameter("3", "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B2.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E2.Text, "string", false));
//是否最新合約
if (this.rdoIS_NEW1.Checked == true)
ParameterList.Add(GetValueSetParameter("Y", "string", false));
else
ParameterList.Add(GetValueSetParameter("N", "string", false));
//審核
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_CODE.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.EndDate, "date", false));
//建立人員
ParameterList.Add(GetValueSetParameter(this.txtCREATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
//維護日期
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.EndDate, "date", false));
//維護人員
ParameterList.Add(GetValueSetParameter(this.txtUPDATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(TextBoxRowCountLimit.Text.Trim().Length == 0 ? "10" : TextBoxRowCountLimit.Text);
//廠商名稱
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_NAME.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
DataTable dt_Return = new DataTable();
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
dt_Return = bco.QueryAgmByALL(ParameterList);
if (dt_Return.Rows.Count <= 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM021", string.Format("alert('查無資料');", Session["UID"].ToString().Trim()), true);
return;
}
Response.Clear();
string sFileName = HttpUtility.UrlEncode("VDM02供應商合約_" + DateTime.Now.ToString("yyyyMMdd_hhmmss") + ".xls", System.Text.Encoding.UTF8);
Response.AddHeader("content-disposition", "attachment;filename=" + sFileName);
Response.ContentType = "application/vnd.ms-excel;charset='utf-8'";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
GridView1.DataSource = dt_Return;
GridView1.DataBind();
GridView1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); }
finally { }
}
}//page_load
protected void ButtonQuery_Click(object sender, EventArgs e)
{
try
{
this.ErrorMsgLabel.Text = "";
string s_CheckPage = CheckPage(sender);
if (s_CheckPage != string.Empty)
{
this.ErrorMsgLabel.Text = s_CheckPage;
return;
}
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_CODE.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter((this.ddlPAY_TYPE.Text == "" ? "0" : ddlPAY_TYPE.Text), "int", this.CheckBoxLikeSearch.Checked));
//ParameterList.Add(0); //PAY_TYPE欄位，先放0，待SLP有值後再用上面的Code
ParameterList.Add(GetValueSetParameter(this.txtCOL_DAYS.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_NO.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_VALID_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_END_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_DATE.EndDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtSTOP_DATE.EndDate, "date", false));
//是否停止往來
if (this.rdoSTOP_DATE1.Checked == true)
ParameterList.Add(GetValueSetParameter("1", "string", false));
else if (this.rdoSTOP_DATE2.Checked == true)
ParameterList.Add(GetValueSetParameter("2", "string", false));
else
ParameterList.Add(GetValueSetParameter("3", "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_B2.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E1.Text, "string", false));
ParameterList.Add(GetValueSetParameter(this.txtTRACE_DATE_E2.Text, "string", false));
//是否最新合約
if (this.rdoIS_NEW1.Checked == true)
ParameterList.Add(GetValueSetParameter("Y", "string", false));
else
ParameterList.Add(GetValueSetParameter("N", "string", false));
//審核
ParameterList.Add(GetValueSetParameter(this.txtCNT_CONFIRM_CODE.Text.Trim(), "string", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtCREATEDATE.EndDate, "date", false));
//建立人員
ParameterList.Add(GetValueSetParameter(this.txtCREATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
//維護日期
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.StartDate, "date", false));
ParameterList.Add(GetValueSetParameter(this.txtUPDATEDATE.EndDate, "date", false));
//維護人員
ParameterList.Add(GetValueSetParameter(this.txtUPDATEUID.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(TextBoxRowCountLimit.Text.Trim().Length == 0 ? "10" : TextBoxRowCountLimit.Text);
//廠商名稱
ParameterList.Add(GetValueSetParameter(this.txtVENDOR_NAME.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked));
DataTable dt_Return = new DataTable();
BCO.MaintainVendorAgm bco = new BCO.MaintainVendorAgm(ConntionDB);
dt_Return = bco.QueryAgmByALL(ParameterList);
if (dt_Return.Rows.Count <= 0)
{
//btnExport.Visible = false;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "VDM021", string.Format("alert('查無資料');", Session["UID"].ToString().Trim()), true);
gv_VDM021.DataSource = dt_Return;
gv_VDM021.DataBind();
return;
}
string SessionIDName = "VDM021_gv_ItemInfo" + PageTimeStamp.Value;
gv_VDM021.Visible = true;
Session["SessionID"] = SessionIDName;
Session[SessionIDName] = dt_Return;
gv_VDM021.DataSource = dt_Return;
if (TextBoxPagesize.Text == "")
gv_VDM021.PageSize = 10;
else
gv_VDM021.PageSize = Convert.ToInt32(TextBoxPagesize.Text);
gv_VDM021.PageIndex = 0;
gv_VDM021.DataBind();
//btnExport.Visible = true;
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "VDM021.aspx?Code=VDM02", null, WUI_GMToolbarV.ClickAction.LinkURL);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", btnExport, WUI_GMToolbarV.ClickAction.ButtonClick);
#region 將Key值存到Session中
ArrayList arl_Key = new ArrayList();
foreach (DataRow drRow in dt_Return.Rows)
{ arl_Key.Add(drRow["CNT_NO"].ToString() + "|" + drRow["EDIT_NO"].ToString()); }
Session["VDM021_SortKey" + PageTimeStamp.Value] = arl_Key;
#endregion
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.ToString();
}
finally { }
}
