/// <summary> /// 查询的方法 /// </summary> private void Query(string bmid) { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = GetWhere(); if (bmid == "1" || string.IsNullOrEmpty(bmid)) { bmid = "1"; } //使用存储过程及临时表实现递归方式列表 SqlParameter[] parms = { new SqlParameter("@id", bmid) }; SqlHelper.ExeNonQuery("get_bmzl2", CommandType.StoredProcedure, parms); DataSet duser = SqlHelper.GetList("v_ygzl", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_ygzl where " + strWhere + " order by cygbh asc"); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count); //str = JSonHelper.SerializeObject(dt1); //str ="{ " + "\"total\":" + dt.Rows.Count + "," + "\"rows\":" + str + "}"; HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from dwb"); if (dt.Rows.Count > 0) { DataRow[] CRow = dt.Select("1=1"); if (CRow.Length > 0) { sb.Append("["); for (int i = 0; i < CRow.Length; i++) { sb.Append("{\"id\":\"" + CRow[i]["id"].ToString() + "\",\"text\":\"" + CRow[i]["cdw"].ToString() + "\"},"); } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); sb = sb.Remove(sb.Length - 2, 2); } context.Response.Write(sb.ToString()); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string sbid = context.Request["sbid"]; //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = ""; if (string.IsNullOrEmpty(sbid)) { strWhere = " 1=1"; } else { strWhere = " isbid=" + sbid; } DataSet duser = SqlHelper.GetList("v_sbzl_dj", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_sbzl_dj where " + strWhere); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count); HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void search() { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = ""; string rq1 = HttpContext.Current.Request["rq1"]; string rq2 = HttpContext.Current.Request["rq2"]; string proline = HttpContext.Current.Request["proline"]; string txt = HttpContext.Current.Request["txt"]; strWhere = " drq>='" + rq1 + "' and drq<='" + rq2 + "' and csxnr like '%" + txt + "%'"; if (proline != "") { strWhere = strWhere + " and cscx='" + proline + "'"; } DataSet duser = SqlHelper.GetList("v_zxdbsx", "*", "id", int.Parse(rows), int.Parse(page), false, true, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_zxdbsx where " + strWhere); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count); HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 选择站板名称 /// </summary> private void Select() { try { string bid = HttpContext.Current.Request["data"]; DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from v_zbsz where bid=" + bid); if (dt.Rows.Count > 0) { string cData = dt.Rows[0]["czdz"] + "&" + dt.Rows[0]["czmc"] + "*" + dt.Rows[0]["cbdz"] + "," + dt.Rows[0]["cbmc"]; HttpContext.Current.Response.Write(cData); } else { HttpContext.Current.Response.Write("null"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string sbbh = context.Request["data"]; string value = ""; if (!string.IsNullOrEmpty(sbbh)) { DataTable dt = SqlHelper.GetTable("select * from v_sbzl where csbbh='" + sbbh + "'"); if (dt.Rows.Count > 0) { value = dt.Rows[0]["csbmc"].ToString() + "&" + dt.Rows[0]["cscx"].ToString() + "," + dt.Rows[0]["csszy"].ToString(); } } context.Response.Write(value); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//删除的方法 private void Del() { try { //获取到选中行的id string id = HttpContext.Current.Request["id"]; int count = 0; count = SqlHelper.DelData("dbsxb", id); if (count > 0) { HttpContext.Current.Response.Write("共删除了" + count + "条数据"); } else { HttpContext.Current.Response.Write("error"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void stop() { try { DataTable dt = SqlHelper.GetTable("select * from scszb"); if (dt.Rows.Count > 0) { RunBat(dt.Rows[0]["clj"].ToString() + "\\stop.bat"); HttpContext.Current.Response.Write("停止服务成功!"); } else { HttpContext.Current.Response.Write("停止服务失败!"); } dt = null; } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//初始化 private void query() { try { DataTable dt = SqlHelper.GetTable("select * from wxgzh"); string appid = ""; string appsecret = ""; if (dt.Rows.Count > 0) { appid = dt.Rows[0]["appid"].ToString(); appsecret = dt.Rows[0]["appsecret"].ToString(); } dt = null; HttpContext.Current.Response.Write(appid + "&" + appsecret); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; try { StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); string zid = context.Request ["zid"]; dt = SqlHelper.GetTable("select * from bszb where izid=" + zid + " order by cbdz"); if (dt.Rows.Count > 0) { DataRow[] CRow = dt.Select("1=1"); if (CRow.Length > 0) { sb.Append("["); for (int j = 0; j < CRow.Length; j++) { sb.Append("{\"id\":\"" + CRow[j]["id"].ToString() + "\",\"text\":\"" + CRow[j]["cbdz"].ToString() + "~~" + CRow[j]["cbmc"].ToString() + "\",\"state\":\"open\"},"); } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]"); } context.Response.Write(sb.ToString()); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 载入数据 /// </summary> private void Load_Wx(string strId) { try { if (string.IsNullOrEmpty(strId)) { return; } DataTable dt = SqlHelper.GetTable("select * from v_wxjl where id=" + strId); if (dt.Rows.Count > 0) { string str = ""; str = dt.Rows[0]["cgdh"].ToString(); str = str + "&" + dt.Rows[0]["drq"].ToString(); str = str + "&" + dt.Rows[0]["csbbh"].ToString(); str = str + "&" + dt.Rows[0]["csbmc"].ToString(); str = str + "&" + dt.Rows[0]["cscx"].ToString(); str = str + "&" + dt.Rows[0]["czy"].ToString(); str = str + "&" + dt.Rows[0]["dgzsj"].ToString(); str = str + "&" + dt.Rows[0]["cgzlx"].ToString(); str = str + "&" + dt.Rows[0]["cgzxx"].ToString(); str = str + "&" + dt.Rows[0]["cclfs"].ToString(); str = str + "&" + dt.Rows[0]["cwxr"].ToString(); str = str + "&" + dt.Rows[0]["cwxnr"].ToString(); str = str + "&" + dt.Rows[0]["dwxkssj"].ToString(); str = str + "&" + dt.Rows[0]["dwcsj"].ToString(); str = str + "&" + dt.Rows[0]["cbz"].ToString(); HttpContext.Current.Response.Write(str); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
// 调用方法 // List<Person> appResult = JSONToObject<List<Person>>(@"[{""id"":0,""email"":""*****@*****.**"",""age"":0},{""id"":1,""email"":""*****@*****.**"",""age"":2},{""id"":2,""email"":""*****@*****.**"",""age"":4},{""id"":3,""email"":""*****@*****.**"",""age"":6},{""id"":4,""email"":""*****@*****.**"",""age"":8}]"); // for(int i = 0;i<appResult.Count;i++) // 输出(appResult[i].id); ////定义 // public class Person // { // public int id { set; get; } // public String email { set; get; } // public int age { set; get; } // } // public static T JSONToObject<T>(string jsonText) // { // System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer(); // try // { // return jss.Deserialize<T>(jsonText); // } // catch (Exception ex) // { // throw new Exception("JSONHelper.JSONToObject(): " + ex.Message); // } // } /// <summary> /// 获取企业号的accessToken /// </summary> /// <param name="corpid">企业号ID</param> /// <param name="corpsecret">管理组密钥</param> /// <returns></returns> public string GetQYAccessToken(string corpid, string corpsecret) { string accessToken = ""; string getAccessTokenUrl = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid={0}&secret={1}"; string respText = ""; //获取josn数据 string url = string.Format(getAccessTokenUrl, corpid, corpsecret); HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); HttpWebResponse response = (HttpWebResponse)request.GetResponse(); using (Stream resStream = response.GetResponseStream()) { StreamReader reader = new StreamReader(resStream, Encoding.Default); respText = reader.ReadToEnd(); resStream.Close(); } try { JavaScriptSerializer Jss = new JavaScriptSerializer(); Dictionary <string, object> respDic = (Dictionary <string, object>)Jss.DeserializeObject(respText); //通过键access_token获取值 accessToken = respDic["access_token"].ToString(); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } return(accessToken); }
/// <summary> /// 载入数据 /// </summary> private void Load_Tj(string strId) { try { if (string.IsNullOrEmpty(strId)) { return; } DataTable dt = SqlHelper.GetTable("select * from v_tjjl where id=" + strId); if (dt.Rows.Count > 0) { string str = ""; str = dt.Rows[0]["cdh"].ToString(); str = str + "&" + dt.Rows[0]["dtxrq"].ToString(); str = str + "&" + dt.Rows[0]["csbbh"].ToString(); str = str + "&" + dt.Rows[0]["csbmc"].ToString(); str = str + "&" + dt.Rows[0]["cscx"].ToString(); str = str + "&" + dt.Rows[0]["csszy"].ToString(); str = str + "&" + dt.Rows[0]["dkjrq"].ToString(); str = str + "&" + dt.Rows[0]["dtjrq"].ToString(); str = str + "&" + dt.Rows[0]["ctjzl"].ToString(); str = str + "&" + dt.Rows[0]["cxxms"].ToString(); str = str + "&" + dt.Rows[0]["cjjfa"].ToString(); str = str + "&" + dt.Rows[0]["cyyfx"].ToString(); str = str + "&" + dt.Rows[0]["cgsdc"].ToString(); str = str + "&" + dt.Rows[0]["ctjr"].ToString(); str = str + "&" + dt.Rows[0]["cbz"].ToString(); HttpContext.Current.Response.Write(str); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from gzxxb order by pid"); if (dt.Rows.Count > 0) { sb.Append(GetDataString(dt, "0")); sb = sb.Remove(sb.Length - 2, 2); } context.Response.Write(sb.ToString()); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 查询的方法 /// </summary> private void Query(string ygid) { try { string userid = HttpContext.Current.Request.Form["userid"]; DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select depid from DataAuthority where userid='" + userid + "'"); string depid = ""; if (dt.Rows.Count > 0) { depid = dt.Rows[0][0].ToString(); } //string str = string.Empty; ////将数据转换成json格式 //str = JSonHelper.CreateJsonParameters(dt, true, dt.Rows.Count); HttpContext.Current.Response.Write(depid); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//删除的方法 private void Del() { try { //获取到选中行的id string id = HttpContext.Current.Request["id"]; string sSql = ""; DataTable dt = new DataTable(); //判断处理方式中是否存在 sSql = "select * from wxjlb where iclfs=" + id; dt = SqlHelper.GetTable(sSql); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("1"); return; } int count = 0; count = SqlHelper.DelData("clfsb", id); if (count > 0) { HttpContext.Current.Response.Write("共删除了" + count + "条数据"); } else { HttpContext.Current.Response.Write("error"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; try { StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from zszb order by czdz"); if (dt.Rows.Count > 0) { DataRow[] CRow = dt.Select("1=1"); if (CRow.Length > 0) { sb.Append("[{\"id\":\"\",\"text\":\"站信息\",\"children\":["); for (int i = 0; i < CRow.Length; i++) { sb.Append("{\"id\":\"" + CRow[i]["id"].ToString() + "\",\"text\":\"" + CRow[i]["czdz"].ToString() + "~~" + CRow[i]["czmc"].ToString() + "\",\"state\":\"closed\"},"); } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]}]"); } context.Response.Write(sb.ToString()); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void Backup() { try { //根据连接字符串获取数据库名称 string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; string db = strConn.Split(';')[1]; string dbname = db.Split('=')[1]; string bkpath = HttpContext.Current.Request["data"]; //使用单个符号“\”提示常量中有换行符 //自动创建文件夹 FileInfo fi = new FileInfo(bkpath); var di = fi.Directory; if (!di.Exists) { di.Create(); } SqlConnection con = new SqlConnection(SqlHelper.conString); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "exec p_backupdb '" + dbname + "','" + bkpath + "'"; cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); HttpContext.Current.Response.Write("数据备份成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//初始化 private void query() { try { DataTable dt = SqlHelper.GetTable("select * from scszb"); string cscsjjg = ""; string cscqssj = ""; string cscjssj = ""; if (dt.Rows.Count > 0) { cscsjjg = dt.Rows[0]["cscsjjg"].ToString(); cscqssj = dt.Rows[0]["cscqssj"].ToString(); cscjssj = dt.Rows[0]["cscjssj"].ToString(); } dt = null; HttpContext.Current.Response.Write(cscsjjg + "&" + cscqssj + "," + cscjssj); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); int id = int.Parse(str[0].Split('=')[1]); string csbbh = str[1].Split('=')[1]; if (string.IsNullOrEmpty(csbbh) || csbbh == "") { HttpContext.Current.Response.Write("1"); return; } DataTable dt = SqlHelper.GetTable("select * from sbzlb where deviceid='" + csbbh + "' and id<>" + id); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("2"); return; } string rq = ""; sys ex = new sys(); if (ex.isDate(str[5].Split('=')[1]) == true) { rq = str[5].Split('=')[1]; } string csxlx = str[6].Split('=')[1]; string cczy = str[9].Split('=')[1]; string csxnr = str[10].Split('=')[1]; string cclfs = str[11].Split('=')[1]; string cdbr = str[7].Split('=')[1]; string czt = str[8].Split('=')[1]; SqlParameter[] parms = { new SqlParameter("@rq", rq), new SqlParameter("@sbbh", csbbh), new SqlParameter("@sxlx", csxlx), new SqlParameter("@sxnr", csxnr), new SqlParameter("@clfs", cclfs), new SqlParameter("@dbr", cdbr), new SqlParameter("@czy", cczy), new SqlParameter("@zt", czt), new SqlParameter("@id", id) }; bool flag = SqlHelper.ExeNonQuery("update_dbsx", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("修改成功!"); } else { HttpContext.Current.Response.Write("修改失败!"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 高级查询 /// </summary> /// <returns></returns> public void Search() { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string value = HttpContext.Current.Request["data"]; string[] strr = value.Split('&'); string s_where = "1=1"; string s_csbbh = strr[0].Split('=')[1]; if (s_csbbh.Trim().Length > 0) { s_where = s_where + " and csbbh like '%" + s_csbbh + "%'"; } string s_csbmc = strr[1].Split('=')[1]; if (s_csbmc.Trim().Length > 0) { s_where = s_where + " and csbmc like '%" + s_csbmc + "%'"; } string s_csszy = strr[2].Split('=')[1]; if (s_csszy.Trim().Length > 0) { s_where = s_where + " and izyid='" + s_csszy + "'"; } string s_cscx = strr[3].Split('=')[1]; if (s_cscx.Trim().Length > 0) { s_where = s_where + " and iscxid = '" + s_cscx + "'"; } string s_cjllx = strr[4].Split('=')[1]; if (s_cjllx.Trim().Length > 0) { s_where = s_where + " and typename like '%" + s_cjllx + "%'"; } string s_cdjr = strr[5].Split('=')[1]; if (s_cdjr.Trim().Length > 0) { s_where = s_where + " and cdjr like '%" + s_cdjr + "%'"; } sys ex = new sys(); string s_dtp1 = strr[6].Split('=')[1]; if (ex.isDate(s_dtp1) == true) { s_dtp1 = s_dtp1.Replace("+", " "); //替换+为空,日期提交后格式为:2016-05-30+10:00:00 if (s_dtp1.Trim().Length > 0) { s_where = s_where + " and drq>= '" + s_dtp1 + "'"; } } string s_dtp2 = strr[7].Split('=')[1]; if (ex.isDate(s_dtp2) == true) { s_dtp2 = s_dtp2.Replace("+", " "); if (s_dtp2.Trim().Length > 0) { s_where = s_where + " and drq<= '" + s_dtp2 + "'"; } } DataSet duser = SqlHelper.GetList("v_djjl", "*", "id", int.Parse(rows), int.Parse(page), false, true, s_where); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_djjl where " + s_where + " order by drq desc"); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count); HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); int id = int.Parse(str[0].Split('=')[1]); sys ex = new sys(); string drq = ""; if (ex.isDate(str[1].Split('=')[1]) == true) { drq = str[1].Split('=')[1]; } string dx = str[2].Split('=')[1]; string cdxmc = ""; if (str[3].Split('=')[1].Trim().Length > 0) { cdxmc = str[3].Split('=')[1]; } if (str[4].Split('=')[1].Trim().Length > 0) { cdxmc = str[4].Split('=')[1]; } string cjl = str[5].Split('=')[1]; string cczy = str[6].Split('=')[1]; string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parm = { new SqlParameter("@rq", drq), new SqlParameter("@dx", dx), new SqlParameter("@dxmc", cdxmc), new SqlParameter("@jl", cjl), new SqlParameter("@czy", cczy), new SqlParameter("@id", id) }; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "update_gcstz"; foreach (SqlParameter p in parm) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); cmd.Dispose(); //临时工程师通知 string sql = "delete from tmp_gcstzb where id=" + id; cmd.CommandText = sql; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); //临时表 string[] strr = cdxmc.Split(','); int len = strr.Length; string value = ""; if (len > 0) { //员工分割 for (int i = 0; i < len; i++) { value = strr[i].Split('-')[0]; SqlParameter[] parms = { new SqlParameter("@id", id), new SqlParameter("@rq", drq), new SqlParameter("@dx", dx), new SqlParameter("@dxmc", value), new SqlParameter("@jl", cjl), new SqlParameter("@czy", cczy) }; SqlCommand cmds = new SqlCommand(); cmds.Connection = con; //获取数据连接 cmds.Transaction = sqltra; //,在执行SQL时 cmds.CommandType = CommandType.StoredProcedure; cmds.CommandText = "insert_tmp_gcstz"; foreach (SqlParameter p in parms) { cmds.Parameters.Add(p); } cmds.ExecuteNonQuery(); cmds.Dispose(); } } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("修改成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//添加 private void Add() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); sys ex = new sys(); string drq = ""; //查找id最大值 Int64 id = 0; DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select max(id) as maxid from gcstzb"); if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(dt.Rows[0]["maxid"].ToString())) { id = Int64.Parse(dt.Rows[0]["maxid"].ToString()) + 1; } else { id = 1; } } else { id = 1; } dt = null; if (ex.isDate(str[1].Split('=')[1]) == true) { drq = str[1].Split('=')[1]; } string dx = str[2].Split('=')[1]; string cdxmc = ""; if (str[3].Split('=')[1].Trim().Length > 0) { cdxmc = str[3].Split('=')[1]; } if (str[4].Split('=')[1].Trim().Length > 0) { cdxmc = str[4].Split('=')[1]; } string cjl = str[5].Split('=')[1]; string cczy = str[6].Split('=')[1]; string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parm = { new SqlParameter("@id", id), new SqlParameter("@rq", drq), new SqlParameter("@dx", dx), new SqlParameter("@dxmc", cdxmc), new SqlParameter("@jl", cjl), new SqlParameter("@czy", cczy) }; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "insert_gcstz"; foreach (SqlParameter p in parm) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); cmd.Dispose(); //临时表 string[] strr = cdxmc.Split(','); int len = strr.Length; string value = ""; if (len > 0) { //员工分割 for (int i = 0; i < len; i++) { value = strr[i].Split('-')[0]; SqlParameter[] parms = { new SqlParameter("@id", id), new SqlParameter("@rq", drq), new SqlParameter("@dx", dx), new SqlParameter("@dxmc", value), new SqlParameter("@jl", cjl), new SqlParameter("@czy", cczy) }; SqlCommand cmds = new SqlCommand(); cmds.Connection = con; //获取数据连接 cmds.Transaction = sqltra; //,在执行SQL时 cmds.CommandType = CommandType.StoredProcedure; cmds.CommandText = "insert_tmp_gcstz"; foreach (SqlParameter p in parms) { cmds.Parameters.Add(p); } cmds.ExecuteNonQuery(); cmds.Dispose(); } } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("添加成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 查询的方法 /// </summary> private void Query() { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string state = HttpContext.Current.Request["state"]; if (string.IsNullOrEmpty(state)) { HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]"); return; } string strWhere = "1=1"; string qsrq = HttpContext.Current.Request["qsrq"]; if (!string.IsNullOrEmpty(qsrq)) { strWhere = strWhere + " and drq>='" + qsrq + "'"; } string jzrq = HttpContext.Current.Request["jzrq"]; if (!string.IsNullOrEmpty(jzrq)) { strWhere = strWhere + " and drq<='" + jzrq + "'"; } string ckey = HttpContext.Current.Request["ckey"]; string ctext = HttpContext.Current.Request["cmemo"]; if (!string.IsNullOrEmpty(ckey)) { switch (ckey) { case "对象": strWhere = strWhere + " and cdx like '%" + ctext + "%'"; break; case "对象名称": strWhere = strWhere + " and cdxmc like '%" + ctext + "%'"; break; case "记录": strWhere = strWhere + " and cjl like '%" + ctext + "%'"; break; case "制单人": strWhere = strWhere + " and cczy like '%" + ctext + "%'"; break; } } DataSet duser = SqlHelper.GetList("v_gcstz", "*", "id", int.Parse(rows), int.Parse(page), false, true, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_gcstz where " + strWhere + " order by drq desc"); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count); HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); int id = int.Parse(str[0].Split('=')[1]); DataTable dt = new DataTable(); string csbbh = str[2].Split('=')[1]; //设备编号 if (string.IsNullOrEmpty(csbbh)) { HttpContext.Current.Response.Write("1"); return; } string isbid = ""; dt = SqlHelper.GetTable("select * from sbzlb where deviceid='" + csbbh + "' and id<>" + id); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("2"); return; } else { isbid = dt.Rows[0]["id"].ToString(); } string cnr = str[1].Split('=')[1]; //内容 if (cnr == "") { HttpContext.Current.Response.Write("3"); return; } SqlParameter[] parms = { new SqlParameter("@sbid", isbid), new SqlParameter("@nr", cnr), new SqlParameter("@id", id) }; bool flag = SqlHelper.ExeNonQuery("update_wdgl", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("修改成功!"); } else { HttpContext.Current.Response.Write("修改失败!"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); int id = int.Parse(str[0].Split('=')[1]); string cdh = str[1].Split('=')[1]; if (string.IsNullOrEmpty(cdh)) { HttpContext.Current.Response.Write("1"); return; } DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from xhqzb where cdh='" + cdh + "'"); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("2"); return; } string dsj = ""; sys ex = new sys(); if (ex.isDate(str[2].Split('=')[1]) == true) { dsj = str[2].Split('=')[1].Replace("+", " "); } string csbbh = str[3].Split('=')[1]; if (string.IsNullOrEmpty(csbbh)) { HttpContext.Current.Response.Write("3"); return; } string isbid = ""; dt = SqlHelper.GetTable("select * from sbzlb where deviceid='" + csbbh + "'"); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("4"); return; } else { isbid = dt.Rows[0]["id"].ToString(); } string csbmc = str[4].Split('=')[1]; if (string.IsNullOrEmpty(csbmc)) { HttpContext.Current.Response.Write("5"); return; } string cscx = str[5].Split('=')[1]; string iyz = str[6].Split('=')[1]; string iqzz = str[7].Split('=')[1]; string cyy = str[8].Split('=')[1]; string czt = str[9].Split('=')[1]; string czdr = str[10].Split('=')[1]; if (string.IsNullOrEmpty(czdr) || czdr.Trim() == "") { HttpContext.Current.Response.Write("9"); return; } string cczy = str[11].Split('=')[1]; string cfzry = str[12].Split('=')[1]; string cbz = str[13].Split('=')[1]; string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parms = { new SqlParameter("@dh", cdh), new SqlParameter("@sj", dsj), new SqlParameter("@sbid", isbid), new SqlParameter("@yz", iyz), new SqlParameter("@qzz", iqzz), new SqlParameter("@yy", cyy), new SqlParameter("@zt", czt), new SqlParameter("@zdr", czdr), new SqlParameter("@bz", cbz), new SqlParameter("@fzry", cfzry), new SqlParameter("@czy", cczy), new SqlParameter("@id", id) }; cmd.CommandText = "update_xhqz"; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); //履历表 SqlParameter[] parm_llb = { new SqlParameter("@xmid", id), new SqlParameter("@sbid", isbid), new SqlParameter("@zysj", dsj), new SqlParameter("@zyxm", "强制"), new SqlParameter("@zyry", czdr), new SqlParameter("@czy", cczy), new SqlParameter("@zynr", cyy) }; SqlCommand com = new SqlCommand(); com.Connection = con; //获取数据连接 com.Transaction = sqltra; //,在执行SQL时 com.CommandText = "update_llb"; com.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm_llb) { com.Parameters.Add(p); } com.ExecuteNonQuery(); sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("修改成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string sbid = context.Request["sbid"]; StringBuilder sb = new StringBuilder(""); if (!string.IsNullOrEmpty(sbid)) { DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from sbzlb s inner join sbzlb_djfs sd on s.id=sd.isbid " + " inner join CabinetRecordType c on sd.idjid=c.id where s.id=" + sbid); if (dt.Rows.Count > 0) { sb.Append("["); if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber1"].ToString())) { sb.Append("{\"id\":\"iNumber1\",\"text\":\"" + dt.Rows[0]["iNumber1"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber2"].ToString())) { sb.Append("{\"id\":\"iNumber2\",\"text\":\"" + dt.Rows[0]["iNumber2"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber3"].ToString())) { sb.Append("{\"id\":\"iNumber3\",\"text\":\"" + dt.Rows[0]["iNumber3"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber4"].ToString())) { sb.Append("{\"id\":\"iNumber4\",\"text\":\"" + dt.Rows[0]["iNumber4"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber5"].ToString())) { sb.Append("{\"id\":\"iNumber5\",\"text\":\"" + dt.Rows[0]["iNumber5"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber6"].ToString())) { sb.Append("{\"id\":\"iNumber6\",\"text\":\"" + dt.Rows[0]["iNumber6"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber7"].ToString())) { sb.Append("{\"id\":\"iNumber7\",\"text\":\"" + dt.Rows[0]["iNumber7"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber8"].ToString())) { sb.Append("{\"id\":\"iNumber8\",\"text\":\"" + dt.Rows[0]["iNumber8"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber9"].ToString())) { sb.Append("{\"id\":\"iNumber9\",\"text\":\"" + dt.Rows[0]["iNumber9"].ToString() + "\"},"); } if (!string.IsNullOrEmpty(dt.Rows[0]["iNumber10"].ToString())) { sb.Append("{\"id\":\"iNumber10\",\"text\":\"" + dt.Rows[0]["iNumber10"].ToString() + "\"},"); } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); sb = sb.Remove(sb.Length - 2, 2); } else { sb.Append("[{\"id\":\"\",\"text\":\"\"} ]"); //为空时加载 } context.Response.Write(sb.ToString()); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('@'); int id = int.Parse(str[1]); string csbbh = str[2]; if (csbbh.Trim() == "") { HttpContext.Current.Response.Write("1"); return; } DataTable dt = SqlHelper.GetTable("select * from sbzlb where DeviceId='" + csbbh + "'"); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("2"); return; } if (str[3] == "") { HttpContext.Current.Response.Write("3"); return; } sys ex = new sys(); string drq = ""; if (ex.isDate(str[3]) == true) { drq = str[3]; } string cdjr = str[4]; string cbz = str[5]; string cstr1 = str[6]; string cstr2 = str[7]; string cstr3 = str[8]; string cstr4 = str[9]; string cstr5 = str[10]; string cstr6 = str[11]; string cstr7 = str[12]; string cstr8 = str[13]; string cstr9 = str[14]; string cstr10 = str[15]; string bbool1 = str[16]; string bbool2 = str[17]; string bbool3 = str[18]; string bbool4 = str[19]; string bbool5 = str[20]; string bbool6 = str[21]; string bbool7 = str[22]; string bbool8 = str[23]; string bbool9 = str[24]; string bbool10 = str[25]; string inumber1 = str[26]; string inumber2 = str[27]; string inumber3 = str[28]; string inumber4 = str[29]; string inumber5 = str[30]; string inumber6 = str[31]; string inumber7 = str[32]; string inumber8 = str[33]; string inumber9 = str[34]; string inumber10 = str[35]; SqlParameter[] parms = { new SqlParameter("@sbbh", csbbh), new SqlParameter("@rq", drq), new SqlParameter("@djr", cdjr), new SqlParameter("@bz", cbz), new SqlParameter("@cstr1", cstr1), new SqlParameter("@cstr2", cstr2), new SqlParameter("@cstr3", cstr3), new SqlParameter("@cstr4", cstr4), new SqlParameter("@cstr5", cstr5), new SqlParameter("@cstr6", cstr6), new SqlParameter("@cstr7", cstr7), new SqlParameter("@cstr8", cstr8), new SqlParameter("@cstr9", cstr9), new SqlParameter("@cstr10", cstr10), new SqlParameter("@bBool1", bbool1), new SqlParameter("@bBool2", bbool2), new SqlParameter("@bBool3", bbool3), new SqlParameter("@bBool4", bbool4), new SqlParameter("@bBool5", bbool5), new SqlParameter("@bBool6", bbool6), new SqlParameter("@bBool7", bbool7), new SqlParameter("@bBool8", bbool8), new SqlParameter("@bBool9", bbool9), new SqlParameter("@bBool10", bbool10), new SqlParameter("@iNumber1", inumber1), new SqlParameter("@iNumber2", inumber2), new SqlParameter("@iNumber3", inumber3), new SqlParameter("@iNumber4", inumber4), new SqlParameter("@iNumber5", inumber5), new SqlParameter("@iNumber6", inumber6), new SqlParameter("@iNumber7", inumber7), new SqlParameter("@iNumber8", inumber8), new SqlParameter("@iNumber9", inumber9), new SqlParameter("@iNumber10", inumber10), new SqlParameter("@id", id) }; bool flag = SqlHelper.ExeNonQuery("update_djjl", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("修改成功!"); } else { HttpContext.Current.Response.Write("修改失败!"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 查询的方法 /// </summary> private void Query(string csbid, string sState) { try { if (sState == "" || string.IsNullOrEmpty(sState)) { HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]"); return; } //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = "1=1"; if (!string.IsNullOrEmpty(sState) && sState == "s") { if (!string.IsNullOrEmpty(csbid)) { strWhere = strWhere + " and isbid=" + csbid; } } else { HttpContext.Current.Response.Write("{ \"total\":0,\"rows\":[]"); return; } string qsrq = HttpContext.Current.Request["qsrq"]; if (!string.IsNullOrEmpty(qsrq)) { strWhere = strWhere + " and dzysj>='" + qsrq + "'"; } string jzrq = HttpContext.Current.Request["jzrq"]; if (!string.IsNullOrEmpty(jzrq)) { strWhere = strWhere + " and dzysj<='" + jzrq + "'"; } string ckey = HttpContext.Current.Request["ckey"]; string ctext = HttpContext.Current.Request["cmemo"]; if (!string.IsNullOrEmpty(ckey)) { switch (ckey) { case "设备编码": strWhere = strWhere + " and csbbh like '%" + ctext + "%'"; break; case "设备名称": strWhere = strWhere + " and csbmc like '%" + ctext + "%'"; break; case "生产线": strWhere = strWhere + " and cscx like '%" + ctext + "%'"; break; case "所属专业": strWhere = strWhere + " and csszy like '%" + ctext + "%'"; break; case "作业项目": strWhere = strWhere + " and czyxm like '%" + ctext + "%'"; break; case "作业人员": strWhere = strWhere + " and czyry like '%" + ctext + "%'"; break; case "制单人": strWhere = strWhere + " and cczy like '%" + ctext + "%'"; break; case "备注": strWhere = strWhere + " and cbz like '%" + ctext + "%'"; break; } } DataSet duser = SqlHelper.GetList("v_llb", "*", "dzysj", int.Parse(rows), int.Parse(page), false, true, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_llb where " + strWhere); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt1, true, dt.Rows.Count); HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; DataTable dt = new DataTable(); string username = context.Session["username"].ToString(); dt = SqlHelper.GetTable("select * from v_menu where bXsf=1 order by id"); if (dt.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); DataRow[] cRow = null; sb.Append("{\"menus\":["); //基础资料 cRow = dt.Select("cgnbh like '%B%' and cygbh='" + username + "'"); if (cRow.Length > 0) { sb.Append("{\"menuid\":\"B01\",\"menuname\":\"基础资料\",\"menus\":["); for (int i = 0; i < cRow.Length; i++) { if (cRow[i]["cquery"].ToString() == "1") { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"url\":\"" + cRow[i]["clj"].ToString() + "\"},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); } //记录管理 cRow = dt.Select("cgnbh like '%R%' and cygbh='" + username + "'"); if (cRow.Length > 0) { sb.Append("{\"menuid\":\"R01\",\"menuname\":\"记录管理\",\"menus\":["); for (int i = 0; i < cRow.Length; i++) { if (cRow[i]["cquery"].ToString() == "1") { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"url\":\"" + cRow[i]["clj"].ToString() + "\"},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); } if (username == "0000") { //组织设置 cRow = dt.Select("cgnbh like '%Z%'"); if (cRow.Length > 0) { for (int i = 0; i < cRow.Length; i++) { if (cRow[i]["cGnbh"].ToString().Length == 3) { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"menus\":["); } else { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"url\":\"" + cRow[i]["clj"].ToString() + "\"},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); } //维护设置 cRow = dt.Select("cgnbh like '%W%'"); if (cRow.Length > 0) { for (int i = 0; i < cRow.Length; i++) { if (cRow[i]["cGnbh"].ToString().Length == 3) { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"menus\":["); } else { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"url\":\"" + cRow[i]["clj"].ToString() + "\"},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); } //点检设置 cRow = dt.Select("cgnbh like '%D%'"); if (cRow.Length > 0) { for (int i = 0; i < cRow.Length; i++) { if (cRow[i]["cGnbh"].ToString().Length == 3) { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"menus\":["); } else { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"url\":\"" + cRow[i]["clj"].ToString() + "\"},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); } //系统管理 cRow = dt.Select("cgnbh like '%S%'"); if (cRow.Length > 0) { for (int i = 0; i < cRow.Length; i++) { if (cRow[i]["cGnbh"].ToString().Length == 3) { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"menus\":["); } else { sb.Append("{\"menuid\":\"" + cRow[i]["cgnbh"].ToString() + "\",\"menuname\":\"" + cRow[i]["cgnmc"].ToString() + "\",\"url\":\"" + cRow[i]["clj"].ToString() + "\"},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]},"); } } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]}"); context.Response.Write(sb.ToString()); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }