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);
}
}
