private string readlist1(string chanpingmingcheng1, HttpContext context) { zhangte.BLL.zt_chanpinbiao bll1 = new zhangte.BLL.zt_chanpinbiao(context); zhangte.Model.zt_chanpinbiao model1 = new zhangte.Model.zt_chanpinbiao(); DataSet ds1 = bll1.GetList("产品名称 like '%" + chanpingmingcheng1 + "%'order by id desc"); string strret = "<table cellspacing='0' cellpadding='4' id='GridView1' style='color:#333333;width:100%;border-collapse:collapse;'><tr style='color:White;background-color:#5D7B9D;font-weight:bold;'>\r\n"; strret += "<th scope='col'>产品名称</th><th scope='col'>单价</th><th scope='col'>数量</th><th scope='col'>单位</th><th scope='col'>图片</th></tr>\r\n"; for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { if (i % 2 == 0) { strret += "<tr align='center' style='color:#333333;background-color:#F7F6F3;'> <td>" + ds1.Tables[0].Rows[i]["产品名称"].ToString() + "</td> <td>" + ds1.Tables[0].Rows[i]["单价"].ToString() + "</td><td>" + ds1.Tables[0].Rows[i]["数量"].ToString() + "</td>><td>" + ds1.Tables[0].Rows[i]["单位"].ToString() + "</td><td><img src='" + ds1.Tables[0].Rows[i]["图片"].ToString() + "' style=\"height: 150px; width: 150px\"/></td> </tr>\r\n"; } else { strret += "<tr align='center' style='color:#284775;background-color:White;'> <td>" + ds1.Tables[0].Rows[i]["产品名称"].ToString() + "</td> <td>" + ds1.Tables[0].Rows[i]["单价"].ToString() + "</td><td>" + ds1.Tables[0].Rows[i]["数量"].ToString() + "</td> <td>" + ds1.Tables[0].Rows[i]["单位"].ToString() + "</td><td><img src='" + ds1.Tables[0].Rows[i]["图片"].ToString() + "' style=\"height: 150px; width: 150px\"/></td> </tr>\r\n"; } } strret += "</table>\r\n"; return(strret); }
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) { 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()); //} }