protected void Lbprint_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=donhang.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
RplistOrder.Controls[0].Controls[0].FindControl("count_div").Visible = false;
RplistOrder.Controls[0].Controls[0].FindControl("check_div").Visible = false;
RplistOrder.Controls[0].Controls[0].FindControl("delete_div").Visible = false;
for (int i = 0; i < RplistOrder.Items.Count; i++)
{
Control _countmain_div = RplistOrder.Items[i].FindControl("count_main_div") as Control;
Control _checkmain_div = RplistOrder.Items[i].FindControl("check_main_div") as Control;
Control _deletemain_div = RplistOrder.Items[i].FindControl("deletemain_div") as Control;
_countmain_div.Visible = false;
_checkmain_div.Visible = false;
_deletemain_div.Visible = false;
}
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
RplistOrder.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
private void SearchResult()
{
try
{
string keyword = txtKeyword.Value;
//int Cat_Id=Utils.CIntDef(ddlCategory.SelectedValue);
DateTime fromDate = ucFromDate.returnDate;
DateTime toDate = new DateTime(ucToDate.returnDate.Year, ucToDate.returnDate.Month, ucToDate.returnDate.Day, 23, 59, 59);
int _limit = 20;
int _skip = 0;
if (_page != 0)
{
_skip = _page * _limit - _limit;
}
int _status = Utils.CIntDef(ddlStatus.SelectedValue);
var AllList = (from o in DB.ESHOP_ORDERs
join o_i in DB.ESHOP_ORDER_ITEMs on o.ORDER_ID equals o_i.ORDER_ID
where ("" == keyword || (o.ORDER_CODE).Contains(keyword) || (o.ORDER_FIELD1).Contains(keyword)) &&
o.ORDER_PUBLISHDATE <= toDate && o.ORDER_PUBLISHDATE >= fromDate &&
(_status != 99 ? o.ORDER_STATUS == _status : true)
orderby o.ORDER_PUBLISHDATE descending
select o).Distinct().OrderByDescending(n => n.ORDER_ID);
if (AllList.ToList().Count > 0)
{
Session["OrderList"] = DataUtil.LINQToDataTable(AllList);
}
RplistOrder.DataSource = AllList.Skip(_skip).Take(_limit);;
RplistOrder.DataBind();
LitPage.Text = pagechange.changePage("order_list.aspx", AllList.ToList().Count, _limit, _page);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
