/// <summary> /// 取消操作 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool QuXiao(int id) { SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get(); string s = string.Format(@"declare @uid int,@Gift_ID int,@Gift_Number decimal,@Integral decimal if exists(select * from MemberIntegralGiftExchange where [State]<>0 and [id]={0}) begin update MemberIntegralGiftExchange set ontime=getdate(),Editer={1},[State]=0 where [State]<>0 and [id]={0} select @uid = uid, @Gift_ID = Gift_ID, @Gift_Number = Gift_Number from MemberIntegralGiftExchange where [id]={0} select @Integral = Integral * @Gift_Number from MemberIntegralGift where [id]=@Gift_ID update MemberIntegralGift set Number = Number + @Gift_Number where [id]=@Gift_ID update MemberIntegral set realityIntegral = realityIntegral + @Integral where [uid]=@uid end select @uid,@Integral", id, adminInfo == null ? 0 : adminInfo.AdminId); SOSOshop.BLL.Db db = new SOSOshop.BLL.Db(); DataSet ds = db.ExecuteDataSet(s); bool ok = ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && !ds.Tables[0].Rows[0].IsNull(0); if (ok) { int uid = int.Parse(ds.Tables[0].Rows[0][0].ToString()); decimal integral = decimal.Parse(ds.Tables[0].Rows[0][1].ToString()); SOSOshop.BLL.Integral.MemberIntegral bll2 = new SOSOshop.BLL.Integral.MemberIntegral(); bll2.PresentIntegral(uid, Convert.ToInt32(integral), "返还兑换礼品的积分", true); } return(ok); }
/// <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) { context.Response.ContentType = "text/html"; SOSOshop.BLL.SysParameter sp = new SOSOshop.BLL.SysParameter(); #region //是否允许注册新用户 if (!sp.IsRegistered) { ChangeHope.WebPage.Script.AlertAndGoBack("温馨提示:目前不允许新用户注册!"); } else { if (ChangeHope.WebPage.PageRequest.GetFormString("Option") != string.Empty) { context.Response.Clear(); string types = context.Request.Form["Option"].Trim(); if (types == "NewRegisteredMembers" && context.Session["DoNotTipForNewRegisteredMembers"] == null) { if (context.Request.Form["DoNotTip"] != null && context.Request.Form["DoNotTip"] == "Yes") { context.Session["DoNotTipForNewRegisteredMembers"] = true; context.Response.End(); return; } string json = "";//获取这两天刚注册的未导入CRM的会员 SOSOshop.BLL.Db db = new SOSOshop.BLL.Db(); DataSet ds = db.ExecuteDataSet("SELECT a.UID,a.UserId,a.Email,b.TrueName,b.MobilePhone,a.RegisterIP FROM yxs_memberaccount AS a INNER JOIN yxs_memberinfo AS b ON a.UID=b.UID WHERE datediff(DAY,RegisterDate,GETDATE())<=2 AND Member_Class=1 AND State=0 AND CRMID=0"); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; json += "{id:" + dr["UID"] + ",name:\"" + Convert.ToString(dr["UserId"]).Replace("\"", "") + "\",email:\"" + Convert.ToString(dr["Email"]).Replace("\"", "") + "\",truename:\"" + Convert.ToString(dr["TrueName"]).Replace("\"", "") + "\",mobilephone:\"" + Convert.ToString(dr["MobilePhone"]).Replace("\"", "") + "\",location:\"" + ChangeHope.WebPage.PageRequest.GetIPLocation(Convert.ToString(dr["RegisterIP"])).Replace("\"", "") + "\"},"; } if (json != "") { json = json.Substring(0, json.Length - 1); } json = "{result:[" + json + "]}"; } context.Response.Write(json); context.Response.End(); return; } else if (types == "NewRegisteredMembersDebug") { string json = ""; for (int i = 1; i < 10; i++) { json += "{id:" + i + ",name:\"会员名" + i + "\"},"; } if (json != "") { json = json.Substring(0, json.Length - 1); } json = "{result:[" + json + "]}"; context.Response.Write(json); context.Response.End(); return; } } } #endregion }