Guest User

Untitled

a guest
Jan 18th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.14 KB | None | 0 0
  1. function printPreview(reqID) {
  2. var obj = {
  3. id: reqID
  4. }
  5. $.ajax({
  6. type: "POST",
  7. url: "/api/default/PrintFormReq/",
  8. data: JSON.stringify(obj),
  9. contentType: "application/json; charset=utf-8",
  10. dataType: "json",
  11. success: function (response) {
  12. var sampleArr = base64ToArrayBuffer(response);
  13.  
  14. },
  15. error: function (response) {
  16. alert(response.d);
  17. }
  18. });
  19. }
  20.  
  21. [EnableCors(origins: "*", headers: "*", methods: "*")]
  22. [HttpPost]
  23. public byte[] PrintFormReq(mdReqMaster _mdReqMaster)
  24. {
  25. string id = _mdReqMaster.id;
  26. //SQL
  27. mFunc _mFunc = new mFunc();
  28. mainDB _mainDB = new mainDB();
  29. ReportDocument report = new ReportDocument();
  30.  
  31. CookieHeaderValue cookie = Request.Headers.GetCookies("uinfo").FirstOrDefault();
  32. JObject json = JObject.Parse(cookie["uinfo"].Value);
  33.  
  34. _mdReqMaster.id = id;
  35.  
  36. string query = string.Format(@"select tmp.*
  37. , requestStatus.modify_date as fixed_date
  38. , requestStatus.modify_time as fixed_time
  39. , datediff(day, CONVERT(datetime, (tmp.req_date+' '+tmp.req_time)), CONVERT(datetime, (requestStatus.modify_date+' '+requestStatus.modify_time))) as duration_d
  40. , datediff(hour, CONVERT(datetime, (tmp.req_date+' '+tmp.req_time)), CONVERT(datetime, (requestStatus.modify_date+' '+requestStatus.modify_time))) as duration_h
  41.  
  42. from
  43. (
  44. select requestMaster.*, '' as base_status_id, '' as base_status
  45. --, datediff(day, CONVERT(datetime, (requestMaster.req_date+' '+requestMaster.req_time)), GETDATE()) as duration_d
  46. --, datediff(hour, CONVERT(datetime, (requestMaster.req_date+' '+requestMaster.req_time)), GETDATE()) as duration_h
  47. , (select top 1 requestStatus.base_req_status_id from requestStatus where requestStatus.req_master_id = requestMaster.id order by requestStatus.id desc) as current_status
  48. from requestMaster
  49. where requestMaster.id = {0}
  50. ) as tmp
  51. inner join requestStatus on requestStatus.base_req_status_id = '3' and requestStatus.req_master_id = tmp.id", id);
  52.  
  53.  
  54. DataTable dtMaster = new DataTable();
  55. dtMaster.TableName = "master";
  56. dtMaster = _mainDB.DTResult(query);
  57.  
  58. if (dtMaster.Rows.Count > 0)
  59. {
  60. reqMaster dsMaster = new reqMaster();
  61. mdBaseStatus _mdBaseStatus = new mdBaseStatus();
  62. _mdBaseStatus = _mFunc.getCurrentStatusByID(_mdReqMaster.id);
  63.  
  64. dtMaster.Rows[0]["base_status_id"] = _mdBaseStatus.base_status_id;
  65. dtMaster.Rows[0]["base_status"] = _mdBaseStatus.base_status;
  66.  
  67. //Master
  68. dsMaster.Tables["master"].ImportRow(dtMaster.Rows[0]);
  69. //Items
  70. DataTable dtItems = getItems(_mdReqMaster.id);
  71. if(dtItems.Rows.Count > 0){
  72. foreach(DataRow dr in dtItems.Rows){
  73. dsMaster.Tables["items"].ImportRow(dr);
  74. }
  75. }
  76. //TeamTech
  77. DataTable dtTechnicians = getTechnicians(_mdReqMaster.id);
  78.  
  79. //Solution
  80. DataTable dtSolution = getSolution(_mdReqMaster.id);
  81.  
  82. //Evaluate
  83. DataTable dtEvaluate = getEvaluate(_mdReqMaster.id);
  84.  
  85.  
  86. if (json["Sites_Code"].ToString() == "1067")
  87. {
  88. report.Load(Path.Combine(HostingEnvironment.MapPath("~/Reports/SIH/"), "reqSummarySIH.rpt"));
  89. }
  90. else if (json["Sites_Code"].ToString() == "1019")
  91. {
  92. report.Load(Path.Combine(HostingEnvironment.MapPath("~/Reports/BSH/"), "reqSummaryBSH.rpt"));
  93. }
  94.  
  95.  
  96.  
  97. DataSet ds2 = new DataSet();
  98. ds2.Tables.Add(dtItems);
  99.  
  100. report.Subreports["rpt_items"].SetDataSource(dtItems);
  101. report.Subreports["rpt_solutions"].SetDataSource(dtSolution);
  102. report.Subreports["rpt_evaluate"].SetDataSource(dtEvaluate);
  103.  
  104.  
  105. //report.SetDataSource(dsMaster);
  106.  
  107. report.Database.Tables[0].SetDataSource(dsMaster);
  108. }
  109.  
  110. Stream stream = report.ExportToStream(ExportFormatType.PortableDocFormat);
  111. MemoryStream streamReader = new MemoryStream();
  112. stream.CopyTo(streamReader);
  113.  
  114. return streamReader.ToArray();
  115. }
  116.  
  117. <system.web>
  118. <compilation debug="true" targetFramework="4.5">
  119. <assemblies>
  120. <!--<add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>-->
  121. </assemblies>
  122. </compilation>
  123. <httpRuntime maxRequestLength="2097152" targetFramework="4.5"/>
  124. </system.web>
  125.  
  126.  
  127.  
  128. <system.webServer>
  129. <modules runAllManagedModulesForAllRequests="true"/>
  130. <handlers>
  131. <remove name="UrlRoutingHandler"/>
  132. </handlers>
  133. <!--<handlers>
  134. <remove name="ExtensionlessUrlHandler-Integrated-4.0" />
  135. <remove name="OPTIONSVerbHandler" />
  136. <remove name="TRACEVerbHandler" />
  137. <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
  138. </handlers>-->
  139. <security>
  140. <requestFiltering>
  141. <requestLimits maxAllowedContentLength="2147483648" />
  142. </requestFiltering>
  143. </security>
  144. </system.webServer>
Add Comment
Please, Sign In to add comment