using Ant.Data;
using Ant.ORM;
using Ant.Service.Common;
using Ant.Service.Common.Enums;
using MES.Production.Entity;
using MES.Production.Entity.Entity;
using ChangFa.Machinery.WebPage.Controllers;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using JsonHelper = Ant.Service.Common.JsonHelper;
namespace ChangFa.Machinery.WebPage.Areas.SysManage.Controllers
{
public class UserDistributorsController : BaseController
{
// GET: SysManage/UserDistributors
[UserAuthorize(ModuleAlias = "SalesDealersList", OperaAction = "View")]
public ActionResult Index()
{
string distributorsID = string.Empty;
if (!Request.QueryString["distributorsid"].IsEmpty())
{
distributorsID = Request.QueryString["distributorsid"].ToString();
}
ViewData["distributorsid"] = distributorsID;
PageInfo pageInfo = new PageInfo(base.page, base.pagesize, 0, JsonConverter.JsonClass(new List<UserProudctLine>()));
List<UserProudctLine> userlist = new List<UserProudctLine>();
using (AntORM orm = new AntORM())
{
orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
RequestModel res = new RequestModel
{
newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取公告信息" }
};
IQuery<En_SYS_USER> userquery = orm.Queryable<En_SYS_USER>();
IQuery<EntYW_UserDistributor> userdis = orm.Queryable<EntYW_UserDistributor>();
IJoiningQuery<En_SYS_USER, EntYW_UserDistributor> user_dis = userquery.LeftJoin(userdis, (user, city) => user.ID == city.userId);
var qq = user_dis.Select((user, city) => new { Users = user, Citys = city }).Where(a => a.Citys.distributorId == distributorsID);
var reslut = qq.ToList(res);
if (reslut.IsSuccess)
{
foreach (var mod in reslut.ResultModel)
{
En_SYS_USER user = mod.Users; EntYW_UserDistributor useridmod = mod.Citys;
UserProudctLine proudctLine = new UserProudctLine();
proudctLine.id = useridmod.ID.ToString();
proudctLine.name = user.NAME;
string productlinestr = string.Empty;
if (useridmod.ProductLine.IfNotNull())
{
if (useridmod.ProductLine == 601)
{
productlinestr = productlinestr + "轮拖、";
}
}
if (useridmod.ProductLine1.IfNotNull())
{
if (useridmod.ProductLine1 == 615)
{
productlinestr = productlinestr + "轮式收、";
}
}
if (useridmod.ProductLine2.IfNotNull())
{
if (useridmod.ProductLine2 == 612)
{
productlinestr = productlinestr + "履带收、";
}
}
if (useridmod.ProductLine3.IfNotNull())
{
if (useridmod.ProductLine3 == 611)
{
productlinestr = productlinestr + "插秧机、";
}
}
if (useridmod.ProductLine4.IfNotNull())
{
if (useridmod.ProductLine4 == 622)
{
productlinestr = productlinestr + "玉米收、";
}
}
if (useridmod.ProductLine5.IfNotNull())
{
if (useridmod.ProductLine5 == 628)
{
productlinestr = productlinestr + "花生机、";
}
}
if (productlinestr.Length > 0)
proudctLine.proudctLine = productlinestr.Substring(0, productlinestr.Length - 1);
proudctLine.addName = useridmod.add_name;
proudctLine.addTime = useridmod.add_time;
userlist.Add(proudctLine);
pageInfo = new PageInfo(base.page, base.pagesize, reslut.RecordNum, JsonConverter.JsonClass(userlist));
}
}
}
return View(pageInfo);
}
public ActionResult Detail(string distributorsid)
{
EntYW_UserDistributor mod = new EntYW_UserDistributor();
ViewData["distributorsid"] = distributorsid;
return View(mod);
}
/// <summary>
/// 删除部门
/// </summary>
[UserAuthorizeAttribute(ModuleAlias = "SalesDealersList", OperaAction = "Remove")]
public ActionResult Delete(string idList)
{
JsonHelper json = new JsonHelper() { Msg = "删除经产品线负责人", ReUrl = "/UserDistributors/index", Status = "n" };
try
{
if (!string.IsNullOrEmpty(idList))
{
idList = idList.TrimEnd(',');
//判断是否有下属部门
using (AntORM orm = new AntORM())
{
orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
foreach (string id in idList.Split(','))
{
RequestModel request = new RequestModel
{
newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "查询菜单的单个实体方法" },
Oid = id.ToString()
};
Guid guid = new Guid(id);
var disreult = orm.DeleteByLambda<EntYW_UserDistributor>(p => p.ID == guid, request);
}
}
json.Status = "y";
}
else
{
json.Msg = "未找到要删除的记录";
}
WriteLog(enumOperator.Remove, "删除产品线负责人：" + json.Msg, enumLog4net.WARN);
}
catch (Exception e)
{
json.Msg = "删除产品线负责人发生内部错误！";
WriteLog(enumOperator.Remove, "删除产品线负责人：", e);
}
return Json(json);
}
/// <summary>
///
/// </summary>
/// <param name="content"></param>
/// <returns></returns>
[UserAuthorize(ModuleAlias = "SalesDealersList", OperaAction = "Add,Edit")]
[ValidateInput(false)]
[HttpPost]
public ActionResult Save(string distributorsid, Ent_YW_Notice entity)
{
JsonHelper json = new JsonHelper() { Msg = "经销商产品负责人添加成功", Status = "n", ReUrl = "/UserDistributors/Index" };
try
{
var productLine = string.Empty; int ProductLine = 0; int ProductLine1 = 0; int ProductLine2 = 0; int ProductLine3 = 0; int ProductLine4 = 0; int ProductLine5 = 0;
if (!Request["productline"].IsEmpty())
{
productLine = Request["productline"].ToString();
}
var useridstr = Request.Form["hidsendUserid"]; int userid = 0;
if (!useridstr.IsEmpty())
{
userid = useridstr.ToInt32();
}
foreach (var s in productLine.Split(','))
{
if (s == "601")
{
ProductLine = 601;
}
if (s == "615")
{
ProductLine1 = 615;
}
if (s == "612")
{
ProductLine2 = 612;
}
if (s == "611")
{
ProductLine3 = 611;
}
if (s == "622")
{
ProductLine4 = 622;
}
if (s == "628")
{
ProductLine5 = 628;
}
}
using (AntORM orm = new AntORM())
{
orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
RequestModel res = new RequestModel
{
newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取公告信息" }
};
var reslut = orm.Queryable<EntYW_UserDistributor>().Where(p => p.distributorId == distributorsid && p.userId == userid).FirstOrDefault(res);
if (reslut.IsSuccess)
{
var updatereslut = orm.UpdateByLambda<EntYW_UserDistributor>(p => new EntYW_UserDistributor { ProductLine = ProductLine, ProductLine1 = ProductLine1, ProductLine2 = ProductLine2, ProductLine3 = ProductLine3, ProductLine4 = ProductLine4, ProductLine5 = ProductLine5 }, p => p.distributorId == distributorsid && p.userId == userid, res);
}
else
{
EntYW_UserDistributor usemod = new EntYW_UserDistributor();
usemod.ID = Guid.NewGuid();
usemod.ProductLine = ProductLine;
usemod.ProductLine1 = ProductLine1;
usemod.ProductLine2 = ProductLine2;
usemod.ProductLine3 = ProductLine3;
usemod.ProductLine4 = ProductLine4;
usemod.ProductLine5 = ProductLine5;
usemod.userId = userid;
usemod.distributorId = distributorsid;
usemod.add_name = CurrentUser.Name;
usemod.add_time = DateTime.Now;
usemod.distype = 0;
var ress = orm.Save(usemod, res);
if (ress.IsSuccess)
{
json.Status = "y";
}
}
}
}
catch (Exception ex)
{
}
return Json(json);
}
}
}