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