<%@ WebHandler Language="C#" Class="Kernel" %> using System; using System.Collections.Generic; using System.Web; using System.Data; using System.Data.Common; using System.Web.SessionState; using System.Text; using eMIS; public class Kernel : IHttpHandler , IRequiresSessionState { public void ProcessRequest (HttpContext context) { string flowId; string nodeId; string desc; string userId; string html; string programId; DataManager dm = new DataManager(); StringBuilder sb = new StringBuilder(); string t = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); flowId = context.Request.QueryString["fid"].ToString(); nodeId = context.Request.QueryString["nid"].ToString(); userId = context.Session["userid"].ToString(); string sql = "select COUNT(*), lcid, jdid,cdid,lx from XT_LCRW where jsrid = '" + userId + "' and lcid='" + flowId + "' and jdid='" + nodeId + "' and lx='加签' GROUP BY lcid, jdid,cdid,lx"; DbDataReader reader = dm.ExecuteReader(sql); string lx; bool b = false; string s,s2; while (reader.Read()) { b = true; s2 = "&cond=" + DataManager.Encrypt("ID=" + reader[2].ToString()); sb.Append("

"); sb.Append(""); sb.Append(GetFlowName(dm, reader["LCID"].ToString()) + "-" + GetNodeName(dm, reader["lcid"].ToString(), reader["jdid"].ToString()) + s); sb.Append(" (" + reader[0].ToString() + ")

"); } reader.Close(); if (b) { sb.Append("

"); sb.Append(""); sb.Append(""); desc = GetFlowName(dm, flowId) + "-" + GetNodeName(dm, flowId, nodeId); reader = dm.ExecuteReader("select a.jlid,b.xingming as fsr,a.jssj from XT_LCRW a,com_yhb b where a.fsrid=b.id and a.lcid='" + flowId + "' and a.jdid='" + nodeId + "' and a.jsrid = '" + userId + "' and a.lx='加签'"); int i = 0; while (reader.Read()) { sb.Append(""); sb.Append(""); sb.Append(""); i++; } reader.Close(); sb.Append(""); sb.Append("

发送人	发送时间	备注	操作
" + reader[1].ToString() + "	" + reader[2].ToString() + "		加签

"); } context.Response.Write(sb.ToString()); } private string GetName( DataManager dm,string userId) { string r = ""; DbDataReader reader = dm.ExecuteReader("select xingming from com_yhb where id=" + userId); if(reader.Read()) { r = reader[0].ToString(); } reader.Close(); return r; } private string GetFlowName( DataManager dm,string FlowID) { string ret = ""; DbDataReader reader = dm.ExecuteReader("select LCMC from COM_LCDYB where LCID=" + FlowID); if (reader.Read()) { ret = reader[0].ToString(); } reader.Close(); return ret; } private string GetNodeName( DataManager dm,string FlowID, string NodeID) { string ret = ""; DbDataReader reader = dm.ExecuteReader("select JDMC from COM_LCJDB where LCID=" + FlowID + " and JDID=" + NodeID); if (reader.Read()) { ret = reader[0].ToString(); } reader.Close(); return ret; } public bool IsReusable { get { return false; } } }