ProjectEntryController.cs 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225
  1. using Ant.Data;
  2. using Ant.ORM;
  3. using Ant.SuperSocket.Common;
  4. using Ant.Service.Common;
  5. using Ant.Service.Common.Enums;
  6. using Central.Control.Domain;
  7. using MES.Production.Entity;
  8. using MES.Production.Entity.Entity;
  9. using MES.Production.Entity.Enum;
  10. using Ant.Service.Mongodb;
  11. using MES.Production.Service.IService;
  12. using MES.Production.Service.ServiceImp;
  13. using Ant.Service.Utility;
  14. using ChangFa.Machinery.WebPage.Areas.SysManage.Models;
  15. using ChangFa.Machinery.WebPage.Controllers;
  16. using MongoDB.Driver.Builders;
  17. using System;
  18. using System.Collections.Generic;
  19. using System.Data;
  20. using System.Data.Objects.SqlClient;
  21. using System.IO;
  22. using System.Linq;
  23. using System.Text;
  24. using System.Web;
  25. using System.Web.Mvc;
  26. using JsonHelper = Ant.Service.Common.JsonHelper;
  27. namespace ChangFa.Machinery.WebPage.Areas.SysManage.Controllers
  28. {
  29. public class ProjectEntryController : BaseController
  30. {
  31. public ActionResult ProjectEntryList(string SEPID, string SCID,string State)
  32. {
  33. try
  34. {
  35. PageInfo pageInfo = new PageInfo(base.page, base.pagesize, 0, JsonConverter.JsonClass(new List<YW_ProjectEntry>()));
  36. #region 加载列表
  37. using (AntORM orm = new AntORM())
  38. {
  39. orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
  40. RequestModel res = new RequestModel();
  41. res.newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取项目规则列表" };
  42. var judgeList = orm.Queryable<YW_ProjectEntry>();
  43. int pageno = (base.page - 1) * base.pagesize;
  44. ViewData["SEPID"] = SEPID;
  45. ViewData["SCID"] = SCID;
  46. ViewData["State"] = State;
  47. //var SCID = Request["SCID"];
  48. //var SEPID = Request["SEPID"];
  49. judgeList = judgeList.Where(p => p.SCID == SCID && p.SEPID == SEPID);
  50. var reslut = judgeList.OrderByDesc(p => p.CreateDate).Skip(pageno).Top(pagesize).ToList(res);
  51. //var reslut = coachList.OrderByDesc(p => p.UpdateTime).Skip(pageno).Top(pagesize).ToList(res);
  52. if (reslut.IsSuccess)
  53. {
  54. reslut.RecordNum = judgeList.Count();
  55. pageInfo = new PageInfo(base.page, base.pagesize, reslut.RecordNum, JsonConverter.JsonClass(reslut.ResultModel));
  56. }
  57. RequestModel request = new RequestModel
  58. {
  59. newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "查询组别的单个实体方法" },
  60. Oid = SCID
  61. };
  62. var rsp = orm.GetEntity<YW_EntryConditions>(request);
  63. if (rsp.IsSuccess)
  64. {
  65. ViewBag.ConditionsName = rsp.ResultModel.Constituencies;
  66. }
  67. else
  68. {
  69. ViewBag.ConditionsName = string.Empty;
  70. }
  71. }
  72. return View(pageInfo);
  73. #endregion
  74. }
  75. catch (Exception e)
  76. {
  77. WriteLog(enumOperator.Select, "获取参赛列表:", e);
  78. throw e.InnerException;
  79. }
  80. }
  81. public ActionResult Delete(string idList)
  82. {
  83. JsonHelper json = new JsonHelper() { Status = "n", Msg = "删除项目规则成功" };
  84. try
  85. {
  86. //是否为空
  87. if (string.IsNullOrEmpty(idList)) { json.Msg = "未找到要删除的项目规则"; return Json(json); }
  88. string[] id = idList.Trim(',').Split(',');
  89. for (int i = 0; i < id.Length; i++)
  90. {
  91. var userId = (id[i]);
  92. using (AntORM orm = new AntORM())
  93. {
  94. orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
  95. RequestModel request = new RequestModel
  96. {
  97. newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "删除项目规则" },
  98. Oid = userId.ToString()
  99. };
  100. var reslut = orm.DeleteById<YW_ProjectEntry>(request);
  101. if (reslut.IsSuccess)
  102. {
  103. int ecid = userId.ToInt32();
  104. var reportreslut = orm.DeleteByLambda<YW_MatchReport>(p => p.PEID == ecid, request);
  105. json.Status = "y";
  106. WriteLog(enumOperator.Remove, json.Msg, enumLog4net.WARN);
  107. }
  108. }
  109. }
  110. }
  111. catch (Exception e)
  112. {
  113. json.Msg = "删除项目规则发生内部错误!";
  114. WriteLog(enumOperator.Remove, "删除项目规则:", e);
  115. }
  116. return Json(json);
  117. }
  118. [ValidateInput(false)]
  119. [HttpPost]
  120. public ActionResult Save(YW_ProjectEntry entity)
  121. {
  122. JsonHelper json = new JsonHelper() { Msg = "保存项目规则成功", Status = "n", ReUrl = "/Sys/ProjectEntry/ProjectEntryList" };
  123. try
  124. {
  125. if (entity.BoysMum > 0 || entity.GirlsMum > 0)
  126. {
  127. if (entity.MixedMum > 0)
  128. {
  129. json.Msg = "混合和男女不能同时填写!";
  130. return Json(json);
  131. }
  132. }
  133. using (AntORM orm = new AntORM())
  134. {
  135. orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
  136. RequestModel request = new RequestModel();
  137. request.newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "保存项目规则" };
  138. if (entity.ID > 0)
  139. {
  140. var reslut = orm.UpdateByLambda<YW_ProjectEntry>(p => new YW_ProjectEntry { MixedMum = entity.MixedMum, GirlsMum = entity.GirlsMum, BoysMum = entity.BoysMum }, p => p.ID == entity.ID, request);
  141. if (reslut.IsSuccess)
  142. {
  143. json.Status = "y";
  144. }
  145. else
  146. {
  147. json.Msg = "保存项目规则失败";
  148. }
  149. }
  150. else
  151. {
  152. entity.Createper = this.CurrentUser.Name;
  153. entity.CreateDate = DateTime.Now;
  154. var reslut = orm.Save(entity, request);
  155. if (reslut.IsSuccess)
  156. {
  157. json.Status = "y";
  158. }
  159. else
  160. {
  161. json.Msg = "保存项目规则失败";
  162. }
  163. }
  164. }
  165. }
  166. catch (Exception ex)
  167. {
  168. json.Msg = "保存项目规则发生内部错误!";
  169. WriteLog(enumOperator.None, "保存项目规则:", ex);
  170. }
  171. return Json(json);
  172. }
  173. public ActionResult Detail(int? id, string conditionsName)
  174. {
  175. YW_ProjectEntry mod = new YW_ProjectEntry();
  176. if (id != null)
  177. {
  178. using (AntORM orm = new AntORM())
  179. {
  180. try
  181. {
  182. orm.db = DataAccessFactory.CreateDataConnection("CyclingItem");
  183. RequestModel request = new RequestModel
  184. {
  185. newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "查询项目规则的单个实体方法" },
  186. Oid = id.ToString()
  187. };
  188. var reslut = orm.GetEntity<YW_ProjectEntry>(request);
  189. if (reslut.IsSuccess)
  190. {
  191. mod = reslut.ResultModel;
  192. }
  193. }
  194. catch (Exception e)
  195. {
  196. }
  197. }
  198. }
  199. ViewData["conditionsName"] = conditionsName;
  200. return View(mod);
  201. }
  202. }
  203. }