public static int ERNIEEditActInfo(Member_ERNIE actinfo) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberERNIED(sql); int result = internalData.InsertOrUpdate(actinfo); return(result); } catch { throw; } } }
public static Member_ERNIE ERNIEGetActById(int actid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberERNIED(sql); Member_ERNIE result = internalData.ERNIEGetActById(actid); return(result); } catch { throw; } } }
public static string ERNIEEditActInfo(Member_ERNIE ERNIEinfo, List <Member_ERNIE_Award> Awardinfo) { try { //修改活动信息 var pro = MemberERNIEData.ERNIEEditActInfo(ERNIEinfo); if (pro != 0) { //获得活动信息 var erniedata = MemberERNIEData.ERNIEGetActById(pro); if (erniedata != null) { //对修改加已限制,如果已完成上线,不能修改奖项,只能修改文字 if (erniedata.Online == 0)//未上线 { if (ERNIEinfo.Id != 0) {//删除所有奖项 MemberERNIEData.ERNIEDelAwardInfo(ERNIEinfo.Id); } int j = 1; for (int i = 0; i < Awardinfo.Count; i++) { if (Awardinfo[i].Award_title != "") { Awardinfo[i].ERNIE_id = pro; Awardinfo[i].Award_class = j; MemberERNIEData.ERNIEEditAwardInfo(Awardinfo[i]); j = j + 1; } } } } } return(JsonConvert.SerializeObject(new { type = 100, msg = pro })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public int InsertOrUpdate(Member_ERNIE model) { var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate); cmd.AddParam("@Id", model.Id); cmd.AddParam("@Com_id", model.Com_id); cmd.AddParam("@title", model.Title); cmd.AddParam("@ERNIE_type", model.ERNIE_type); cmd.AddParam("@ERNIE_star", model.ERNIE_star); cmd.AddParam("@ERNIE_end", model.ERNIE_end); cmd.AddParam("@ERNIE_RateNum", model.ERNIE_RateNum); cmd.AddParam("@ERNIE_Limit", model.ERNIE_Limit); cmd.AddParam("@Limit_Num", model.Limit_Num); cmd.AddParam("@Runstate", model.Runstate); cmd.AddParam("@Remark", model.Remark); var parm = cmd.AddReturnValueParameter("ReturnValue"); cmd.ExecuteNonQuery(); return((int)parm.Value); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string oper = context.Request["oper"].ConvertTo <string>(""); if (oper != "") { if (oper == "getActById") { int actid = context.Request["actid"].ConvertTo <int>(0); var data = PromotionJsonDate.GetActById(actid); context.Response.Write(data); } if (oper == "WhetherEditById") { int actid = context.Request["actid"].ConvertTo <int>(0); int operuserid = context.Request["operuserid"].ConvertTo <int>(0); var data = PromotionJsonDate.WhetherEditByIdJson(actid, operuserid); context.Response.Write(data); } if (oper == "editActinfo") { var title = context.Request["title"].ConvertTo <string>(""); var comid = context.Request["comid"].ConvertTo <int>(0); var Acttype = context.Request["Acttype"].ConvertTo <int>(0); var Money = context.Request["Money"].ConvertTo <int>(0); var Discount = context.Request["Discount"].ConvertTo <int>(0); var CashFull = context.Request["CashFull"].ConvertTo <int>(0); var Cashback = context.Request["Cashback"].ConvertTo <int>(0); var UseOnce = context.Request["UseOnce"].ConvertTo <bool>(); var RepeatIssue = context.Request["RepeatIssue"].ConvertTo <int>(1); var Actstar = context.Request["Actstar"].ConvertTo <DateTime>(); var Actend = context.Request["Actend"].ConvertTo <DateTime>(); var FaceObjects = context.Request["FaceObjects"].ConvertTo <int>(1); var ReturnAct = context.Request["ReturnAct"].ConvertTo <int>(0); var Id = context.Request["actid"].ConvertTo <int>(0); var Runstate = context.Request["runstate"].ConvertTo <bool>(); var Atitle = context.Request["atitle"].ConvertTo <string>(""); var Remark = context.Request["remark"].ConvertTo <string>(""); var Useremark = context.Request["useremark"].ConvertTo <string>(""); var Usetitle = context.Request["usetitle"].ConvertTo <string>(""); var UseChannel = context.Request["UseChannel"].ConvertTo <string>("0"); int createuserid = context.Request["createuserid"].ConvertTo <int>(0); Member_Activity manageuser = new Member_Activity() { Id = Id, Com_id = comid, Title = title, Acttype = Acttype, Money = Money, Discount = Discount, CashFull = CashFull, Cashback = Cashback, UseOnce = UseOnce, RepeatIssue = RepeatIssue, Actstar = Actstar, Actend = Actend, FaceObjects = FaceObjects, ReturnAct = ReturnAct, Runstate = Runstate, Atitle = Atitle, Remark = Remark, Useremark = Useremark, Usetitle = Usetitle, Usechannel = UseChannel, CreateUserId = createuserid, CreateTime = DateTime.Now }; var data = PromotionJsonDate.EditActInfo(manageuser); context.Response.Write(data); } if (oper == "pagelist") { var comid = context.Request["comid"]; var pageindex = context.Request["pageindex"].ConvertTo <int>(0); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); int userid = context.Request["userid"].ConvertTo <int>(0); string state = context.Request["state"].ConvertTo <string>("0,1"); string data = PromotionJsonDate.ActPageList(comid, pageindex, pagesize, userid, state); context.Response.Write(data); } if (oper == "ERNIEgetActById") { int actid = context.Request["actid"].ConvertTo <int>(0); var data = PromotionJsonDate.ERNIEGetActById(actid); context.Response.Write(data); } if (oper == "ERNIEeditActinfo") { var title = context.Request["title"].ConvertTo <string>(""); var comid = context.Request["comid"].ConvertTo <int>(0); var ERNIE_type = context.Request["ERNIE_type"].ConvertTo <int>(1); var ERNIE_RateNum = context.Request["ERNIE_RateNum"].ConvertTo <int>(10000); var ERNIE_Limit = context.Request["ERNIE_Limit"].ConvertTo <int>(0); var Limit_Num = context.Request["Limit_Num"].ConvertTo <int>(0); var runstate = context.Request["Runstate"].ConvertTo <int>(0); var ERNIE_star = context.Request["ERNIE_star"].ConvertTo <DateTime>(); var ERNIE_end = context.Request["ERNIE_end"].ConvertTo <DateTime>(); var Id = context.Request["actid"].ConvertTo <int>(0); var Remark = context.Request["Remark"].ConvertTo <string>(""); var Award_title = context.Request["Award_title"].ConvertTo <string>(""); var Award_num = context.Request["Award_num"].ConvertTo <int>(0); var Award_type = context.Request["Award_type"].ConvertTo <int>(0); var Award_Get_Num = context.Request["Award_Get_Num"].ConvertTo <int>(0); List <Member_ERNIE_Award> Awardlist = new List <Member_ERNIE_Award>(); for (int i = 0; i < 6; i++) { Awardlist.Add(new Member_ERNIE_Award() { Award_title = context.Request["Award_title" + i].ConvertTo <string>(""), Award_num = context.Request["Award_num" + i].ConvertTo <int>(1), Award_type = context.Request["Award_type" + i].ConvertTo <int>(0), Award_Get_Num = context.Request["Award_Get_Num" + i].ConvertTo <int>(0), }); } Member_ERNIE manageuser = new Member_ERNIE() { Id = Id, Com_id = comid, Title = title, ERNIE_type = ERNIE_type, ERNIE_RateNum = ERNIE_RateNum, ERNIE_Limit = ERNIE_Limit, Limit_Num = Limit_Num, Runstate = runstate, ERNIE_star = ERNIE_star, ERNIE_end = ERNIE_end, Remark = Remark }; var data = PromotionJsonDate.ERNIEEditActInfo(manageuser, Awardlist); context.Response.Write(data); } if (oper == "ERNIEActpagelist") { var comid = context.Request["comid"]; var pageindex = context.Request["pageindex"].ConvertTo <int>(0); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); var runstate = context.Request["runstate"].ConvertTo <string>("0,1"); string data = PromotionJsonDate.ERNIEActPageList(comid, pageindex, pagesize, runstate); context.Response.Write(data); } if (oper == "ERNIEgetAwardById") { int actid = context.Request["actid"].ConvertTo <int>(0); var data = PromotionJsonDate.ERNIEGetAwardById(actid); context.Response.Write(data); } if (oper == "ERNIERecordpagelist") { var comid = context.Request["comid"]; var pageindex = context.Request["pageindex"].ConvertTo <int>(0); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); var actid = context.Request["actid"].ConvertTo <int>(0); var ERNIE_type = context.Request["ERNIE_type"].ConvertTo <int>(9); var key = context.Request["key"].ConvertTo <string>(""); string data = PromotionJsonDate.ERNIERecordpagelist(comid, pageindex, pagesize, actid, ERNIE_type, key); context.Response.Write(data); } if (oper == "ERNIERecordedit") { var actid = context.Request["actid"].ConvertTo <int>(0); var data = PromotionJsonDate.ERNIERecordedit(actid); context.Response.Write(data); } if (oper == "ERNIEAwardget") { int actid = context.Request["actid"].ConvertTo <int>(0); int topclass = context.Request["topclass"].ConvertTo <int>(0); var data = PromotionJsonDate.ERNIEAwardget(actid, topclass); context.Response.Write(data); } if (oper == "ERNIEeditAwardinfo") { var Id = context.Request["Id"].ConvertTo <int>(0); var ERNIE_id = context.Request["ERNIE_id"].ConvertTo <int>(0); var Award_class = context.Request["Award_class"].ConvertTo <int>(1); var Award_num = context.Request["Award_num"].ConvertTo <int>(10000); var Award_type = context.Request["Award_type"].ConvertTo <int>(0); var Award_Get_Num = context.Request["Award_Get_Num"].ConvertTo <int>(0); var Award_title = context.Request["Award_title"].ConvertTo <string>(""); Member_ERNIE_Award manageuser = new Member_ERNIE_Award() { Id = Id, ERNIE_id = ERNIE_id, Award_class = Award_class, Award_num = Award_num, Award_type = Award_type, Award_Get_Num = Award_Get_Num, Award_title = Award_title }; var data = PromotionJsonDate.ERNIEEditAwardInfo(manageuser); context.Response.Write(data); } if (oper == "ERNIEAwardpagelist") { var actid = context.Request["actid"].ConvertTo <int>(0); var pageindex = context.Request["pageindex"].ConvertTo <int>(0); var pagesize = context.Request["pagesize"].ConvertTo <int>(10); string data = PromotionJsonDate.ERNIEAwardPageList(actid, pageindex, pagesize); context.Response.Write(data); } if (oper == "ERNIEeditActOnline") { var actid = context.Request["actid"].ConvertTo <int>(0); var data = PromotionJsonDate.ERNIEeditActOnline(actid); context.Response.Write(data); } } }
protected void Page_Load(object sender, EventArgs e) { shijianchuo = DateTime.Now.ToString("yyyyMMddhhmmssfff"); string u = Request.ServerVariables["HTTP_USER_AGENT"]; bool bo = detectmobilebrowser.HttpUserAgent(u); RequestUrl = Request.ServerVariables["SERVER_NAME"].ToLower(); try { //根据域名读取商户ID,如果没有绑定域名直接跳转后台 if (Domain_def.Domain_yanzheng(RequestUrl))//如果符合shop101.etown.cn的格式,则从多微信商户基本信息表中获取comid { //先通过正则表达式获取COMid comid = Int32.Parse(Domain_def.Domain_Huoqu(RequestUrl).ToString()); if (comid == 0) { comid = new WeiXinBasicData().GetWeiXinBasicByDomain(RequestUrl).Comid; } } else { B2b_company_info companyinfo = B2bCompanyData.GetComId(RequestUrl); if (companyinfo != null) { comid = companyinfo.Com_id; } } } catch { errlog += "1,"; } if (comid != 0) { if (bo == false) { if (comid == 101) { // Response.Redirect("http://vctrip.etown.cn/"); } // Response.Redirect("http://shop" + comid + ".etown.cn"); } //获取微信平台端code weixincode = Request["code"].ConvertTo <string>(""); openid = Request["openid"].ConvertTo <string>(""); weixinpass = Request["weixinpass"].ConvertTo <string>(""); GetMemberCard(openid, weixincode, weixinpass, comid);//登陆或得到会员信息 } //得到活动ID actid = Request["actid"].ConvertTo <int>(0); //非班车抽奖活动,则得到最新运行的上线活动id(现在只是班车抽奖传递ntime参数) if (actid == 0 && Request["ntime"].ConvertTo <string>("") == "") { //得到最新运行的,上线的活动ID actid = MemberERNIEData.ERNIETOPgetid(comid); } if (actid == 0) { actstate = 0; } else { actstate = 1; } //抽奖活动 Member_ERNIE erniemodel = new Member_ERNIE(); //奖项 Member_ERNIE_Award Awardmodel = new Member_ERNIE_Award(); var pro = MemberERNIEData.ERNIEGetActById(actid); if (pro != null) { Com_id = pro.Com_id; Title = pro.Title; ERNIE_type = pro.ERNIE_type; //摇奖类型,大转盘 ERNIE_star = pro.ERNIE_star; ERNIE_end = pro.ERNIE_end; ERNIE_RateNum = pro.ERNIE_RateNum; //摇奖基数 ERNIE_Limit = pro.ERNIE_Limit; //摇奖限定,每个账户一次,还是每天一次或多次 Limit_Num = pro.Limit_Num; //摇奖限定次数 Runstate = pro.Runstate; Remark = pro.Remark; } //获取一等奖 var Awardpro1 = MemberERNIEData.ERNIEAwardget(actid, 1); if (Awardpro1 != null) { Award_title1 = Awardpro1.Award_title; Award_num1 = Awardpro1.Award_num; Award_class1 = Awardpro1.Award_class; Id1 = Awardpro1.Id; } //获取二等奖 var Awardpro2 = MemberERNIEData.ERNIEAwardget(actid, 2); if (Awardpro2 != null) { Award_title2 = Awardpro2.Award_title; Award_num2 = Awardpro2.Award_num; Award_class2 = Awardpro2.Award_class; Id1 = Awardpro2.Id; } //获取三等奖 var Awardpro3 = MemberERNIEData.ERNIEAwardget(actid, 3); if (Awardpro3 != null) { Award_title3 = Awardpro3.Award_title; Award_num3 = Awardpro3.Award_num; Award_class3 = Awardpro3.Award_class; Id1 = Awardpro3.Id; } //读取活动信息 var erniedate = MemberERNIEData.ERNIEGetActById(actid); if (erniedate != null) { if (erniedate.Runstate == 1 && erniedate.Online == 1 && erniedate.ERNIE_star < DateTime.Now && erniedate.ERNIE_end.AddDays(1) > DateTime.Now) { var ERNIE_Limit = erniedate.ERNIE_Limit; //抽奖类型 var Limit_Num = erniedate.Limit_Num; //可抽奖次数 //读取用户信息 B2bCrmData crmmodel = new B2bCrmData(); B2b_crm memberinfo = crmmodel.b2b_crmH5(openid, erniedate.Com_id); if (memberinfo != null) { if (memberinfo != null) { ERNIE_Record recordinfo = new ERNIE_Record(); recordinfo.ERNIE_openid = openid; recordinfo.ERNIE_uid = 0; recordinfo.ERNIE_id = actid; var searchdate = MemberERNIEData.SearchChoujiang(recordinfo, ERNIE_Limit);//查询是否抽过奖 if (searchdate < Limit_Num) { if (AccountWeixin != "")//判断登陆状态并有微信号 { choujiangcishu = Limit_Num - searchdate; } else { openid = ""; } } } } } } string ntime = Request["ntime"].ConvertTo <string>(""); string md5ntime = Request["md5ntime"].ConvertTo <string>(""); string tmd5ntime = EncryptionHelper.ToMD5(ntime + "lixh1210", "UTF-8"); if (ntime != "") { if (md5ntime == tmd5ntime) { if (DateTime.Parse(ntime).ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd")) { } else { //非当日抽奖 actstate = 0; } } else { actstate = 0; } } }