You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

280 lines
8.1 KiB

4 days ago
  1. using NFine.Application;
  2. using NFine.Application.ProductManage;
  3. using NFine.Application.SRM;
  4. using NFine.Code;
  5. using NFine.Data.Extensions;
  6. using NFine.Domain.Entity.ProductManage;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.Data;
  10. using System.Data.SqlClient;
  11. using System.IO;
  12. using System.Linq;
  13. using System.Threading;
  14. using System.Web;
  15. using System.Web.Mvc;
  16. namespace NFine.Web.Areas.SRM.Controllers
  17. {
  18. public class BicDoc_BidResultController : ControllerBase
  19. {
  20. BicDoc_BidResultApp App = new BicDoc_BidResultApp();
  21. // GET: SRM/BicDoc_BidResult
  22. public ActionResult BidResult()
  23. {
  24. return View();
  25. }
  26. public ActionResult BidResultAdd()
  27. {
  28. return View();
  29. }
  30. public ActionResult BidResultDetail()
  31. {
  32. return View();
  33. }
  34. public ActionResult BidCourse()
  35. {
  36. return View();
  37. }
  38. public ActionResult BidCourseAdd()
  39. {
  40. return View();
  41. }
  42. public ActionResult BidCourseDetail()
  43. {
  44. return View();
  45. }
  46. public ActionResult BidCourseSearch()
  47. {
  48. return View();
  49. }
  50. public ActionResult BidCourseHistory()
  51. {
  52. return View();
  53. }
  54. public ActionResult BidCourseZSum()
  55. {
  56. return View();
  57. }
  58. [HttpGet]
  59. [HandlerAjaxOnly]
  60. public ActionResult GetSubGridJsonResult(Pagination pagination, string BidCode,string WorkPoint)
  61. {
  62. DataTable ListData = App.GetSubGridJsonResult(BidCode, WorkPoint, ref pagination);
  63. var JsonData = new
  64. {
  65. total = pagination.total,
  66. page = pagination.page,
  67. records = pagination.records,
  68. rows = ListData,
  69. };
  70. return Content(JsonData.ToJson());
  71. }
  72. [HttpGet]
  73. [HandlerAjaxOnly]
  74. public ActionResult GetSubGridJson(Pagination pagination, string BidCode)
  75. {
  76. DataTable ListData = App.GetSubGridJson(BidCode, ref pagination);
  77. var JsonData = new
  78. {
  79. total = pagination.total,
  80. page = pagination.page,
  81. records = pagination.records,
  82. rows = ListData,
  83. };
  84. return Content(JsonData.ToJson());
  85. }
  86. [HttpGet]
  87. [HandlerAjaxOnly]
  88. public ActionResult GetICSBidDocInfo(string BidCode, string WorkPoint)
  89. {
  90. DataTable ListData = App.GetICSBidDocInfo(BidCode, WorkPoint);
  91. var JsonData = new
  92. {
  93. rows = ListData,
  94. };
  95. return Content(JsonData.ToJson());
  96. }
  97. [HttpGet]
  98. [HandlerAjaxOnly]
  99. public ActionResult GetGrid(Pagination pagination, string queryJson)
  100. {
  101. DataTable ListData = App.GetGrid(queryJson, ref pagination);
  102. var JsonData = new
  103. {
  104. total = pagination.total,
  105. page = pagination.page,
  106. records = pagination.records,
  107. rows = ListData,
  108. };
  109. return Content(JsonData.ToJson());
  110. }
  111. [HttpGet]
  112. [HandlerAjaxOnly]
  113. public ActionResult GetGridCourse(Pagination pagination, string queryJson)
  114. {
  115. DataTable ListData = App.GetGridCourse(queryJson, ref pagination);
  116. var JsonData = new
  117. {
  118. total = pagination.total,
  119. page = pagination.page,
  120. records = pagination.records,
  121. rows = ListData,
  122. };
  123. return Content(JsonData.ToJson());
  124. }
  125. [HttpGet]
  126. [HandlerAjaxOnly]
  127. public ActionResult GetSubGridJsonCourse(Pagination pagination, string BidCode, string WorkPoint)
  128. {
  129. DataTable ListData = App.GetSubGridJsonCourse(BidCode, WorkPoint, ref pagination);
  130. var JsonData = new
  131. {
  132. total = pagination.total,
  133. page = pagination.page,
  134. records = pagination.records,
  135. rows = ListData,
  136. };
  137. return Content(JsonData.ToJson());
  138. }
  139. [HttpGet]
  140. [HandlerAjaxOnly]
  141. public ActionResult GetBidCourseInfo(string BidCode, string WorkPoint,string ID)
  142. {
  143. DataTable ListData = App.GetBidCourseInfo(BidCode, WorkPoint,ID);
  144. var JsonData = new
  145. {
  146. rows = ListData,
  147. };
  148. return Content(JsonData.ToJson());
  149. }
  150. [HttpGet]
  151. [HandlerAjaxOnly]
  152. public ActionResult GetSubGridJsonCourseInfo(Pagination pagination, string BidCode, string WorkPoint,string ID)
  153. {
  154. DataTable ListData = App.GetSubGridJsonCourseInfo(BidCode, WorkPoint,ID, ref pagination);
  155. var JsonData = new
  156. {
  157. total = pagination.total,
  158. page = pagination.page,
  159. records = pagination.records,
  160. rows = ListData,
  161. };
  162. return Content(JsonData.ToJson());
  163. }
  164. //[HttpGet]
  165. //[HandlerAjaxOnly]
  166. //public ActionResult BidCourseHistoryInfo(string BidCode, string WorkPoint, string InfoID,string BDID)
  167. //{
  168. // DataTable ListData = App.BidCourseHistoryInfo(BidCode, WorkPoint, InfoID, BDID);
  169. // var JsonData = new
  170. // {
  171. // rows = ListData,
  172. // };
  173. // return Content(JsonData.ToJson());
  174. //}
  175. [HttpGet]
  176. [HandlerAjaxOnly]
  177. public ActionResult BidResultINVENTORY(Pagination pagination, string BidCode,string WorkPoint)
  178. {
  179. DataTable ListData = App.BidResultINVENTORY(BidCode, WorkPoint, ref pagination);
  180. var JsonData = new
  181. {
  182. total = pagination.total,
  183. page = pagination.page,
  184. records = pagination.records,
  185. rows = ListData,
  186. };
  187. return Content(JsonData.ToJson());
  188. }
  189. [HttpGet]
  190. [HandlerAjaxOnly]
  191. public ActionResult BidResultVendor(Pagination pagination, string BidCode, string WorkPoint)
  192. {
  193. DataTable ListData = App.BidResultVendor(BidCode, WorkPoint, ref pagination);
  194. var JsonData = new
  195. {
  196. total = pagination.total,
  197. page = pagination.page,
  198. records = pagination.records,
  199. rows = ListData,
  200. };
  201. return Content(JsonData.ToJson());
  202. }
  203. [HttpGet]
  204. [HandlerAjaxOnly]
  205. public ActionResult BidCourseHistoryInfoCahrs(string BidCode, string WorkPoint, string ID, string InvCode)
  206. {
  207. DataTable ListData = App.BidCourseHistoryInfoCahrs(BidCode, WorkPoint, ID, InvCode);
  208. string ss = ListData.ToJson();
  209. return Content(ListData.ToJson());
  210. }
  211. [HttpGet]
  212. [HandlerAjaxOnly]
  213. public ActionResult BidCourseHistoryInfoInvCode(string BidCode, string WorkPoint, string ID)
  214. {
  215. DataTable ListData = App.BidCourseHistoryInfoInvCode(BidCode, WorkPoint, ID);
  216. return Content(ListData.ToJson());
  217. }
  218. [HttpGet]
  219. [HandlerAjaxOnly]
  220. public ActionResult BidCourseHistoryInfo(Pagination pagination, string BidCode, string WorkPoint, string InfoID, string BDID)
  221. {
  222. DataTable ListData = App.BidCourseHistoryInfo(BidCode, WorkPoint, InfoID, BDID,ref pagination);
  223. var JsonData = new
  224. {
  225. total = pagination.total,
  226. page = pagination.page,
  227. records = pagination.records,
  228. rows = ListData,
  229. };
  230. return Content(JsonData.ToJson());
  231. }
  232. [HttpPost]
  233. public void ExportAll(string BidCode, string BeginDate, string EndDate, string selShow)
  234. {
  235. DataTable dt = App.ExportAll(BidCode, BeginDate, EndDate, selShow);
  236. AsposeCell.Export(dt);
  237. }
  238. }
  239. }