示例#1
0
    /// <summary>
    ///
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void ImgExpExcel_Click(object sender, EventArgs e)
    {
        try
        {
            int rowcount = ucCustomPagerItems.isCountRecord;

            string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
            int?   sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
            {
                sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
            }

            BLL_Crew_Admin objBLL = new BLL_Crew_Admin();
            DataTable      dt     = objBLL.CRW_LIB_Export_OilMajor();

            if (dt.Rows.Count > 0)
            {
                string[] HeaderCaptions  = { "Oil Major Name", "Display Name", "Remark", "Active Status" };
                string[] DataColumnsName = { "Oil_Major_Name", "Display_Name", "Remarks", "Active Status" };

                GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "OilMajors" + "_" + DateTime.Now.ToString("yyyy-MM-dd HH.mm.ss"), "Oil Majors", "");
            }
        }
        catch (Exception ex)
        {
            UDFLib.WriteExceptionLog(ex);
        }
    }