PageRenderTime 50ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

/IntelWebSite/wfDeviceData.aspx.cs

https://github.com/sirivedula/IntelWebPro
C# | 79 lines | 72 code | 7 blank | 0 comment | 2 complexity | c873bc39d773d8a57c137ba41b0610bc MD5 | raw file
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Text;
  8. using IntelWeb;
  9. using System.Data;
  10. using System.Data.OleDb;
  11. namespace IntelWebSite
  12. {
  13. public partial class wfDeviceData : System.Web.UI.Page
  14. {
  15. protected void Page_Load(object sender, EventArgs e)
  16. {
  17. }
  18. protected void Page_LoadComplete(object sender, EventArgs e)
  19. {
  20. CurrentUser cuser = new CurrentUser();
  21. cuser.userName = "Balaji";
  22. cuser.Load();
  23. string tiercode = Request.QueryString["tiercode"];
  24. string deptcode = Request.QueryString["deptcode"];
  25. string sitecode = Request.QueryString["sitecode"];
  26. string panelcode = Request.QueryString["panelcode"];
  27. string devicecode = Request.QueryString["devicecode"];
  28. string fromdate = Request.QueryString["fdate"];
  29. string todate = Request.QueryString["tdate"];
  30. tbl_alarm_time_details alarmDet = new tbl_alarm_time_details(cuser);
  31. IntelWebField tierFld = alarmDet.Field("tier_code");
  32. tierFld.fieldValue = tiercode;
  33. IntelWebField deptFld = alarmDet.Field("department_code");
  34. deptFld.fieldValue = deptcode;
  35. IntelWebField siteFld = alarmDet.Field("site_code");
  36. siteFld.fieldValue = sitecode;
  37. IntelWebField panelFld = alarmDet.Field("panel_code");
  38. panelFld.fieldValue = panelcode;
  39. IntelWebField deviceFld = alarmDet.Field("alarm_device_code");
  40. deviceFld.fieldValue = devicecode;
  41. IntelWebField fdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, fromdate);
  42. IntelWebField tdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, todate);
  43. List<IntelWebField> bparam = new List<IntelWebField>();
  44. bparam.Add(tierFld);
  45. bparam.Add(deptFld);
  46. bparam.Add(siteFld);
  47. bparam.Add(panelFld);
  48. bparam.Add(deviceFld);
  49. bparam.Add(fdateFld);
  50. bparam.Add(tdateFld);
  51. List<IntelWebObject> alarmDets = alarmDet.Load("tier_code=? and department_code=? and site_code=? and panel_code=? and alarm_device_code=? and alarm_date between ? and ?", "alarm_date,alarm_time", bparam);
  52. if (alarmDets.Count > 0)
  53. {
  54. StringBuilder sb = new StringBuilder();
  55. sb.Append("<table style=\"width:100%;\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" class=\"webgrid\"><thead class=\"titlegrid\"><tr><th>Device</th><th>Alarm Date</th><th>Alarm Hour</th><th>Alaram Time</th><th>Alarm Details</th><th>Alarm Comment</th></tr>");
  56. int rowCnt = 0;
  57. foreach (tbl_alarm_time_details alarm in alarmDets)
  58. {
  59. string trclass = (rowCnt % 2 == 0 ? "" : " class=\"gridodd\" ");
  60. sb.Append("<tr" + trclass + "><td>" + HttpUtility.HtmlEncode(alarm.alarm_device_code) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_date.ToString("MM/dd/yyyy")) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_hour) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_time) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_details) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_comment) + "</td></tr>");
  61. rowCnt++;
  62. }
  63. sb.Append("</table>");
  64. Response.Write(sb.ToString());
  65. }
  66. else
  67. {
  68. Response.Write("There are no details found.");
  69. }
  70. }
  71. }
  72. }