private void GVPkgHisDataBind()
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from gen_pkg_inv_his_v where 1=1");
if (DdlHisType.SelectedValue != "0")
{
sql.Append(" and his_type='" + DdlHisType.SelectedValue + "'");
}
if (TxtPackageNo.Text.Trim() != "")
{
sql.Append(" and package_no like '" + TxtPackageNo.Text + "'");
}
if (TxtPartNo.Text.Trim() != "")
{
sql.Append(" and part_no like '" + TxtPartNo.Text + "'");
}
if (TxtTime.Text.Trim() != "" || TxtDateEnd.Text.Trim() != "")
{
if (TxtDateEnd.Text.Trim() == TxtTime.Text.Trim())
{
sql.Append(string.Format(" and to_char(his_time,'yyyy-mm-dd')='{0}'", TxtTime.Text.Trim()));
}
else
{
sql.Append(string.Format(" and to_char(his_time,'yyyy-mm-dd') >= '{0}' and to_char(his_time,'yyyy-mm-dd') < '{1}'",
TxtTime.Text.Trim() == "" ? "2010-01-01" : TxtTime.Text, TxtDateEnd.Text.Trim() == "" ? string.Format("{0:yyyy-MM-dd}", DateTime.Now) : TxtDateEnd.Text));
}
}
if (TxtArea.Text.Trim() != "")
{
sql.Append(" and area like '" + TxtArea.Text + "'");
}
if (TxtLocation.Text.Trim() != "")
{
sql.Append(" and location like '" + TxtLocation.Text + "'");
}
sql.Append(" order by his_time");
GVPkgHis.DataSource = DBHelper.createGridView(sql.ToString());
GVPkgHis.DataBind();
}
protected void BtnExport_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + string.Format("{0:yyyyMMddHHmmss}", dt) + ".xls");
Response.ContentType = "application/excel";
Response.Write(@"<style> .TextCell {mso-number-format:\@;}</style>");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GVPkgHis.AllowPaging = false;
GVPkgHisDataBind();
GVPkgHis.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
//GVData.AllowPaging = true;
GVPkgHisDataBind();
}
