Пример #1
0
        public void EXPORTYCGL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
        {
            int       total = 0;
            DataTable dt    = new SZHL_YCGLB().GetDataPager("SZHL_YCGL yc left join SZHL_YCGL_CAR car on yc.CarID=car.ID", "yc.*,car.CarBrand,car.CarType,car.CarNum ,dbo.fn_PDStatus(yc.intProcessStanceid) AS StateName", 2000, 1, " yc.CRDate desc", "", ref total);

            string     sqlCol = "SYUser|使用人,XCType|行程类别,CarNum|使用车辆,SYRS|用车人数,JSR|驾驶员,Remark|使用说明,StartTime|开始时间,EndTime|结束时间,StartAddress|出发地点,EndAddress|到达地点";
            CommonHelp ch     = new CommonHelp();
            DataTable  dt2    = dt.DelTableCol(sqlCol);

            foreach (DataRow dr in dt2.Rows)
            {
                try
                {
                    dr["使用人"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, dr["使用人"].ToString());
                    if (!string.IsNullOrEmpty(dr["驾驶员"].ToString()))
                    {
                        dr["驾驶员"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, dr["驾驶员"].ToString());
                    }
                }
                catch (Exception)
                {
                }
            }

            msg.ErrorMsg = ch.ExportToExcel("用车记录", dt2);
        }
Пример #2
0
        /// <summary>
        /// 导出任务
        /// </summary>
        /// <param name="context"></param>
        /// <param name="msg"></param>
        /// <param name="P1"></param>
        /// <param name="P2"></param>
        /// <param name="UserInfo"></param>
        public void EXPORTRW(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
        {
            GETRWGLLIST(context, msg, P1, P2, UserInfo);

            DataTable dt     = msg.Result;
            string    sqlCol = "CRUserName|负责人,CRUserName|创建人,TypeName|任务类型,RWJZDate|任务截止日期,RWTitle|任务标题,RWContent|任务内容";

            CommonHelp ch = new CommonHelp();

            DataTable dt2 = dt.DelTableCol(sqlCol);

            foreach (DataRow dr in dt2.Rows)
            {
                try
                {
                    dr["任务内容"] = CommonHelp.RemoveHtml(dr["任务内容"].ToString());
                }
                catch (Exception) { }
            }

            msg.ErrorMsg = ch.ExportToExcel("任务管理", dt2);
        }
Пример #3
0
        /// <summary>
        /// 导出工作报告
        /// </summary>
        /// <param name="context"></param>
        /// <param name="msg"></param>
        /// <param name="P1"></param>
        /// <param name="P2"></param>
        /// <param name="UserInfo"></param>
        public void EXPORTGZBG(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
        {
            GETGZBGLIST(context, msg, P1, P2, UserInfo);
            DataTable  dt     = msg.Result;
            string     sqlCol = "BranchName|部门,TypeName|类型,RBDate|日期,RBContent|报告内容,TypeName|类型,CRUserName|姓名,RBWCQK|完成情况";
            CommonHelp ch     = new CommonHelp();

            DataTable dt2 = dt.DelTableCol(sqlCol);

            foreach (DataRow dr in dt2.Rows)
            {
                try
                {
                    dr["报告内容"] = CommonHelp.RemoveHtml(dr["报告内容"].ToString());
                    dr["完成情况"] = CommonHelp.RemoveHtml(dr["完成情况"].ToString());
                }
                catch (Exception)
                {
                }
            }

            msg.ErrorMsg = ch.ExportToExcel("工作报告", dt2);
        }