public override void ProcessRequest(HttpContext context) { ljxpower.BLL.com_zidian bll = new ljxpower.BLL.com_zidian(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string xianshizhi = context.Request.QueryString["xianshizhi"]; string xuanzezhi = context.Request.QueryString["xuanzezhi"]; string leibie = context.Request.QueryString["leibie"]; string beifen = context.Request.QueryString["beifen"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), xianshizhi, xuanzezhi, leibie, beifen); } else { bll.Add(xianshizhi, xuanzezhi, leibie, beifen); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,xianshizhi,xuanzezhi,leibie,beifen", "1=1", "Id"); context.Response.Write(strret); return; } else { } }
public override void ProcessRequest(HttpContext context) { zhangte.BLL.zt_chuku bll = new zhangte.BLL.zt_chuku(context); zhangte.Model.zt_chuku model = new Model.zt_chuku(); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); model = bll.GetModel(int.Parse(Id)); string chanpinmingcheng = model.产品名称; string shuliang = model.数量; zhangte.BLL.zt_chanpinbiao kcbll = new BLL.zt_chanpinbiao(); zhangte.Model.zt_chanpinbiao kcmodel = new Model.zt_chanpinbiao(); DataSet kcds = kcbll.GetList("产品名称='" + chanpinmingcheng + "'"); if (kcds.Tables[0].Rows.Count > 0) { string cpmc = kcds.Tables[0].Rows[0][0].ToString(); string kcnum = kcds.Tables[0].Rows[0][4].ToString(); string num = (int.Parse(kcnum) + int.Parse(shuliang)).ToString(); kcmodel = kcbll.GetModel(int.Parse(cpmc)); kcmodel.数量 = num; kcbll.Update1(kcmodel); } bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { if (context.Request.QueryString["comboxname"] == "cpbh") { zhangte.BLL.zt_chanpinbiao bllzd = new zhangte.BLL.zt_chanpinbiao(); string a = HttpContext.Current.Session["gongsibianhao"].ToString(); string strret = bllzd.GetListByColumn_tojson("Id,企业标识代码,产品名称", "企业标识代码='" + a + "'", ""); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "bh") { string a = HttpContext.Current.Session["gongsibianhao"].ToString(); context.Response.Write(a); } else if (context.Request.QueryString["type"] == "time") { DateTime t = DateTime.Now; context.Response.Write(t.ToString()); } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string qiyebiaoshiDM = context.Request.QueryString["qiyebiaoshiDM"]; string chanpinmingcheng = context.Request.QueryString["chanpinmingcheng"]; string shuliang = context.Request.QueryString["shuliang"]; string chukuyuanyin = context.Request.QueryString["chukuyuanyin"]; string chukushijian = context.Request.QueryString["chukushijian"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), qiyebiaoshiDM, chanpinmingcheng, shuliang, chukuyuanyin, chukushijian); } else { bll.Add(qiyebiaoshiDM, chanpinmingcheng, shuliang, chukuyuanyin, chukushijian); zhangte.BLL.zt_chanpinbiao kcbll = new BLL.zt_chanpinbiao(); zhangte.Model.zt_chanpinbiao kcmodel = new Model.zt_chanpinbiao(); DataSet kcds = kcbll.GetList("产品名称='" + chanpinmingcheng + "'"); if (kcds.Tables[0].Rows.Count > 0) { string cpmc = kcds.Tables[0].Rows[0][0].ToString(); string kcnum = kcds.Tables[0].Rows[0][4].ToString(); string num = (int.Parse(kcnum) - int.Parse(shuliang)).ToString(); kcmodel = kcbll.GetModel(int.Parse(cpmc)); kcmodel.数量 = num; kcbll.Update1(kcmodel); } } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' pagestrif = "企业标识代码=(select 企业标识代码 from zt_qiyebiao where 企业名称 ='" + HttpContext.Current.Session["account"].ToString() + "')"; string strret = bll.GetListByPageColumns_tojson("Id,企业标识代码,产品名称,数量,出库原因,出库时间", pagestrif, "Id"); context.Response.Write(strret); return; } else { } }
public override void ProcessRequest(HttpContext context) { kyfly.BLL.yewu_tuifeilipeiGJB bll = new kyfly.BLL.yewu_tuifeilipeiGJB(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 //writeFile("f"); //writeFile(strret); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { if (context.Request.QueryString["comboxname"] == "dingdanbiaoId") { kyfly.BLL.yewu_dingdanxinxiB bllzd = new kyfly.BLL.yewu_dingdanxinxiB(); string strret = bllzd.GetListByColumn_tojson("Id", "1=1", ""); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string xingming = context.Request.QueryString["xingming"]; string shoujianrenshouJH = context.Request.QueryString["shoujianrenshouJH"]; string OpenId = context.Request.QueryString["OpenId"]; string dizhi = context.Request.QueryString["dizhi"]; string zhuangtai = context.Request.QueryString["zhuangtai"]; string peisongrenshouJH = context.Request.QueryString["peisongrenshouJH"]; string peisongshijian = context.Request.QueryString["peisongshijian"]; string shenherenshouJH = context.Request.QueryString["shenherenshouJH"]; string shenhejieguo = context.Request.QueryString["shenhejieguo"]; string jine = context.Request.QueryString["jine"]; string tuikuanjine = context.Request.QueryString["tuikuanjine"]; string leibie = context.Request.QueryString["leibie"]; string dingdanbiaoId = context.Request.QueryString["dingdanbiaoId"]; string zhifudanhao = context.Request.QueryString["zhifudanhao"]; string weixindingdh = context.Request.QueryString["weixindingdh"]; string tuikuandanhao = context.Request.QueryString["tuikuandanhao"]; string beizhu = context.Request.QueryString["beizhu"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), xingming, shoujianrenshouJH, OpenId, dizhi, zhuangtai, peisongrenshouJH, peisongshijian, shenherenshouJH, shenhejieguo, jine, tuikuanjine, leibie, dingdanbiaoId, zhifudanhao, weixindingdh, tuikuandanhao, beizhu); } else { bll.Add(xingming, shoujianrenshouJH, OpenId, dizhi, zhuangtai, peisongrenshouJH, peisongshijian, shenherenshouJH, shenhejieguo, jine, tuikuanjine, leibie, dingdanbiaoId, zhifudanhao, weixindingdh, tuikuandanhao, beizhu); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,OpenId,地址,状态,配送人手机号,配送时间,审核人手机号,审核结果,金额,退款金额,类别,订单表Id,支付单号,微信订单号,退款单号,备注", pagestrif, "Id", 0); //writeFile("f"); //writeFile(strret); context.Response.Write(strret); return; } else { } }
public override void ProcessRequest(HttpContext context) { kyfly.BLL.jichu_renyuanxinxiB bll = new kyfly.BLL.jichu_renyuanxinxiB(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; // writeFile("begin"); mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 writeFile("f"); writeFile(strret); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string xingming = context.Request.QueryString["xingming"]; string shoujihao = context.Request.QueryString["shoujihao"]; string OpenId = context.Request.QueryString["OpenId"]; string mima = context.Request.QueryString["mima"]; string dizhi = context.Request.QueryString["dizhi"]; string zhuangtai = context.Request.QueryString["zhuangtai"]; string leibie = context.Request.QueryString["leibie"]; string quanxian = context.Request.QueryString["quanxian"]; string huiyuanjibie = context.Request.QueryString["huiyuanjibie"]; string peisongcishu = context.Request.QueryString["peisongcishu"]; string beizhu = context.Request.QueryString["beizhu"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), xingming, shoujihao, OpenId, mima, dizhi, zhuangtai, leibie, quanxian, huiyuanjibie, peisongcishu, beizhu); } else { bll.Add(xingming, shoujihao, OpenId, mima, dizhi, zhuangtai, leibie, quanxian, huiyuanjibie, peisongcishu, beizhu); } context.Response.Write("true"); } else if (context.Request.Form["action"] != null && Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,姓名,手机号,OpenId,密码,地址,状态,类别,权限,会员级别,配送次数,备注", pagestrif, "Id", 0); //writeFile("S"); //writeFile(strret); context.Response.Write(strret); return; } else if (context.Request.QueryString["type"] == "read") { string strret = bll.GetListByPageColumns_tojson("Id,姓名,手机号,OpenId,密码,地址,状态,类别,权限,会员级别,配送次数,备注", pagestrif, "Id", 0); //writeFile("S"); // writeFile(strret); context.Response.Write(strret); } else { } }
public void ProcessRequest(HttpContext context) { kyfly.BLL.yewu_dingdanxinxiB bll = new kyfly.BLL.yewu_dingdanxinxiB(context); kyfly.BLL.jichu_zidianbiao bllzd = new kyfly.BLL.jichu_zidianbiao(); DataSet dd = new DataSet(); DataSet dt = new DataSet(); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 writeFile("f"); writeFile(strret); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { writeFile("going"); string xingming = context.Request.QueryString["xingming"]; string shoujianrenshouJH = context.Request.QueryString["shoujianrenshouJH"]; string wupinleixing = context.Request.QueryString["wupinleixing"]; string zhanpian = context.Request.QueryString["zhanpian"]; string peisongdizhi = context.Request.QueryString["peisongdizhi"]; string zhuangtai = context.Request.QueryString["zhuangtai"]; string jiedanshijian = DateTime.Now.Date.ToString(); string qujianhao = context.Request.QueryString["qujianhao"]; string huojiahao = context.Request.QueryString["huojiahao"]; string huowuguizhongF = context.Request.QueryString["huowuguizhongF"]; string zhongliangleibie = context.Request.QueryString["zhongliangleibie"]; string peisongjine = context.Request.QueryString["peisongjine"]; string peisongrenshouJH = context.Request.QueryString["peisongrenshouJH"]; string peisongshijian = DateTime.Now.Date.ToString(); string shenherenshouJH = context.Request.QueryString["shenherenshouJH"]; string dingdanxiuzheng = context.Request.QueryString["dingdanxiuzheng"]; string xiuzhengshijian = DateTime.Now.Date.ToString(); string zhifudanhao = context.Request.QueryString["zhifudanhao"]; string weixindingdh = context.Request.QueryString["weixindingdh"]; string pingjia = context.Request.QueryString["pingjia"]; string beizhu = context.Request.QueryString["beizhu"]; writeFile(xingming); writeFile(shoujianrenshouJH); writeFile(peisongdizhi); writeFile(zhuangtai); writeFile(qujianhao); writeFile(huowuguizhongF); writeFile(zhongliangleibie); dd = bllzd.GetList("字段名称='" + wupinleixing + "'"); zhanpian = dd.Tables[0].Rows[0]["字段值"].ToString(); dd = bllzd.GetList("字段名称='" + zhongliangleibie + "'"); dt = bllzd.GetList("字段名称='" + huowuguizhongF + "'"); string str = dd.Tables[0].Rows[0]["字段值"].ToString(); float pricef = float.Parse(dd.Tables[0].Rows[0]["字段值"].ToString().Trim()); float prices = float.Parse(dt.Tables[0].Rows[0]["字段值"].ToString().Trim()); writeFile(pricef.ToString()); writeFile(prices.ToString()); peisongjine = (pricef * prices).ToString(); writeFile(peisongjine); if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), xingming, shoujianrenshouJH, wupinleixing, zhanpian, peisongdizhi, zhuangtai, jiedanshijian, qujianhao, huojiahao, huowuguizhongF, zhongliangleibie, peisongjine, peisongrenshouJH, peisongshijian, shenherenshouJH, dingdanxiuzheng, xiuzhengshijian, zhifudanhao, weixindingdh, pingjia, beizhu); } else { bll.Add(xingming, shoujianrenshouJH, wupinleixing, zhanpian, peisongdizhi, zhuangtai, jiedanshijian, qujianhao, huojiahao, huowuguizhongF, zhongliangleibie, peisongjine, peisongrenshouJH, peisongshijian, shenherenshouJH, dingdanxiuzheng, xiuzhengshijian, zhifudanhao, weixindingdh, pingjia, beizhu); } context.Response.Write(peisongjine); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,物品类型,照片,配送地址,状态,接单时间,取件号,货架号,货物贵重否,重量类别,配送金额,配送人手机号,配送时间,审核人手机号,订单修正,修正时间,支付单号,微信订单号,评价,备注", "", "Id", 0); writeFile("S"); writeFile(strret); context.Response.Write(strret); return; } else if (context.Request.QueryString["action"] == "query") { string phone = ""; string status = ""; string strret = ""; string statust = ""; string pagestr = ""; int Id = 0; if (context.Request.QueryString["phone"] != null && context.Request.QueryString["status"] != null) { phone = context.Request.QueryString["phone"].ToString(); status = context.Request.QueryString["status"].ToString(); writeFile(phone); writeFile(status); } if (status == "0") { pagestr = "收件人手机号='" + phone + "'"; strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,物品类型,照片,配送地址,状态,接单时间,取件号,货架号,货物贵重否,重量类别,配送金额,配送人手机号,配送时间,审核人手机号,订单修正,修正时间,支付单号,微信订单号,评价,备注", pagestr, "Id", 1); strret = Regex.Replace(strret, "(?<=\"ZT\":\")[^\",]*", status); } else { if (context.Request.QueryString["Id"] != null) { Id = int.Parse(context.Request.QueryString["Id"].ToString()); pagestr = "Id=" + Id; dd = bll.GetList(pagestr); statust = dd.Tables[0].Rows[0]["状态"].ToString(); dt = bllzd.GetList("字段名称='" + statust + "'" + "and " + "类别='" + "状态" + "'"); status = dt.Tables[0].Rows[0]["字段值"].ToString(); strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,物品类型,照片,配送地址,状态,接单时间,取件号,货架号,货物贵重否,重量类别,配送金额,配送人手机号,配送时间,审核人手机号,订单修正,修正时间,支付单号,微信订单号,评价,备注", pagestr, "Id", 1); strret = Regex.Replace(strret, "(?<=\"ZT\":\")[^\",]*", status); } else { dd = bllzd.GetList("字段值='" + status + "'" + "and " + "类别='" + "状态" + "'"); statust = dd.Tables[0].Rows[0]["字段名称"].ToString(); writeFile(statust); pagestr = "收件人手机号='" + phone + "'" + "and " + "状态='" + statust + "'"; writeFile(pagestr); strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,物品类型,照片,配送地址,状态,接单时间,取件号,货架号,货物贵重否,重量类别,配送金额,配送人手机号,配送时间,审核人手机号,订单修正,修正时间,支付单号,微信订单号,评价,备注", pagestr, "Id", 1); strret = Regex.Replace(strret, "(?<=\"ZT\":\")[^\",]*", status); writeFile(strret); } } writeFile("S"); writeFile(strret); context.Response.Write(strret); } else if (context.Request.QueryString["type"] == "compute") { string huowuguizhongF = context.Request.QueryString["huowuguizhongF"]; string zhongliangleibie = context.Request.QueryString["zhongliangleibie"]; dd = bllzd.GetList("字段名称='" + zhongliangleibie + "'"); dt = bllzd.GetList("字段名称='" + huowuguizhongF + "'"); float pricef = float.Parse(dd.Tables[0].Rows[0]["字段值"].ToString().Trim()); float prices = float.Parse(dt.Tables[0].Rows[0]["字段值"].ToString().Trim()); writeFile(pricef.ToString()); writeFile(prices.ToString()); string peisongjine = (pricef * prices).ToString(); context.Response.Write(peisongjine); } }
public override void ProcessRequest(HttpContext context) { ljxpower.BLL.com_user bll = new ljxpower.BLL.com_user(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); kyfly.Common.DbHelperMySQL.ExecuteSql("delete from Com_OrgAddUser where UserId=" + Id); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { if (context.Request.QueryString["comboxname"] == "status") { ljxpower.BLL.com_zidian bllzd = new ljxpower.BLL.com_zidian(); string strret = bllzd.GetListByColumn_tojson("Id,xianshizhi", "leibie='人员状态'", ""); context.Response.Write(strret); //context.Response.Write(""); } if (context.Request.QueryString["comboxname"] == "orgid") { ljxpower.BLL.com_organization bllzd = new ljxpower.BLL.com_organization(); string strret = bllzd.GetListByColumn_tojson("Id,Agency,orgid,Person", "1=1", ""); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "comboxtree") { //string str = ""; //str = ljxpower.Common.DbHelperMySQL.getvalue("select mycontent from temp1"); //context.Response.Write(str); //return; StringBuilder sb = new StringBuilder(); ljxpower.BLL.com_organization orgbll = new ljxpower.BLL.com_organization(); DataSet ds = new DataSet(); ds = orgbll.GetAllList(); if (ds.Tables.Count > 0) { sb.Append("["); DataView dv = new DataView(ds.Tables[0]); dv.RowFilter = "ParentId=0"; dv.Sort = " Sort "; for (int i = 0; i < dv.Count; i++) { sb.Append("{"); sb.Append("\"id\":" + dv[i]["orgid"] + ","); sb.Append("\"text\":\"" + dv[i]["Agency"] + "\""); DataView dv2 = new DataView(ds.Tables[0]); dv2.RowFilter = "ParentId=" + dv[i]["Id"]; dv2.Sort = " Sort "; if (dv2.Count > 0) { sb.Append(GetChlid(dv2, ds)); } sb.Append("},"); } sb.Remove(sb.Length - 1, 1); sb.Append("]"); } context.Response.Write(sb.ToString()); } else if (context.Request.QueryString["type"] == "powersave")//保存修改或添加 { string userstr = context.Request.QueryString["idlist"].ToString(); string roleid = context.Request.QueryString["roleid"].ToString(); string[] userid; if (userstr != "" && roleid != "") { userid = userstr.Split(':'); for (int i = 0; i < userid.Length; i++) { if (userid[i] == "") { continue; } saveRole(userid[i], roleid); } } } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string userid = context.Request.QueryString["userid"]; string logincount = context.Request.QueryString["logincount"]; string username = context.Request.QueryString["username"]; string orgid = context.Request.QueryString["orgid"]; string password = context.Request.QueryString["password"]; string usertype = context.Request.QueryString["usertype"]; string status = context.Request.QueryString["status"]; string gongsibianhao = context.Request.QueryString["gongsibianhao"]; string orgname = context.Request.QueryString["orgname"]; if (password.Trim() != "") { password = ljxpower.Common.DESEncrypt.Encrypt(password); } else { password = kyfly.Common.DbHelperMySQL.getvalue("select password from com_user where UserId=" + userid); } if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { if (kyfly.Common.DbHelperMySQL.getvalue("select id from Com_OrgAddUser where UserId=" + userid) == "") { kyfly.Common.DbHelperMySQL.ExecuteSql("insert into Com_OrgAddUser(orgid,UserId) values('" + orgid + "','" + userid + "')"); } else { bll.Update(context.Request.QueryString["Id"].ToString(), userid, logincount, username, orgid, password, usertype, status, gongsibianhao, orgname); kyfly.Common.DbHelperMySQL.ExecuteSql("update Com_OrgAddUser set orgid='" + orgid + "' where UserId=" + userid); } }//(string Id, string userid, string logincount, string username, string orgid, string password, string usertype, string status, string gongsibianhao) else { bll.Add(userid, logincount, username, orgid, password, usertype, status, gongsibianhao, username); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,userid,logincount,username,orgid,password,usertype,status,gongsibianhao,orgname", pagestrif, "Id"); context.Response.Write(strret); return; } else { } }
public override void ProcessRequest(HttpContext context) { kyfly.BLL.yewu_dingdanxinxiB bll = new kyfly.BLL.yewu_dingdanxinxiB(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 writeFile("f"); writeFile(strret); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string xingming = context.Request.QueryString["xingming"]; string shoujianrenshouJH = context.Request.QueryString["shoujianrenshouJH"]; string wupinleixing = context.Request.QueryString["wupinleixing"]; string zhanpian = context.Request.QueryString["zhanpian"]; string peisongdizhi = context.Request.QueryString["peisongdizhi"]; string zhuangtai = context.Request.QueryString["zhuangtai"]; string jiedanshijian = context.Request.QueryString["jiedanshijian"]; string qujianhao = context.Request.QueryString["qujianhao"]; string huojiahao = context.Request.QueryString["huojiahao"]; string huowuguizhongF = context.Request.QueryString["huowuguizhongF"]; string zhongliangleibie = context.Request.QueryString["zhongliangleibie"]; string peisongjine = context.Request.QueryString["peisongjine"]; string peisongrenshouJH = context.Request.QueryString["peisongrenshouJH"]; string peisongshijian = context.Request.QueryString["peisongshijian"]; string shenherenshouJH = context.Request.QueryString["shenherenshouJH"]; string dingdanxiuzheng = context.Request.QueryString["dingdanxiuzheng"]; string xiuzhengshijian = context.Request.QueryString["xiuzhengshijian"]; string zhifudanhao = context.Request.QueryString["zhifudanhao"]; string weixindingdh = context.Request.QueryString["weixindingdh"]; string pingjia = context.Request.QueryString["pingjia"]; string beizhu = context.Request.QueryString["beizhu"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), xingming, shoujianrenshouJH, wupinleixing, zhanpian, peisongdizhi, zhuangtai, jiedanshijian, qujianhao, huojiahao, huowuguizhongF, zhongliangleibie, peisongjine, peisongrenshouJH, peisongshijian, shenherenshouJH, dingdanxiuzheng, xiuzhengshijian, zhifudanhao, weixindingdh, pingjia, beizhu); } else { bll.Add(xingming, shoujianrenshouJH, wupinleixing, zhanpian, peisongdizhi, zhuangtai, jiedanshijian, qujianhao, huojiahao, huowuguizhongF, zhongliangleibie, peisongjine, peisongrenshouJH, peisongshijian, shenherenshouJH, dingdanxiuzheng, xiuzhengshijian, zhifudanhao, weixindingdh, pingjia, beizhu); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,物品类型,照片,配送地址,状态,接单时间,取件号,货架号,货物贵重否,重量类别,配送金额,配送人手机号,配送时间,审核人手机号,订单修正,修正时间,支付单号,微信订单号,评价,备注", pagestrif, "Id", 0); //writeFile("S"); // writeFile(strret); context.Response.Write(strret); return; } else if (context.Request.QueryString["action"] == "query") { string strret = bll.GetListByPageColumns_tojson("Id,姓名,收件人手机号,物品类型,照片,配送地址,状态,接单时间,取件号,货架号,货物贵重否,重量类别,配送金额,配送人手机号,配送时间,审核人手机号,订单修正,修正时间,支付单号,微信订单号,评价,备注", pagestrif, "Id", 1); writeFile("S"); writeFile(strret); context.Response.Write(strret); } }
public override void ProcessRequest(HttpContext context) { zhangte.BLL.zt_chanpinbiao bll = new zhangte.BLL.zt_chanpinbiao(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "bh") { string a = HttpContext.Current.Session["gongsibianhao"].ToString(); context.Response.Write(a); } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string qiyebiaoshiDM = context.Request.QueryString["qiyebiaoshiDM"]; string chanpinmingcheng = context.Request.QueryString["chanpinmingcheng"]; string danjia = context.Request.QueryString["danjia"]; string shuliang = context.Request.QueryString["shuliang"]; string danwei = context.Request.QueryString["danwei"]; string tupian = context.Request.QueryString["tupian"]; string zhuangtai = context.Request.QueryString["zhuangtai"]; string a = HttpContext.Current.Session["gongsibianhao"].ToString(); if (a != "admin1") { zhuangtai = "未审核"; } if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), qiyebiaoshiDM, chanpinmingcheng, danjia, shuliang, danwei, tupian, zhuangtai); } else { bll.Add(qiyebiaoshiDM, chanpinmingcheng, danjia, shuliang, danwei, tupian, zhuangtai); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { string a = "管理员"; if (a != HttpContext.Current.Session["account"].ToString()) { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' pagestrif = "企业标识代码=(select 企业标识代码 from zt_qiyebiao where 企业名称 ='" + HttpContext.Current.Session["account"].ToString() + "')"; string strret = bll.GetListByPageColumns_tojson("Id,企业标识代码,产品名称,单价,数量,单位,图片,状态", pagestrif, "Id"); context.Response.Write(strret); return; } else { string strret = bll.GetListByPageColumns_tojson("Id,企业标识代码,产品名称,单价,数量,单位,图片,状态", pagestrif, "Id"); context.Response.Write(strret); return; } } //else if(context.Request.QueryString["type"]) == "bh") //{ // context.Response.Write(HttpContext.Current.Session["gongsibianhao"].ToString()); //} }
public override void ProcessRequest(HttpContext context) { zhangte.BLL.zt_qiyebiao bll = new zhangte.BLL.zt_qiyebiao(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string qiyebiaoshiDM = context.Request.QueryString["qiyebiaoshiDM"]; string denglumima = context.Request.QueryString["denglumima"]; string qiyemingcheng = context.Request.QueryString["qiyemingcheng"]; string qiyeleibie = context.Request.QueryString["qiyeleibie"]; string lianxifangshi = context.Request.QueryString["lianxifangshi"]; string fahuodizhi = context.Request.QueryString["fahuodizhi"]; string xinyongdengji = HttpContext.Current.Session["xy"].ToString(); string a = "管理者"; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), qiyebiaoshiDM, denglumima, qiyemingcheng, qiyeleibie, lianxifangshi, fahuodizhi, xinyongdengji); } else if (a == HttpContext.Current.Session["lb"].ToString()) { bll.Add(qiyebiaoshiDM, denglumima, "管理员", "管理者", lianxifangshi, fahuodizhi, "1"); //string a = "管理员"; //if (a == HttpContext.Current.Session["lb"].ToString()) //{ // bll.Add(qiyebiaoshiDM,denglumima,qiyemingcheng,qiyeleibie,lianxifangshi,fahuodizhi); //} } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { string a = "管理员"; if (a != HttpContext.Current.Session["account"].ToString()) { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' pagestrif = "企业标识代码=(select 企业标识代码 from zt_qiyebiao where 企业名称 ='" + HttpContext.Current.Session["account"].ToString() + "')"; string strret = bll.GetListByPageColumns_tojson("Id,企业标识代码,登录密码,企业名称,企业类别,联系方式,发货地址", pagestrif, "Id"); context.Response.Write(strret); return; } else { string strret = bll.GetListByPageColumns_tojson("Id,企业标识代码,登录密码,企业名称,企业类别,联系方式,发货地址", pagestrif, "Id"); context.Response.Write(strret); return; } } else { } }
public override void ProcessRequest(HttpContext context) { kyfly.BLL.jichu_zidianbiao bll = new kyfly.BLL.jichu_zidianbiao(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 // writeFile("f"); //writeFile(strret); context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string ziduanmingcheng = context.Request.QueryString["ziduanmingcheng"]; string ziduanzhi = context.Request.QueryString["ziduanzhi"]; string leibie = context.Request.QueryString["leibie"]; string fenleibie = context.Request.QueryString["fenleibie"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), ziduanmingcheng, ziduanzhi, leibie, fenleibie); } else { bll.Add(ziduanmingcheng, ziduanzhi, leibie, fenleibie); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,字段名称,字段值,类别,分类别", pagestrif, "Id", 0); //writeFile("S"); // writeFile(strret); context.Response.Write(strret); return; } else { } }
public override void ProcessRequest(HttpContext context) { zhangte.BLL.zt_yonghubiao bll = new zhangte.BLL.zt_yonghubiao(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string yonghuming = context.Request.QueryString["yonghuming"]; string mima = context.Request.QueryString["mima"]; string lianxifangshi = context.Request.QueryString["lianxifangshi"]; string shouhuodizhi = context.Request.QueryString["shouhuodizhi"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), yonghuming, mima, lianxifangshi, shouhuodizhi); } else { bll.Add(yonghuming, mima, lianxifangshi, shouhuodizhi); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string a = "管理员"; if (a == HttpContext.Current.Session["account"].ToString()) { string strret = bll.GetListByPageColumns_tojson("Id,用户名,密码,联系方式,收货地址", pagestrif, "Id"); context.Response.Write(strret); return; } else { } } else { } }
public override void ProcessRequest(HttpContext context) { zhangte.BLL.zt_dingdan bll = new zhangte.BLL.zt_dingdan(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string dingdanbianhao = context.Request.QueryString["dingdanbianhao"]; string qiyebiaoshiDM = context.Request.QueryString["qiyebiaoshiDM"]; string yonghuming = context.Request.QueryString["yonghuming"]; string chanpinmingcheng = context.Request.QueryString["chanpinmingcheng"]; string danjia = context.Request.QueryString["danjia"]; string shuliang = context.Request.QueryString["shuliang"]; string zongjia = context.Request.QueryString["zongjia"]; string dingdanshijian = context.Request.QueryString["dingdanshijian"]; string shouhuodizhi = context.Request.QueryString["shouhuodizhi"]; string lianxifangshi = context.Request.QueryString["lianxifangshi"]; string dingdanzhuangtai = context.Request.QueryString["dingdanzhuangtai"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), dingdanbianhao, qiyebiaoshiDM, yonghuming, chanpinmingcheng, danjia, shuliang, zongjia, dingdanshijian, shouhuodizhi, lianxifangshi, dingdanzhuangtai); } else { bll.Add(dingdanbianhao, qiyebiaoshiDM, yonghuming, chanpinmingcheng, danjia, shuliang, zongjia, dingdanshijian, shouhuodizhi, lianxifangshi, dingdanzhuangtai); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { pagestrif = "企业标识代码=(select 企业标识代码 from zt_qiyebiao where 企业名称 ='" + HttpContext.Current.Session["account"].ToString() + "')"; string strret = bll.GetListByPageColumns_tojson("Id,订单编号,企业标识代码,用户名,产品名称,单价,数量,总价,订单时间,收货地址,联系方式,订单状态", pagestrif, "Id"); context.Response.Write(strret); return; } else { } }
public override void ProcessRequest(HttpContext context) { zhangte.BLL.tb_navigation bll = new zhangte.BLL.tb_navigation(context); base.ProcessRequest(context); context.Response.ContentType = "text/plain"; mycommonClass mycommonClassobj = new mycommonClass(); context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); if (context.Request.QueryString["type"] == "edit")//获取编辑信息 { if (context.Request.QueryString["Id"] != null) { string strret = bll.Geteditdata(context.Request.QueryString["Id"].ToString());//aa1 context.Response.Write(strret); } } else if (context.Request.QueryString["type"] == "del")//删除信息 { if (context.Request.QueryString["Id"] == null) { return; } string Id = context.Request.QueryString["Id"].ToString(); bll.Delete(int.Parse(Id)); } else if (context.Request.QueryString["type"] == "combox")//保存修改或添加 信息 aa2 { } else if (context.Request.QueryString["type"] == "save")//保存修改或添加 { string MenuName = context.Request.QueryString["MenuName"]; string Pagelogo = context.Request.QueryString["Pagelogo"]; string ParentId = context.Request.QueryString["ParentId"]; string LinkAddress = context.Request.QueryString["LinkAddress"]; string Icon = context.Request.QueryString["Icon"]; string Sort = context.Request.QueryString["Sort"]; string IsShow = context.Request.QueryString["IsShow"]; if (context.Request.QueryString["Id"] != null && context.Request.QueryString["Id"] != "") { bll.Update(context.Request.QueryString["Id"].ToString(), MenuName, Pagelogo, ParentId, LinkAddress, Icon, Sort, IsShow); } else { bll.Add(MenuName, Pagelogo, ParentId, LinkAddress, Icon, Sort, IsShow); } context.Response.Write("true"); } else if (Convert.ToString(context.Request.Form["action"]) == "query") { //string strret = bll.GetListByPageColumns_tojson("id,产品名称,产品数量,产品规格,备注", "1=1", "产品数量"); 加权限, 1=1 改为:部门编号 like '1010%' string strret = bll.GetListByPageColumns_tojson("Id,MenuName,Pagelogo,ParentId,LinkAddress,Icon,Sort,IsShow", pagestrif, "Id"); context.Response.Write(strret); return; } else { } }