/// <summary>
/// 更新商品浏览次
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string clickNum(int id)
{
if (Request.HttpMethod == "POST")
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
bll.ExecuteNonQuery("UPDATE Product SET Product_ClickNum=Product_ClickNum+1 WHERE Product_ID=" + id);
}
return("");
}
/// <summary>
/// 已处理操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool YiChuli(int id)
{
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
string s = string.Format(@"update MemberIntegralGiftExchange set ontime=getdate(),Editer={1},[State]=2 where [State]<>0 and [id]={0}",
id, adminInfo == null ? 0 : adminInfo.AdminId);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
return(0 < db.ExecuteNonQuery(s));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string id = context.Request["pid"];
string cuprice = context.Request["cuprice"];
string discount = context.Request["discount"];
string btime = context.Request["btime"];
string etime = context.Request["etime"];
string maxsell = context.Request["maxsell"];
string minsell = context.Request["minsell"];
string otcminsell = context.Request["otcminsell"];
string canel = context.Request["canel"];
if (!string.IsNullOrEmpty(id))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001030000"))
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
//设置促销
string sql = string.Format("update product set cuprice={0},discount={1},maxsell={2},begindate='{3}',enddate='{4}',otcminsell={6},minsell={7} where Product_ID={5}", cuprice, discount, maxsell, btime, etime, id, otcminsell, minsell);
//取消促销设置
if (!string.IsNullOrEmpty(canel))
{
sql = string.Format("update product set cuprice=0,discount=0,maxsell=0,minsell=0,otcminsell=0,begindate=null,enddate=null where Product_ID={0}", id);
}
int result = db.ExecuteNonQuery(sql);
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("设置了促销商品:[{0}][{1}]", id, new SOSOshop.BLL.Db().ExecuteScalar("SELECT Product_Name FROM dbo.Product WHERE Product_ID=" + id), string.IsNullOrEmpty(canel) ? "促销" : "取消促销"), adminModel.AdminId, adminModel.AdminName, 1);
//大表同步更新
// sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"设置完成\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有操作权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string id = context.Request["pid"];
string stop = context.Request["stop"];
string sql = null;
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(stop))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001009003"))
{
int sp = int.Parse(stop);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
if (sp == 1)
{
sql = "update product set Product_bShelves=1,Product_bStop=" + stop + " where Product_ID=" + id;//商品停用并下架
}
else
{
sql = "update product set Product_bStop=" + stop + " where Product_ID=" + id;//商品启用，不改变商品上下架状态
}
//context.Response.Write(sql);
int result = db.ExecuteNonQuery(sql);
//大表同步更新
//sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"已处理\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有操作权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + sql + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region ajax 上架、下架、删除
if (!string.IsNullOrEmpty(Request.QueryString["ajax"]))
{
if (SOSOshop.BLL.PowerPass.isPass("008011002"))
{
string id = Request.Form["id"];
string Shangjia = Request.Form["Shangjia"];
string Del = Request.Form["Del"];
string s = "";
if (!string.IsNullOrEmpty(Shangjia) && Shangjia == "1")
{
s = string.Format("update MemberIntegralGift set [State]=(case when State=1 then 2 when State=2 then 1 else State end) where [id]={0}", id);
}
else if (!string.IsNullOrEmpty(Del) && Del == "1")
{
s = string.Format("update MemberIntegralGift set [State]=0 where [id]={0}", id);
}
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
int ret = db.ExecuteNonQuery(s);
if (ret > 0)
{
Response.Write("{\"state\":1,\"message\":\"处理成功！\"}");
}
else
{
Response.Write("{\"state\":0,\"message\":\"处理失败！\"}");
}
}
catch (Exception x)
{
Response.Write("{\"state\":-2,\"message\":\"" + x.Message + "\"}");
}
}
else
{
Response.Write("{\"state\":-1,\"message\":\"对不起，您没有编辑权限，请联系管理员！\"}");
}
Response.End();
}
#endregion
if (!this.Page.IsPostBack)
{
SOSOshop.BLL.PromptInfo.Popedom("008011002");
GetList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region ajax 修改积分
if (!string.IsNullOrEmpty(Request.QueryString["ajax"]))
{
if (SOSOshop.BLL.PowerPass.isPass("008011001"))
{
string id = Request.Form["id"];
string integral = Request.Form["integral"];
string s = string.Format("update MemberIntegralTemplate set [integral]={0} where [id]={1}", integral, id);
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
int ret = db.ExecuteNonQuery(s);
if (ret > 0)
{
Response.Write("{\"state\":1,\"message\":\"更新成功！\"}");
}
else
{
Response.Write("{\"state\":0,\"message\":\"更新失败！\"}");
}
}
catch (Exception x)
{
Response.Write("{\"state\":-2,\"message\":\"" + x.Message + "\"}");
}
}
else
{
Response.Write("{\"state\":-1,\"message\":\"对不起，您没有编辑权限，请联系管理员！\"}");
}
Response.End();
}
#endregion
//修改积分倍数
if (!string.IsNullOrEmpty(Request.Form["multiple"]))
{
bllo.update(Request.Form["id"], int.Parse(Request.Form["multiple"]));
Response.End();
}
if (!this.Page.IsPostBack)
{
SOSOshop.BLL.PromptInfo.Popedom("008011001");
GetList();
}
}
/// <summary>
/// 重新计算是否有在出售的otc品种
/// </summary>
public static void InitProduct_otc()
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
DataSet ds1 = bll.ExecuteDataSet("select id from Tag_PharmAttribute AS tag where tag_id=71 order by id");
SOSOshop.BLL.DrugsBase.Tag_PharmAttribute ta = new SOSOshop.BLL.DrugsBase.Tag_PharmAttribute();
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
int tagid = (int)ds1.Tables[0].Rows[i][0];
int count = ta.GetCount(tagid);
string sql = string.Format(@"IF EXISTS(SELECT * FROM Tag_PharmAttribute_Product_Count WHERE Tag_PharmAttribute_id={1})
UPDATE Tag_PharmAttribute_Product_Count SET Product_Count={0} WHERE Tag_PharmAttribute_id={1}
ELSE
INSERT Tag_PharmAttribute_Product_Count (Tag_PharmAttribute_id,Product_Count) VALUES({1},{0})", count, tagid);
bll.ExecuteNonQuery(sql);
}
}
public void ProcessRequest(HttpContext context)
{
string id = context.Request["pid"];
string stop = context.Request["verify"];
string sql = null;
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(stop))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001009002"))
{
int sp = int.Parse(stop);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
if (sp == 1)
{
sql = "update product set Product_bShelves=0,Product_bStop=0, shop_state=0 where Product_ID=" + id;//审核商品
}
//context.Response.Write(sql);
int result = db.ExecuteNonQuery(sql);
//大表同步更新
sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"已处理\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有审核权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string bshelves = context.Request["bshelves"];
string state = context.Request["state"];
string pid = context.Request["pid"];
if (!string.IsNullOrEmpty(pid))
{
if (SOSOshop.BLL.PowerPass.isPass("001009004"))
{
string s = string.Format("update product set Product_State='{1}' where [Product_ID]={2}", bshelves, state, pid);
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
int ret = db.ExecuteNonQuery(s);
if (ret > 0)
{
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("{2}了商品:[{0}][{1}]", pid, new SOSOshop.BLL.Db().ExecuteScalar("SELECT Product_Name FROM dbo.Product WHERE Product_ID=" + pid), bshelves == "1" ? "上架" : "下架"), adminModel.AdminId, adminModel.AdminName, 1);
context.Response.Write("{\"state\":" + ret + ",\"message\":\"更新成功！\"}");
}
else
{
context.Response.Write("{\"state\":" + ret + ",\"message\":\"更新失败！\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-2,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起，您没有编辑权限，请联系管理员！\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"未知错误！\"}");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string id = context.Request["pid"];
string shelves = context.Request["shelves"];
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(shelves))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001009005"))
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
string sql = string.Format("UPDATE product SET beactive='{0}' ,Product_bShelves='{1}' WHERE Product_ID={2}", shelves.Equals("1") ? "是" : "否", shelves, id);
//context.Response.Write(sql);
int result = db.ExecuteNonQuery(sql);
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("{2}了商品:[{0}][{1}]", id, new SOSOshop.BLL.Db().ExecuteScalar("SELECT Product_Name FROM dbo.Product WHERE Product_ID=" + id), shelves == "1" ? "上架" : "下架"), adminModel.AdminId, adminModel.AdminName, 1);
//大表同步更新
sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"已处理\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有操作权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
/// <summary>
/// 重新计算一下锁库数量
/// </summary>
public static void InitStock_Lock()
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
bll.ExecuteNonQuery("UPDATE dbo.Stock_Lock SET Stock=dbo.fn_select_lockStock(Product_ID) WHERE Stock>0 AND Stock<>dbo.fn_select_lockStock(Product_ID)");
}