示例#1
0
        private void GetSearchData(int pageidx)
        {
            SlmScr048Biz bz = new SlmScr048Biz();
            //var lst = bz.GetDataForScreen(tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmCovFrom.DateValue, tdmCovTo.DateValue, tdmLeadFrom.DateValue, tdmLeadTo.DateValue, cmbTelesale.SelectedValue, cmbTelesaleName.SelectedValue, cmbType.SelectedValue);// tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmFrom.DateValue, tdmTo.DateValue, cmbTeamTelesale.SelectedValue, cmbTelsameName.SelectedValue, cmbStaffCategory.SelectedValue, cmbIncentiveFlat.SelectedValue);
            var lst = bz.GetDataForScreen2(tdmIncFrom.DateValue, tdmIncTo.DateValue, cmbTelesale.SelectedValue, cmbTelesaleName.SelectedValue, cmbType.SelectedValue);

            BindData(pgTop, pgBot, lst.ToArray(), pageidx);
        }
示例#2
0
        protected void btnExcel_Click(object sender, EventArgs e)
        {
            try
            {
                SlmScr048Biz bz       = new SlmScr048Biz();
                var          filename = Path.GetTempPath() + "\\tmpexcel_048_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName();

                if (bz.CreateExcel2(filename, tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmCovFrom.DateValue, tdmCovTo.DateValue, tdmLeadFrom.DateValue, tdmLeadTo.DateValue, cmbTelesale.SelectedValue, cmbTelesaleName.SelectedValue, cmbType.SelectedValue))
                {
                    ExportExcel(filename, "ผลงานประจำวันที่_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls");
                }
                else
                {
                    AppUtil.ClientAlert(this, bz.ErrorMessage);
                }
            }
            catch (Exception ex)
            {
                string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
                _log.Error(message);
                AppUtil.ClientAlert(Page, message);
            }
        }