ComplianceServer/oldcode/WEB/Controllers/WeiXin/WXJobNumInfoController.cs

using System;
using System.Collections.Generic;
using System.Web.Mvc;
using WX.CRM.Common;
using WX.CRM.IBLL.Wx;
using WX.CRM.Model.Entity;
using WX.CRM.WebHelper;

namespace WX.CRM.WEB.Controllers.WeiXin
{
    public class WXJobNumInfoController : BaseController
    {
        ValidationErrors errors = new ValidationErrors();
        private IWX_JOBBIZINFO jobbizinfoBL;

        public WXJobNumInfoController(IWX_JOBBIZINFO _jobbizinfoBL)
        {
            this.jobbizinfoBL = _jobbizinfoBL;
        }

        #region 首页
        [AuthorizeRedirect(Roles = InitRights.CONST_工作微信号基础信息)]
        public ActionResult Index()
        {
            ToolBar tool = new ToolBar();
            string[] toolbtn = new ToolButtonView().ToolButtonRight(InitRights.工作微信号基础信息, userRightId);
            tool.AllowButton(toolbtn);
            tool.AddOtherButton("Other1", "导出", "icon-export", "Export_Click1", true);
            ViewBag.ToolBar = tool;

            Pager pager = new Pager() { page = 1, rows = 10 };
            string tableId = "tablist";
            Table tab = new Table(tableId);
            tab.AddHiddenHeadCol("PKID", "编号");
            tab.AddHeadCol("USERNAME", "12%", "微信用户名");
            tab.AddHeadCol("ALIAS", "12%", "微信号");
            tab.AddHeadCol("RESID", "12%", "客户ID");
            tab.AddHeadCol("NICKNAME", "", "昵称");
            tab.AddHeadCol("CONREMARK", "", "备注和标签");
            tab.AddHeadCol("UIN", "12%", "UIN码");
            tab.AddHeadCol("WEIXINSTRPATH", "12%", "目录串");
            tab.AddHeadCol("CTIME", "12%", "创建时间");
            tab.AddHeadCol("UTIME", "12%", "修改时间");
            tab.AddHeadRow();
            ViewBag.gridTable = tab.GetTable() + Pagination.GetPage(pager, tableId, "5,8,10,15");

            return View();
        }
        #endregion

        #region 列表
        [HttpPost]
        /// <summary>
        /// 按照条件获取数据
        /// </summary>
        /// <param name="pager"></param>
        /// <param name="queryStr"></param>
        /// <returns></returns>
        [AuthorizeRedirect(Roles = InitRights.CONST_工作微信号基础信息)]
        public JsonResult GetHtmlList(Pager pager, string Resid, string Username, string Num, string Memo, string nickName, string UIN, string Path, string columns)
        {
            string Stime = Request.Form["Stime"];
            string Etime = Request.Form["Etime"];

            List<WX_JOBBIZINFO> list = jobbizinfoBL.GetList(ref pager, Username, Num, nickName, Memo, Resid, UIN, Path, Stime, Etime);
            Table table = new Table(columns, true);
            table.gridPager = pager;
            foreach (WX_JOBBIZINFO model in list)
            {
                table.AddHiddenCol(model.PKID);
                table.AddCol(model.USERNAME);
                table.AddCol(model.ALIAS);
                table.AddCol(model.RESID);
                table.AddCol(model.NICKNAME);
                table.AddCol(model.CONREMARK);
                table.AddCol(model.UIN);
                table.AddCol(model.WEIXINSTRPATH);
                table.AddCol(model.CTIME);
                table.AddCol(model.UTIME);
                table.AddRow();
            }
            var json = new
            {
                totalPages = pager.totalPages,
                totalRows = pager.totalRows,
                rowsList = table.GetRows()
            };
            return Json(json, JsonRequestBehavior.AllowGet);
        }
        #endregion

        #region 编辑
        [HttpGet]
        [AuthorizeToolBar(InitRights.CONST_工作微信号基础信息, InitToolBar.CONST_Edit)]
        public ActionResult Edit(string id)
        {
            WX_JOBBIZINFO model = new WX_JOBBIZINFO();
            model = jobbizinfoBL.GetModel(Convert.ToDecimal(id));
            return View(model);
        }

        [HttpPost]
        [AuthorizeToolBar(InitRights.CONST_工作微信号基础信息, InitToolBar.CONST_Edit)]
        public JsonResult Edit(WX_JOBBIZINFO model)
        {
            if (!ModelState.IsValid)
            {
                return JsonHandler.ValidateFailMessage();
            }
            bool result = jobbizinfoBL.Update(ref errors, model);
            return JsonHandler.UpdateMessage(errors, result);
        }
        #endregion

        #region 删除
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [AuthorizeToolBar(InitRights.CONST_工作微信号基础信息, InitToolBar.CONST_Delete)]
        public JsonResult Delete(string id)
        {
            if (string.IsNullOrWhiteSpace(id))
            {
                return JsonHandler.ManageMessage("删除失败", false);
            }
            bool result = jobbizinfoBL.Delete(ref errors, Convert.ToDecimal(id));
            return JsonHandler.DeleteMessage(errors, result);
        }
        #endregion

        #region 导出
        [AuthorizeToolBar(InitRights.CONST_工作微信号基础信息, InitToolBar.CONST_Other1)]
        public FileResult ListExport()
        {
            string Resid = Request.QueryString["Resid"];
            string Username = Request.QueryString["Username"];
            string Num = Request.QueryString["Num"];
            string Memo = Request.QueryString["Memo"];
            string nickName = Request.QueryString["nickName"];
            //decimal isEmpty = Convert.ToInt32(Request.QueryString["isEmpty"]);
            string Stime = Request.QueryString["Stime"];
            string Etime = Request.QueryString["Etime"];
            string UIN = Request.QueryString["UIN"];
            string Path = Request.QueryString["Path"];

            Pager pager = new Pager() { rows = int.MaxValue, page = 1 };
            string checkedFilds = PageRequest.GetQueryString("checkedFilds");
            string checkedTitle = PageRequest.GetQueryString("checkedTitles");
            List<WX_JOBBIZINFO> list = jobbizinfoBL.GetList(ref pager, Username, Num, nickName, Memo, Resid, UIN, Path, Stime, Etime);

            return File(ExcelHelper.ExportListModelToExcel<WX_JOBBIZINFO>(list, "工作微信号基础信息", 60000, checkedFilds, checkedTitle, null), "application/ms-excel", PageRequest.GetDlownLoadName("工作微信号基础信息.xls"));
        }
        #endregion

    }
}