113 lines
5.1 KiB
C#
113 lines
5.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Web.Mvc;
|
|
using WX.CRM.Common;
|
|
using WX.CRM.IBLL.QH;
|
|
using WX.CRM.Model.Entity;
|
|
using WX.CRM.WebHelper;
|
|
|
|
namespace WX.CRM.WEB.Controllers.QH
|
|
{
|
|
public class CustomerSaleUserLogController : BaseController
|
|
{
|
|
//
|
|
// GET: /CustomerSaleUserLog/
|
|
private IQH_CUSTOMER_SALEUSER_LOG _iqh_Customer_SaleUser_Log;
|
|
public CustomerSaleUserLogController(IQH_CUSTOMER_SALEUSER_LOG iQH_CUSTOMER_SALEUSER_LOG)
|
|
{
|
|
this._iqh_Customer_SaleUser_Log = iQH_CUSTOMER_SALEUSER_LOG;
|
|
}
|
|
[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_Click", true);
|
|
ViewBag.ToolBar = tool;
|
|
|
|
Pager pager = new Pager() { page = 1, rows = 10 };
|
|
string tableId = "tablist";
|
|
Table tab = new Table(tableId);
|
|
tab.AddHiddenHeadCol("PKID", "PKID");
|
|
tab.AddHeadCol("USERACCOUNT", "", "资金账号");
|
|
tab.AddHeadCol("OLDEID", "", "旧客服工号");
|
|
tab.AddHeadCol("OLDGID", "", "旧客服组");
|
|
tab.AddHeadCol("NEWEID", "", "新客服工号");
|
|
tab.AddHeadCol("NEWGID", "", "新客服组");
|
|
tab.AddHeadCol("STARTDATE", "", "分配时间");
|
|
tab.AddHeadCol("OPERATORID", "", "操作人");
|
|
tab.AddHeadCol("CTIME", "", "创建时间");
|
|
tab.AddHeadRow();
|
|
ViewBag.List = tab.GetTable() + Pagination.GetPage(pager, tableId, "5,10,15,20");
|
|
return View();
|
|
}
|
|
public JsonResult GetHtml(Pager pager, string userAccount, decimal? olduserId, decimal? newuserId, DateTime? starttime, DateTime? endtime, string columns)
|
|
{
|
|
try
|
|
{
|
|
List<QH_CUSTOMER_SALEUSER_LOG> list = _iqh_Customer_SaleUser_Log.GetList(ref pager, userAccount, olduserId, newuserId, starttime, endtime);
|
|
Table table = new Table(columns, true);
|
|
table.gridPager = pager;
|
|
foreach (QH_CUSTOMER_SALEUSER_LOG model in list)
|
|
{
|
|
string oldgroupname = InnerUserHelper.Instance.GetGroupName(model.OLDGID);
|
|
string newgroupname = InnerUserHelper.Instance.GetGroupName(model.NEWGID);
|
|
table.AddHiddenCol(model.PKID);
|
|
table.AddCol(model.USERACCOUNT);
|
|
table.AddCol(model.OLDEID);
|
|
table.AddCol(oldgroupname);
|
|
table.AddCol(model.NEWEID);
|
|
table.AddCol(newgroupname);
|
|
table.AddCol(model.STARTDATE.ToString("yyyy-MM-dd HH:mm:ss"));
|
|
table.AddCol(InnerUserHelper.Instance.GetUsername(model.OPERATORID));
|
|
table.AddCol(model.CTIME.ToString("yyyy-MM-dd HH:mm:ss"));
|
|
table.AddRow();
|
|
|
|
}
|
|
var json = new
|
|
{
|
|
totalPages = pager.totalPages,
|
|
totalRows = pager.totalRows,
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error(ex.ToString());
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
#region 期货客服分配日志导出
|
|
public FileResult Export(string userAccount, decimal? olduserId, decimal? newuserId, DateTime? starttime, DateTime? endtime)
|
|
{
|
|
string checkedFilds = PageRequest.GetQueryString("checkedFilds");
|
|
checkedFilds = checkedFilds.Replace("[]", "");
|
|
string checkedTitles = PageRequest.GetQueryString("checkedTitles");
|
|
Pager pager = new Pager() { page = 1, rows = int.MaxValue };
|
|
List<QH_CUSTOMER_SALEUSER_LOG> list = _iqh_Customer_SaleUser_Log.GetList(ref pager, userAccount, olduserId, newuserId, starttime, endtime);
|
|
return File(ExcelHelper.ExportListModelToExcel<QH_CUSTOMER_SALEUSER_LOG>(list, "期货客服分配日志", 10000, checkedFilds, checkedTitles, DataFormart), "application/ms-excel", PageRequest.GetDlownLoadName("期货客服分配日志.xls"));
|
|
}
|
|
//用作委托传递
|
|
public string DataFormart(string key, object value)
|
|
{
|
|
string formartValue = string.Empty;
|
|
switch (key)
|
|
{
|
|
case "OLDGID":
|
|
case "NEWGID":
|
|
formartValue = InnerUserHelper.Instance.GetGroupName(Convert.ToDecimal(value));
|
|
break;
|
|
case "OPERATORID":
|
|
formartValue = InnerUserHelper.Instance.GetUsername(Convert.ToDecimal(value)); break;
|
|
default: formartValue = string.Format("{0}", value); break;
|
|
}
|
|
return formartValue;
|
|
}
|
|
#endregion
|
|
|
|
}
|
|
}
|