public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; NoticeInfoManager manager = new NoticeInfoManager(); int pageNum = int.Parse(context.Request.QueryString.Get("pagenum")); int pagesize = int.Parse(context.Request.QueryString.Get("pagesize")); int recordCount = 0; WhereClip where = null; DataTable dt = manager.GetDataTable(pageNum + 1, pagesize, where, " CODE ", ref pagesize, ref recordCount); //manager.GetDataTable(); string result = JsonConvert.Convert2Json(dt); context.Response.Write("{\"total\":\"" + recordCount.ToString() + "\",\"rows\":" + result + "}"); context.Response.End(); }
protected void Page_Load(object sender, EventArgs e) { string tmpl = @" <tr> <td height='25' align='left' valign='middle' > <img src='css/images/biao.gif' /> <a href='{0}' target='_blank' title='标题:中央下达的重要文件请各小组查看'>{1}</a> <font class='red'>★</font> </td> </tr>"; string wrtmpl = @" <tr> <td width='65' height='28' align='center' valign='middle' > <div class='book_kk' style='width:55px;'>√{0}</div> </td> <td align='left' valign='middle' > {1}: <a href='indexworkinfo.aspx?id={6}' target='_blank'> {2} </a> </td> <td width='100' align='center' valign='middle' >{3}</td> <td width='140' align='center' valign='middle' >{4}</td> <td width='120' align='left' valign='middle' >{5}</td> </tr>"; string sbtmpl = @" <tr> <td height='30' align='center' bgcolor='#FFFFFF' class='zx'>{0}</td> <td align='center' bgcolor='#FFFFFF' class='zx'> <font class='book_kk'>{1}</font><!--故障设备置顶--></td> <td align='center' bgcolor='#FFFFFF' class='zx'>{2}</td> <td align='center' bgcolor='#FFFFFF' class='zx'>{3}</td> <td align='center' bgcolor='#FFFFFF' class='zx'>共<span class='title12b'>{4}</span>次故障</td> <td align='center' bgcolor='#FFFFFF' class='zx'>共<span class='title12b'>{5}</span>次更换</td> </tr>"; if (!IsPostBack) { #region 格式化新闻 NoticeInfoManager ntMgr = new NoticeInfoManager(); string result = "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0'>"; int count = 0; DataTable dt = ntMgr.GetDataTable(1, 5, "ISTOP", ref count, ref count); foreach (DataRow row in dt.Rows) { result += string.Format(tmpl, "newsinfo.aspx?id=" + row["ID"].ToString(), row["TITLE"]); } result += "</table>"; news_wrap.InnerHtml = result; #endregion // #region 格式化派工http://www.ycfarm.com/sbbx/images/top_b.gif // string worinfohtml = "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0'> "; // WorkInfoManager wkMgr = new WorkInfoManager(); // WhereClip where = null;// WorkInfo._.Status != "完成"; // if ( Session["AllDepart"] != null) // { // List<AdministrativeRegions> list = Session["AllDepart"] as List<AdministrativeRegions>; // if (list != null && list.Count > 0) // { // string[] dparr = new string[list.Count]; // for (int j = 0; j < list.Count; j++) // { // dparr[j] = list[j].ID.ToString(); // } // if (WhereClip.IsNullOrEmpty(where)) // { // where = ShebeiInfo._.SocrceDepart.In(dparr); // } // else // { // where = where && ShebeiInfo._.SocrceDepart.In(dparr); // } // } // } // OrderByClip order = WorkInfo._.CreateDate.Desc; // DataTable dtwk = wkMgr.GetDataTable(1, 4, where, order, ref count, ref count); // // DataTable dtwk = wkMgr.GetDataTable(); //int i = 0; // foreach (DataRow row in dtwk.Rows) // { // i++; // if (i > 4) break; // string gzxx = row["GuZhangXx"].ToString(); // if (gzxx.Length > 10) // { // gzxx = gzxx.Substring(0, 10); // } // string clyj = row["ChuLiYijian"].ToString(); // if (clyj.Length > 10) // { // clyj = clyj.Substring(0, 10); // } // worinfohtml += string.Format(wrtmpl, row["Status"].ToString(), row["CreaterName"].ToString(), gzxx, row["CurrentUser"].ToString(), clyj, ((DateTime)row["CreateDate"]).ToString("yyyy-MM-dd"), row["ID"]); // } // worinfohtml += "</table>"; // workinfo.InnerHtml = worinfohtml; // #endregion // string sresult = // @"<table width='100%' border='0' cellpadding='0' cellspacing='0' class='dx'> // <tbody><tr> // <td width='12%' height='25' align='center' bgcolor='#F8F8F8' class='zx'>编号</td> // <td width='14%' align='center' bgcolor='#F8F8F8' class='zx'>设备状态</td> // <td width='22%' align='center' bgcolor='#F8F8F8' class='zx'>设备名称</td> // <td width='16%' align='center' bgcolor='#F8F8F8' class='zx'>缩略图</td> // <td width='18%' align='center' bgcolor='#F8F8F8' class='zx'>故障统计</td> // <td width='18%' align='center' bgcolor='#F8F8F8' class='zx'>更换统计</td> // </tr>"; // ShebeiInfoManager sbMgr = new ShebeiInfoManager(); // DataTable dt_sb = sbMgr.GetWaiBuDataTable(); // int scount = 0; // foreach (DataRow row in dt_sb.Rows) // { // scount++; // if (scount > 10) break; // string img_html = string.Empty; // //OAManager.FileInfoManager flMgr = new FileInfoManager(); // //DataTable dtimg = flMgr.GetDataTable(row["ID"].ToString()); // //string img_html = string.Empty; // //if (dtimg.Rows.Count > 0) // //{ // // string src = dtimg.Rows[0]["FILEPATH"].ToString(); // // img_html = "<a href='" + src + "'><img src='" + src + "' width='50' height='40' alt='图标'></a>"; // //} // //else // //{ // // img_html = "无缩略图"; // //} // sresult += string.Format(sbtmpl, row["Code"].ToString(), row["State"].ToString(), "<a href='" + row["PATH"].ToString() + "' target='sbiframe'>" + row["Name"].ToString() + "</a>", img_html, row["GZTJ"].ToString(), row["GHTJ"].ToString()); // } // sresult += "</tbody></table>"; // //sbinfo.InnerHtml = sresult; // dt_sb = sbMgr.GetNeiBuDataTable(); // sresult = // @"<table width='100%' border='0' cellpadding='0' cellspacing='0' class='dx'> // <tbody><tr> // <td width='12%' height='25' align='center' bgcolor='#F8F8F8' class='zx'>编号</td> // <td width='14%' align='center' bgcolor='#F8F8F8' class='zx'>设备状态</td> // <td width='22%' align='center' bgcolor='#F8F8F8' class='zx'>设备名称</td> // <td width='16%' align='center' bgcolor='#F8F8F8' class='zx'>缩略图</td> // <td width='18%' align='center' bgcolor='#F8F8F8' class='zx'>故障统计</td> // <td width='18%' align='center' bgcolor='#F8F8F8' class='zx'>更换统计</td> // </tr>"; // scount = 0; // foreach (DataRow row in dt_sb.Rows) // { // scount++; // if (scount > 10) break; // string img_html = string.Empty; // //OAManager.FileInfoManager flMgr = new FileInfoManager(); // //DataTable dtimg = flMgr.GetDataTable(row["ID"].ToString()); // //string img_html = string.Empty; // //if (dtimg.Rows.Count > 0) // //{ // // string src = dtimg.Rows[0]["FILEPATH"].ToString(); // // img_html = "<a href='" + src + "'><img src='" + src + "' width='50' height='40' alt='图标'></a>"; // //} // //else // //{ // // img_html = "无缩略图"; // //} // sresult += string.Format(sbtmpl, row["Code"].ToString(), row["State"].ToString(), "<a href='" + row["PATH"].ToString() + "' target='sbiframe'>" + row["Name"].ToString() + "</a>", img_html, row["GZTJ"].ToString(), row["GHTJ"].ToString()); // } // sresult += "</tbody></table>"; // //sbnbinfo.InnerHtml = sresult; } }