public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string strDate = context.Request["data"]; if (strDate.IndexOf("年") >= 0) { strDate = strDate.Replace("年", "-"); } if (strDate.IndexOf("月") >= 0) { strDate = strDate.Replace("月", "-"); } if (strDate.IndexOf("日") >= 0) { strDate = strDate.Replace("日", ""); } //if (strDate.IndexOf("星期") >= 0) strDate = strDate.Replace("星期", ""); //if (strDate.IndexOf("周") >= 0) strDate = strDate.Replace("周", ""); //if (strDate.IndexOf("一") >= 0) strDate = strDate.Replace("一", ""); //if (strDate.IndexOf("二") >= 0) strDate = strDate.Replace("二", ""); //if (strDate.IndexOf("三") >= 0) strDate = strDate.Replace("三", ""); //if (strDate.IndexOf("四") >= 0) strDate = strDate.Replace("四", ""); //if (strDate.IndexOf("五") >= 0) strDate = strDate.Replace("五", ""); //if (strDate.IndexOf("六") >= 0) strDate = strDate.Replace("六", ""); //非ie浏览器出现日期格式2016-01-14 if (strDate.IndexOf("/") >= 0) { strDate = strDate.Replace("/", "-"); } string sYear = ""; string sMonth = ""; string sDay = ""; sYear = strDate.Split('-')[0]; sMonth = strDate.Split('-')[1]; if (sMonth.Length == 1) { sMonth = "0" + sMonth; } sDay = strDate.Split('-')[2]; if (sDay.Length == 1) { sDay = "0" + sDay; } strDate = sYear + "-" + sMonth + "-" + sDay; context.Response.Write(strDate); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 查询的方法:获取y轴数据 /// </summary> private void Query2(string sks, string sjz, string ssb, string ccs) { try { StringBuilder sb = new StringBuilder(); DataTable dt = SqlHelper.GetTable("select * from v_djtb where isbid=" + ssb + " and drq>='" + sks + "' and drq<='" + sjz + "' order by drq"); if (dt.Rows.Count > 0) { string dat = "0"; string sbName = dt.Rows[0]["csbmc"].ToString(); sb.Append("[{ name:'" + sbName + "',data:["); for (int i = 0; i < dt.Rows.Count; i++) { dat = dt.Rows[i][ccs].ToString(); sb.Append(dat + ","); } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]}]"); } HttpContext.Current.Response.Write(sb.ToString()); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 载入数据 /// </summary> private void Load_Yc(string strId) { try { if (string.IsNullOrEmpty(strId)) { return; } DataTable dt = SqlHelper.GetTable("select * from v_ycjl 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]["cycms"].ToString(); str = str + "&" + dt.Rows[0]["dycsj"].ToString(); str = str + "&" + dt.Rows[0]["ccljl"].ToString(); str = str + "&" + dt.Rows[0]["czyr"].ToString(); str = str + "&" + dt.Rows[0]["djssj"].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) { context.Response.ContentType = "text/plain"; try { StringBuilder sb = new StringBuilder(""); sb.Append("["); for (int i = 1; i <= 16; i++) { sb.Append("{\"id\":\"" + i.ToString() + "\",\"text\":\"" + i.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 data = context.Request["data"]; string[] str = data.Split('&'); string dqrq = str[0]; dqrq = dqrq.Replace("年", "-"); dqrq = dqrq.Replace("月", "-"); dqrq = dqrq.Replace("日", ""); string flag = str[1]; SqlParameter[] parms = { new SqlParameter("@dqrq", dqrq), new SqlParameter("@flag", flag) }; DataSet ds = SqlHelper.ExecuteQuery("getGdh", parms); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { context.Response.Write(dt.Rows[0]["gdh"].ToString()); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { string userid = HttpContext.Current.Request.Form["userid"]; string depid = HttpContext.Current.Request.Form["depid"]; DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from DataAuthority where userid='" + userid + "'"); if (dt.Rows.Count > 0) { string updatesql = "update DataAuthority set depid='" + depid + "' where userid='" + userid.Trim() + "';"; ExecSql(updatesql.ToString()); } else { string insertsql = "insert into DataAuthority (userid,depid) values ('" + userid.Trim() + "','" + depid.Trim() + "');"; ExecSql(insertsql.ToString()); } HttpContext.Current.Response.Write("授权成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 载入数据 /// </summary> private void Load_Xh(string strId) { try { if (string.IsNullOrEmpty(strId)) { return; } DataTable dt = SqlHelper.GetTable("select * from v_xhqz where id=" + strId); if (dt.Rows.Count > 0) { string str = ""; str = dt.Rows[0]["cdh"].ToString(); str = str + "&" + dt.Rows[0]["dsj"].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]["iyz"].ToString(); str = str + "&" + dt.Rows[0]["iqzz"].ToString(); str = str + "&" + dt.Rows[0]["cyy"].ToString(); str = str + "&" + dt.Rows[0]["czt"].ToString(); str = str + "&" + dt.Rows[0]["czdr"].ToString(); str = str + "&" + dt.Rows[0]["cbz"].ToString(); HttpContext.Current.Response.Write(str); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void start() { try { DataTable dt = SqlHelper.GetTable("select * from scszb"); if (dt.Rows.Count > 0) { //RunBat(dt.Rows[0]["clj"].ToString() + "\\start.bat"); ExecuteRemote("192.168.1.34", "LXH", "admin", "", dt.Rows[0]["clj"].ToString() + "\\start.bat"); HttpContext.Current.Response.Write(dt.Rows[0]["clj"].ToString() + "\\start.bat"); } else { HttpContext.Current.Response.Write("启动服务失败!"); } dt = null; } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string action = context.Request["action"]; StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from sbflb order by pid"); if (dt.Rows.Count > 0) { if (action == "0") { sb.Append(GetDataString2(dt, "0")); } else { 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); } }
private void Query(string id) { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = ""; if (!string.IsNullOrEmpty(id)) { strWhere = " ilxid=" + id; } else { strWhere = " 1=1"; } DataSet duser = SqlHelper.GetList("v_djlx_mx", "*", "ilxid", int.Parse(rows), int.Parse(page), false, false, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_djlx_mx 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 Query() { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = "1=1"; //使用存储过程及临时表实现递归方式列表 SqlParameter[] parms = { new SqlParameter("@where", strWhere) }; SqlHelper.ExeNonQuery("proc_getDepartCode", CommandType.StoredProcedure, parms); DataSet duser = SqlHelper.GetList("v_zxzbjl", "*", "drq", int.Parse(rows), int.Parse(page), false, true, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_zxzbjl 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"; string sbid = context.Request["sbid"]; if (!string.IsNullOrEmpty(sbid)) { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = " isbid=" + sbid; DataSet duser = SqlHelper.GetList("v_sbzl_bjzl2", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from v_sbzl_bjzl2 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 Query(string ygid) { try { //一页显示几行数据,使用该语句在firefox下一页显示不全。 //string rows = HttpContext.Current.Request["rows"]; string rows = "50"; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = " iygid=" + ygid; DataTable dt = new DataTable(); //获取数据源 dt = SqlHelper.GetTable("select * from v_ygqx where " + strWhere); string str = string.Empty; //将数据转换成json格式 str = JSonHelper.CreateJsonParameters(dt, true, dt.Rows.Count); HttpContext.Current.Response.Write(str); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//删除的方法 private void Del() { try { //获取到选中行的id string id = HttpContext.Current.Request["id"]; string sql = "delete from djlxb_mx where ilxid=" + id; SqlHelper.TransactSql(sql); int count = 0; count = SqlHelper.DelData("djlxb", 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); } }
/// <summary> /// 查询的方法 /// </summary> private void Query() { try { //一页显示几行数据 string rows = HttpContext.Current.Request["rows"]; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = GetWhere(); DataSet duser = SqlHelper.GetList("wxgzz", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere); DataTable dt1 = duser.Tables[0]; //获取数据源 DataTable dt = SqlHelper.GetTable("select * from wxgzz 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> /// Post数据接口 /// </summary> /// <param name="postUrl">接口地址</param> /// <param name="paramData">提交json数据</param> /// <param name="dataEncode">编码方式</param> /// <returns></returns> public string PostWebRequest(string postUrl, string paramData, Encoding dataEncode) { string ret = string.Empty; try { byte[] byteArray = dataEncode.GetBytes(paramData); //转化 HttpWebRequest webReq = (HttpWebRequest)WebRequest.Create(new Uri(postUrl)); webReq.Method = "POST"; webReq.ContentType = "application/x-www-form-urlencoded"; webReq.ContentLength = byteArray.Length; Stream newStream = webReq.GetRequestStream(); newStream.Write(byteArray, 0, byteArray.Length);//写入参数 newStream.Close(); HttpWebResponse response = (HttpWebResponse)webReq.GetResponse(); //该处用Encoding.UTF-8编码,因为微信使用的就是该编码,不能使用Encoding.Default,中文下容易出现乱码 StreamReader sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8); ret = sr.ReadToEnd(); sr.Close(); response.Close(); newStream.Close(); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } return(ret); }
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]["csbbh"].ToString() + "&" + dt.Rows[0]["id"].ToString(); } else { value = "err"; } } context.Response.Write(value); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
/// <summary> /// 查询的方法:获取x轴数据 /// </summary> private void Query(string sks, string sjz, string ssb) { try { StringBuilder sb = new StringBuilder(); DataTable dt = SqlHelper.GetTable("select * from v_djtb where isbid=" + ssb + " and drq>='" + sks + "' and drq<='" + sjz + "' order by drq"); if (dt.Rows.Count > 0) { string dat = ""; sb.Append("["); for (int i = 0; i < dt.Rows.Count; i++) { dat = dt.Rows[i]["drq"].ToString(); dat = DateTime.Parse(dat).ToString(); sb.Append("'" + dat + "',"); } sb.Replace(',', ' ', sb.Length - 1, 1); sb.Append("]"); } HttpContext.Current.Response.Write(sb.ToString()); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void Restore() { try { //根据连接字符串获取数据库名称 string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; string db = strConn.Split(';')[1]; string dbname = db.Split('=')[1]; string bkname = HttpContext.Current.Request["data"].ToString(); string bakpath = ConfigurationManager.ConnectionStrings["bakpath"].ConnectionString; string bkpath = bakpath + bkname; //使用单个符号“\”提示常量中有换行符 string connString = SqlHelper.conString; connString = connString.Replace(dbname, "master"); //替换数据库 SqlConnection con = new SqlConnection(connString); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandTimeout = 0; //设置永不超时,否则恢复时间长容易产生超时错误 cmd.CommandText = "exec p_RestoreDb '" + bkpath + "','" + dbname + "'"; cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); 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 jsbm = str[1].Split('=')[1]; string jsmc = str[2].Split('=')[1]; jsmc = jsmc.Substring(0, jsmc.Length - 1); //角色编码不允许为空 if (jsbm.ToString().Length == 0) { HttpContext.Current.Response.Write("1"); return; } //角色名称不允许为空 if (jsmc.Trim().Length == 0) { HttpContext.Current.Response.Write("2"); return; } //判断分类名称是否存在 DataTable dt = SqlHelper.GetTable("select * from jsglb where cjsbm='" + jsbm + "' and id<>" + id); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("3"); return; } SqlParameter[] parms = { new SqlParameter("@jsbm", jsbm), new SqlParameter("@jsmc", jsmc), new SqlParameter("@id", id) }; bool flag = SqlHelper.ExeNonQuery("update_jsgl", 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 jsid) { try { //一页显示几行数据,使用该语句在firefox下一页显示不全。 //string rows = HttpContext.Current.Request["rows"]; string rows = "50"; //当前页 string page = HttpContext.Current.Request["page"]; string strWhere = ""; if (string.IsNullOrEmpty(jsid)) { strWhere = " 1=1 "; } else { if (jsid == "0") { strWhere = " 1>2"; } else { strWhere = " ijsid=" + jsid; } } DataSet duser = new DataSet(); DataTable dt1 = new DataTable(); DataTable dt = new DataTable(); //获取数据源 dt = SqlHelper.GetTable("select * from v_qxgl where " + strWhere); if (dt.Rows.Count > 0) //加载已有权限 { duser = SqlHelper.GetList("v_qxgl", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere); } else { dt = SqlHelper.GetTable("select * from v_qxgl2 where " + strWhere); //没有该操作员的权限,加载权限为空 duser = SqlHelper.GetList("v_qxgl2", "*", "id", int.Parse(rows), int.Parse(page), false, false, strWhere); } dt1 = duser.Tables[0]; 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 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('&'); string sjbm = str[1].Split('=')[1]; string bmmc = str[2].Split('=')[1]; string bmsx = str[3].Split('=')[1]; if (sjbm.Trim().Length == 0) { HttpContext.Current.Response.Write("1"); return; } if (bmmc.Trim().Length == 0) { HttpContext.Current.Response.Write("2"); return; } //判断分类名称是否存在 DataTable dt = SqlHelper.GetTable("select * from bmzlb where cbmmc='" + bmmc + "'"); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("3"); return; } SqlParameter[] parms = { new SqlParameter("@sjbm", sjbm), new SqlParameter("@bmmc", bmmc), new SqlParameter("@bmsx", bmsx) }; bool flag = SqlHelper.ExeNonQuery("insert_bmzl", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("添加成功!"); } else { HttpContext.Current.Response.Write("添加失败!"); } } catch (Exception ex) { sys s = new sys(); s.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('&'); string jsbm = str[1].Split('=')[1]; string jsmc = str[2].Split('=')[1]; //重要:将数组最后一维后面的'\n'去掉,否则出现tree无法加载的情况 jsmc = jsmc.Substring(0, jsmc.Length - 1); if (jsbm.Trim().Length == 0) { HttpContext.Current.Response.Write("1"); return; } if (jsmc.Trim().Length == 0) { HttpContext.Current.Response.Write("2"); return; } //判断角色编码是否存在 DataTable dt = SqlHelper.GetTable("select * from jsglb where cjsbm='" + jsbm + "'"); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("3"); return; } SqlParameter[] parms = { new SqlParameter("@jsbm", jsbm), new SqlParameter("@jsmc", jsmc) }; bool flag = SqlHelper.ExeNonQuery("insert_jsgl", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("添加成功!"); } else { 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"; //判断权限 DataTable dt = new DataTable(); string username = context.Session["username"].ToString(); string cgnbh = context.Request["data"]; string action = context.Request["action"]; cgnbh = cgnbh.Replace("#", ""); dt = SqlHelper.GetTable("select * from v_menu where cygbh='" + username + "' and cgnbh='" + cgnbh + "'"); if (dt.Rows.Count == 0) { context.Response.Write("err"); return; } if (action == "del") { if (dt.Rows[0]["cdel"].ToString() == "0") { context.Response.Write("del"); return; } } if (action == "add") { if (dt.Rows[0]["cadd"].ToString() == "0") { context.Response.Write("add"); return; } } if (action == "edit") { if (dt.Rows[0]["cedit"].ToString() == "0") { context.Response.Write("edit"); return; } } if (action == "query") { if (dt.Rows[0]["cquery"].ToString() == "0") { context.Response.Write("query"); return; } } dt = null; //释放数据表 } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string action = context.Request["action"]; if (!string.IsNullOrEmpty(action)) { StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from sszyb"); if (dt.Rows.Count > 0) { DataRow[] CRow = null; if (action == "1") { CRow = dt.Select(""); //部门为顶级时,显示为部门资料 } else { CRow = dt.Select("ibmid=" + action); //部门为子类部门 } if (CRow.Length > 0) { sb.Append("["); for (int i = 0; i < CRow.Length; i++) { sb.Append("{\"id\":\"" + CRow[i]["id"].ToString() + "\",\"text\":\"" + CRow[i]["csszy"].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); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string dx = context.Request["dx"]; if (!string.IsNullOrEmpty(dx)) { StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); if (dx == "1") { dt = SqlHelper.GetTable("select * from bmzlb"); } else { dt = SqlHelper.GetTable("select * from ygzlb"); } if (dt.Rows.Count > 0) { sb.Append("["); if (dx == "1") //班组 { for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("{\"id\":\"" + dt.Rows[i]["id"].ToString() + "\",\"text\":\"" + dt.Rows[i]["cbmmc"].ToString() + "\"},"); } } else { //个人 for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("{\"id\":\"" + dt.Rows[i]["id"].ToString() + "\",\"text\":\"" + dt.Rows[i]["cygxm"].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); } }
//保存 private void save() { 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('&'); string cscsjjg = str[0].Split('=')[1]; string cscqssj = str[1].Split('=')[1]; string cscjssj = str[2].Split('=')[1]; if (string.IsNullOrEmpty(cscsjjg)) { HttpContext.Current.Response.Write("1"); return; } if (string.IsNullOrEmpty(cscqssj)) { HttpContext.Current.Response.Write("2"); return; } if (string.IsNullOrEmpty(cscjssj)) { HttpContext.Current.Response.Write("3"); return; } SqlParameter[] parms = { new SqlParameter("@scsjjg", cscsjjg), new SqlParameter("@scqssj", cscqssj), new SqlParameter("@scjssj", cscjssj) }; bool flag = SqlHelper.ExeNonQuery("update_scsz", 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 Del() { try { //获取到选中行的id string id = HttpContext.Current.Request["id"]; string sSql = ""; DataTable dt = new DataTable(); //判断处理方式中是否存在 sSql = "select * from clfsb where igzid=" + id; dt = SqlHelper.GetTable(sSql); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("1"); return; } //判断维修记录中是否存在 sSql = "select * from wxjlb where igzlx=" + id; dt = SqlHelper.GetTable(sSql); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("2"); return; } //判断该故障是否有下级故障 sSql = "select * from gzxxb where pid=" + id; dt = SqlHelper.GetTable(sSql); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("3"); return; } int count = 0; count = SqlHelper.DelData("gzxxb", 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) { try { context.Response.ContentType = "text/plain"; StringBuilder sb = new StringBuilder(""); DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from sbflb order by pid"); if (dt.Rows.Count > 0) { DataRow[] CRow = dt.Select("1=1"); if (CRow.Length > 0) { sb.Append("["); string action = context.Request["action"]; for (int i = 0; i < CRow.Length; i++) { if (action == "1") //显示全部分类 { sb.Append("{\"id\":\"" + CRow[i]["id"].ToString() + "\",\"text\":\"" + CRow[i]["csbfl"].ToString() + "\"},"); } else if (action == "2") //查找节点是否有子节点,显示最末级分类 { DataRow[] dRow = dt.Select("pid=" + CRow[i]["id"]); if (dRow.Length == 0) { sb.Append("{\"id\":\"" + CRow[i]["id"].ToString() + "\",\"text\":\"" + CRow[i]["csbfl"].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); } }
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 csxlx = str[1].Split('=')[1]; // //重要:将数组最后一维后面的'\n'去掉,否则出现tree无法加载的情况 csxlx = csxlx.Substring(0, csxlx.Length - 1); if (string.IsNullOrEmpty(csxlx)) { HttpContext.Current.Response.Write("1"); return; } dt = SqlHelper.GetTable("select * from sxlxb where csxlx='" + csxlx + "' and id<>" + id); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("2"); return; } SqlParameter[] parms = { new SqlParameter("@sxlx", csxlx), new SqlParameter("@id", id) }; bool flag = SqlHelper.ExeNonQuery("update_sxlx", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("修改成功!"); } else { HttpContext.Current.Response.Write("修改失败!"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }