324 lines
13 KiB
C#
324 lines
13 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Web.Mvc;
|
|
using WX.CRM.Common;
|
|
using WX.CRM.IBLL.Wx;
|
|
using WX.CRM.WebHelper;
|
|
|
|
namespace WX.CRM.WEB.Controllers.WeiXin
|
|
{
|
|
public class BonusUserController : BaseController
|
|
{
|
|
private readonly IWX_BONUSSALEUSER _bonussaleuser;
|
|
|
|
public BonusUserController(IWX_BONUSSALEUSER bonussaleuser)
|
|
{
|
|
_bonussaleuser = bonussaleuser;
|
|
}
|
|
|
|
[HttpGet]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public ActionResult Index()
|
|
{
|
|
ToolBar tb = new ToolBar();
|
|
string[] balance = new ToolButtonView().ToolButtonRight(InitRights.奖励确认, userRightId);
|
|
tb.AllowButton(balance);
|
|
tb.AddOtherButton("Other1", "确认", "icon-export", "BtnSvae", true);
|
|
ViewBag.ToolBar = tb;
|
|
|
|
Table tab1 = new Table("tablist1");
|
|
tab1.AddHeadCol("uname", "", "姓名");
|
|
tab1.AddHeadCol("eid", "", "工号");
|
|
tab1.AddHeadCol("PerformanceAmount", "", "业绩额");
|
|
tab1.AddHeadCol("rank", "", "排名");
|
|
tab1.AddHeadCol("bonus", "", "奖金");
|
|
tab1.AddHeadRow();
|
|
ViewBag.table1 = tab1.GetTable();
|
|
|
|
Table tab2 = new Table("tablist2");
|
|
tab2.AddHeadCol("uname", "", "姓名");
|
|
tab2.AddHeadCol("eid", "", "工号");
|
|
tab2.AddHeadCol("PerformanceAmount", "", "业绩额");
|
|
tab2.AddHeadCol("rank", "", "排名");
|
|
tab2.AddHeadCol("bonus", "", "奖金");
|
|
tab2.AddHeadRow();
|
|
ViewBag.table2 = tab2.GetTable();
|
|
|
|
Table tab3 = new Table("tablist3");
|
|
tab3.AddHeadCol("uname", "", "姓名");
|
|
tab3.AddHeadCol("eid", "", "工号");
|
|
tab3.AddHeadCol("OrderCount", "", "单量");
|
|
tab3.AddHeadCol("rank", "", "排名");
|
|
tab3.AddHeadCol("bonus", "", "奖金");
|
|
tab3.AddHeadRow();
|
|
ViewBag.table3 = tab3.GetTable();
|
|
|
|
Table tab4 = new Table("tablist4");
|
|
tab4.AddHeadCol("uname", "", "姓名");
|
|
tab4.AddHeadCol("eid", "", "工号");
|
|
tab4.AddHeadCol("OrderCount", "", "单量");
|
|
tab4.AddHeadCol("rank", "", "排名");
|
|
tab4.AddHeadCol("bonus", "", "奖金");
|
|
tab4.AddHeadRow();
|
|
ViewBag.table4 = tab4.GetTable();
|
|
|
|
Table tab5 = new Table("tablist5");
|
|
tab5.AddHeadCol("uname", "", "姓名");
|
|
tab5.AddHeadCol("eid", "", "工号");
|
|
tab5.AddHeadCol("PerformanceAmount", "", "业绩额");
|
|
tab5.AddHeadCol("bonus", "", "奖金");
|
|
tab5.AddHeadRow();
|
|
ViewBag.table5 = tab5.GetTable();
|
|
|
|
Table tab6 = new Table("tablist6");
|
|
tab6.AddHeadCol("uname", "", "姓名");
|
|
tab6.AddHeadCol("eid", "", "工号");
|
|
tab6.AddHeadCol("OrderCount", "", "单量");
|
|
tab6.AddHeadCol("bonus", "", "奖金");
|
|
tab6.AddHeadRow();
|
|
ViewBag.table6 = tab6.GetTable();
|
|
|
|
return View();
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public JsonResult GetAchievementWeek(DateTime week, string columns)
|
|
{
|
|
var table = new Table(columns, true);
|
|
var ds = _bonussaleuser.GetAchievementWeek(week);
|
|
foreach (DataRow dataRow in ds.Tables[0].Rows)
|
|
{
|
|
table.AddCol(string.Format("{0}", InnerUserHelper.Instance.GetUsername(decimal.Parse(dataRow["saleuserid"].ToString()))));
|
|
table.AddCol(InnerUserHelper.Instance.GetEidByUserId(decimal.Parse(dataRow["saleuserid"].ToString())));
|
|
table.AddCol(dataRow["PerformanceAmount"]);
|
|
table.AddCol(dataRow["rank"]);
|
|
table.AddCol(dataRow["bonus"]);
|
|
table.AddRow();
|
|
}
|
|
var json = new
|
|
{
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public JsonResult GetAchievementMonth(DateTime month, string columns)
|
|
{
|
|
var table = new Table(columns, true);
|
|
var ds = _bonussaleuser.GetAchievementMonth(month);
|
|
foreach (DataRow dataRow in ds.Tables[0].Rows)
|
|
{
|
|
table.AddCol(string.Format("{0}", InnerUserHelper.Instance.GetUsername(decimal.Parse(dataRow["saleuserid"].ToString()))));
|
|
table.AddCol(InnerUserHelper.Instance.GetEidByUserId(decimal.Parse(dataRow["saleuserid"].ToString())));
|
|
table.AddCol(dataRow["PerformanceAmount"]);
|
|
table.AddCol(dataRow["rank"]);
|
|
table.AddCol(dataRow["bonus"]);
|
|
table.AddRow();
|
|
}
|
|
var json = new
|
|
{
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public JsonResult GetOrderCountWeek(DateTime week, string columns)
|
|
{
|
|
var table = new Table(columns, true);
|
|
var ds = _bonussaleuser.GetOrderCountWeek(week);
|
|
foreach (DataRow dataRow in ds.Tables[0].Rows)
|
|
{
|
|
table.AddCol(string.Format("{0}", InnerUserHelper.Instance.GetUsername(decimal.Parse(dataRow["saleuserid"].ToString()))));
|
|
table.AddCol(InnerUserHelper.Instance.GetEidByUserId(decimal.Parse(dataRow["saleuserid"].ToString())));
|
|
table.AddCol(dataRow["OrderCount"]);
|
|
table.AddCol(dataRow["rank"]);
|
|
table.AddCol(dataRow["bonus"]);
|
|
table.AddRow();
|
|
}
|
|
var json = new
|
|
{
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public JsonResult GetOrderCountMonth(DateTime month, string columns)
|
|
{
|
|
var table = new Table(columns, true);
|
|
var ds = _bonussaleuser.GetOrderCountMonth(month);
|
|
foreach (DataRow dataRow in ds.Tables[0].Rows)
|
|
{
|
|
table.AddCol(string.Format("{0}", InnerUserHelper.Instance.GetUsername(decimal.Parse(dataRow["saleuserid"].ToString()))));
|
|
table.AddCol(InnerUserHelper.Instance.GetEidByUserId(decimal.Parse(dataRow["saleuserid"].ToString())));
|
|
table.AddCol(dataRow["OrderCount"]);
|
|
table.AddCol(dataRow["rank"]);
|
|
table.AddCol(dataRow["bonus"]);
|
|
table.AddRow();
|
|
}
|
|
var json = new
|
|
{
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public JsonResult GetOrderPayMax(DateTime month, string columns)
|
|
{
|
|
var table = new Table(columns, true);
|
|
var ds = _bonussaleuser.GetOrderPayMax(month);
|
|
foreach (DataRow dataRow in ds.Tables[0].Rows)
|
|
{
|
|
table.AddCol(string.Format("{0}", InnerUserHelper.Instance.GetUsername(decimal.Parse(dataRow["saleuserid"].ToString()))));
|
|
table.AddCol(InnerUserHelper.Instance.GetEidByUserId(decimal.Parse(dataRow["saleuserid"].ToString())));
|
|
table.AddCol(dataRow["PerformanceAmount"]);
|
|
table.AddCol(dataRow["bonus"]);
|
|
table.AddRow();
|
|
}
|
|
var json = new
|
|
{
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_员工奖励)]
|
|
public JsonResult GetNewEntryOpenOrder(string columns)
|
|
{
|
|
var table = new Table(columns, true);
|
|
var ds = _bonussaleuser.GetNewEntryOpenOrder();
|
|
foreach (DataRow dataRow in ds.Tables[0].Rows)
|
|
{
|
|
table.AddCol(string.Format("{0}", InnerUserHelper.Instance.GetUsername(decimal.Parse(dataRow["saleuserid"].ToString()))));
|
|
table.AddCol(InnerUserHelper.Instance.GetEidByUserId(decimal.Parse(dataRow["saleuserid"].ToString())));
|
|
table.AddCol(dataRow["OrderCount"]);
|
|
table.AddCol(dataRow["bonus"]);
|
|
table.AddRow();
|
|
}
|
|
var json = new
|
|
{
|
|
rowsList = table.GetRows()
|
|
};
|
|
return Json(json, JsonRequestBehavior.AllowGet);
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_奖励确认)]
|
|
public JsonResult SaveAchievementWeek(DateTime week)
|
|
{
|
|
try
|
|
{
|
|
var result = _bonussaleuser.SaveBonusSaleUser(1, week, UserId, UserName);
|
|
if (result)
|
|
return Json(new { result = "ok", message = "操作成功！" }, JsonRequestBehavior.AllowGet);
|
|
return Json(new { result = "exist", message = "记录已经存在，请确认！" }, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("BonusUserController/SaveAchievementWeek:" + ex.Message);
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_奖励确认)]
|
|
public JsonResult SaveAchievementMonth(DateTime month)
|
|
{
|
|
try
|
|
{
|
|
var result = _bonussaleuser.SaveBonusSaleUser(2, month, UserId, UserName);
|
|
if (result)
|
|
return Json(new { result = "ok", message = "操作成功！" }, JsonRequestBehavior.AllowGet);
|
|
return Json(new { result = "exist", message = "记录已经存在，请确认！" }, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("BonusUserController/SaveAchievementWeek:" + ex.Message);
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_奖励确认)]
|
|
public JsonResult SaveOrderCountWeek(DateTime week)
|
|
{
|
|
try
|
|
{
|
|
var result = _bonussaleuser.SaveBonusSaleUser(3, week, UserId, UserName);
|
|
if (result)
|
|
return Json(new { result = "ok", message = "操作成功！" }, JsonRequestBehavior.AllowGet);
|
|
return Json(new { result = "exist", message = "记录已经存在，请确认！" }, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("BonusUserController/SaveAchievementWeek:" + ex.Message);
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_奖励确认)]
|
|
public JsonResult SaveOrderCountMonth(DateTime month)
|
|
{
|
|
try
|
|
{
|
|
var result = _bonussaleuser.SaveBonusSaleUser(4, month, UserId, UserName);
|
|
if (result)
|
|
return Json(new { result = "ok", message = "操作成功！" }, JsonRequestBehavior.AllowGet);
|
|
return Json(new { result = "exist", message = "记录已经存在，请确认！" }, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("BonusUserController/SaveAchievementWeek:" + ex.Message);
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_奖励确认)]
|
|
public JsonResult SaveOrderPayMax(DateTime month)
|
|
{
|
|
try
|
|
{
|
|
var result = _bonussaleuser.SaveBonusSaleUser(5, month, UserId, UserName);
|
|
if (result)
|
|
return Json(new { result = "ok", message = "操作成功！" }, JsonRequestBehavior.AllowGet);
|
|
return Json(new { result = "exist", message = "记录已经存在，请确认！" }, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("BonusUserController/SaveAchievementWeek:" + ex.Message);
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
[HttpPost]
|
|
[AuthorizeRedirect(Roles = InitRights.CONST_奖励确认)]
|
|
public JsonResult SaveNewEntryOpenOrder()
|
|
{
|
|
try
|
|
{
|
|
var result = _bonussaleuser.SaveBonusSaleUser(6, DateTime.Now, UserId, UserName);
|
|
if (result)
|
|
return Json(new { result = "ok", message = "操作成功！" }, JsonRequestBehavior.AllowGet);
|
|
return Json(new { result = "exist", message = "记录已经存在，请确认！" }, JsonRequestBehavior.AllowGet);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error("BonusUserController/SaveAchievementWeek:" + ex.Message);
|
|
return JsonHandler.ManageMessage(ex.Message, false);
|
|
}
|
|
}
|
|
|
|
}
|
|
}
|