public static string ERNIEeditActOnline(int actid) { MemberERNIEData erniedate = new MemberERNIEData(); int code = 0; //随机码 int ERNIE_RateNum = 0; //摇奖基数 try { var searchpro = MemberERNIEData.ERNIEGetActById(actid); if (searchpro == null) { return(JsonConvert.SerializeObject(new { type = 1, msg = "失败,没有查询到此抽奖活动" })); } if (searchpro.Online == 1) { return(JsonConvert.SerializeObject(new { type = 1, msg = "失败,此活动已经上线" })); } searchpro.Runstate = 1; MemberERNIEData.ERNIEEditActInfo(searchpro);//把活动设定为运行中 //基数也就是范围 基数的数量值,摇奖就在此范围内,最小比例 9千万分之1 ERNIE_RateNum = searchpro.ERNIE_RateNum; //查询此活动的奖项信息 int totalcount = 0; var searchAward = erniedate.ERNIEAwardPageList(actid, 1, 100, out totalcount); if (searchAward == null) { return(JsonConvert.SerializeObject(new { type = 1, msg = "失败,没有查询到此抽奖活动的奖项信息" })); } //生成实体类 ERNIE_Awardcode awardcode = new ERNIE_Awardcode(); Random ra = new Random(); for (int i = 0; i < totalcount; i++) { //循环奖品信息 for (int j = 0; j < searchAward[i].Award_num; j++) //循环奖品数量,插入 { code = ra.Next((98888888 - ERNIE_RateNum), 98888888); awardcode.ERNIE_id = searchAward[i].ERNIE_id; awardcode.Award_id = searchAward[i].Id; awardcode.Award_code = code; var insertAward = MemberERNIEData.InsertAward(awardcode); } } var pro = MemberERNIEData.ERNIEeditActOnline(actid); return(JsonConvert.SerializeObject(new { type = 100, msg = pro })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public static string Huojiangmingdan(int actid, string openid) { var totalcount = 0; try { var actdata = new MemberERNIEData(); var list = actdata.ERNIEHuojiangmingdan(actid); IEnumerable result = ""; if (list != null) { result = from pro in list select new { Id = pro.Id, ERNIE_id = pro.ERNIE_id, phone = pro.Phone == "" ? "****" : pro.Phone.Substring(0, 3) + "****" + pro.Phone.Substring(7), Name = pro.Name == "" ? "**" : pro.Name.Substring(0, 1) + "**", Award_class = MemberERNIEData.ERNIEAwardgetID(pro.Awardid) + "等奖" } } ; return(JsonConvert.SerializeObject(new { type = 100, msg = result })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public static string ERNIEAwardPageList(int actid, int pageindex, int pagesize) { var totalcount = 0; try { var actdata = new MemberERNIEData(); var list = actdata.ERNIEAwardPageList(actid, pageindex, pagesize, out totalcount); IEnumerable result = ""; if (list != null) { result = from pro in list select new { Id = pro.Id, Award_title = pro.Award_title, ERNIE_id = pro.ERNIE_id, Award_class = pro.Award_class, Award_num = pro.Award_num, Award_type = pro.Award_type, Award_Get_Num = pro.Award_Get_Num } } ; return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
protected void Page_Load(object sender, EventArgs e) { nowdate = DateTime.Now.ToString("yyyy-MM-dd"); actid = Request["actid"].ConvertTo <int>(0); var erniedata = MemberERNIEData.ERNIEGetActById(actid); if (erniedata != null) { Online = erniedata.Online; } }
public static string ERNIERecordedit(int actid) { try { var pro = MemberERNIEData.ERNIERecordedit(actid); return(JsonConvert.SerializeObject(new { type = 100, msg = pro })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public static string ERNIEEditAwardInfo(Member_ERNIE_Award ERNIEinfo) { try { var pro = MemberERNIEData.ERNIEEditAwardInfo(ERNIEinfo); return(JsonConvert.SerializeObject(new { type = 100, msg = pro })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public static string ERNIEActPageList(string comid, int pageindex, int pagesize, string runstate = "0,1") { //活动过期 //TimeSpan ts = new TimeSpan(0, 0, 0, 0, 0); //DateTime dt2 = DateTime.Now.Subtract(ts); //string msg= DateTime.Now.ToString() + "-" + ts.Days.ToString() + "天/r/n"; //msg += dt2.ToString(); var totalcount = 0; try { var actdata = new MemberERNIEData(); var list = actdata.ERNIEActPageList(Int32.Parse(comid), pageindex, pagesize, out totalcount, runstate); IEnumerable result = ""; if (list != null) { result = from pro in list select new { Id = pro.Id, Title = pro.Title, ERNIE_type = pro.ERNIE_type == 1 ? "大转盘摇奖" : "其他方式", ERNIE_RateNum = pro.ERNIE_RateNum, ERNIE_Limit = pro.ERNIE_Limit == 0 ? "一次性抽奖活动" : "每天抽奖活动", Limit_Num = pro.Limit_Num, Runstate = pro.Runstate == 0 ? "停止" : "运行中", Com_id = pro.Com_id, ERNIE_star = pro.ERNIE_star, ERNIE_end = pro.ERNIE_end, Remark = pro.Remark, Online = pro.Online, Online_str = pro.Online == 1 ? "已完成" : "" } } ; return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); 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 static string ERNIERecordpagelist(string comid, int pageindex, int pagesize, int actid, int ERNIE_type, string key) { var totalcount = 0; try { var actdata = new MemberERNIEData(); var list = actdata.ERNIERecordpagelist(comid, pageindex, pagesize, actid, ERNIE_type, key, out totalcount); IEnumerable result = ""; if (list != null) { result = from pro in list select new { Id = pro.Id, Title = MemberERNIEData.ERNIEGetActById(pro.ERNIE_id) != null?MemberERNIEData.ERNIEGetActById(pro.ERNIE_id).Title : "", Award = MemberERNIEData.ERNIEGetAwardById(pro.Awardid) != null?MemberERNIEData.ERNIEGetAwardById(pro.Awardid).Award_title : "", Name = pro.Name, ERNIE_id = pro.ERNIE_id, Phone = pro.Phone, ERNIE_code = pro.ERNIE_code, ERNIE_openid = pro.ERNIE_openid, ERNIE_uid = pro.ERNIE_uid, Address = pro.Address, Winning_state = pro.Winning_state, Ip = pro.Ip, ERNIE_time = pro.ERNIE_time, Process_state = pro.Process_state, Awardid = pro.Awardid } } ; return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }
public static string ERNIEZhongjiang(ERNIE_Record Recordinfo) { MemberERNIEData ernieddate = new MemberERNIEData(); string rtstr = "";//返回文字 try { var pror = ernieddate.ERNIERecordInfo(Recordinfo.Id);//查询中奖纪录 if (pror != null) { if (pror.Process_state == 0) { var pro = MemberERNIEData.ERNIEZhongjiang(Recordinfo);//中奖提交 if (pro > 0) { var proernie = MemberERNIEData.ERNIEGetActById(Recordinfo.ERNIE_id);//查询活动 if (proernie != null) { var prow = MemberERNIEData.ERNIEGetAwardById(pror.Awardid);//查询奖品纪录,成功状态修改为中奖奖品级别 if (prow != null) { if (prow.Award_type == 2)//必须是赠送积分的才会自动赠送 { //中奖状态修改,为已处理 var prochuli = MemberERNIEData.ERNIEZhongjiangChuli(Recordinfo.Id); if (prochuli > 0) { //插入积分 MemberIntegralData intdate = new MemberIntegralData(); Member_Integral Intinfo = new Member_Integral() { Id = pror.ERNIE_uid, Comid = proernie.Com_id, Acttype = "add_integral", //操作类型 Money = prow.Award_Get_Num, //交易金额 Admin = proernie.Title, Ip = CommonFunc.GetRealIP(), Ptype = 1, Oid = 0, Remark = "", OrderId = 0, OrderName = "" }; pro = intdate.InsertOrUpdate(Intinfo); //抽奖赠送等积分 B2bcrm_dengjifenlog djflog = new B2bcrm_dengjifenlog { id = 0, crmid = pror.ERNIE_uid, dengjifen = prow.Award_Get_Num, ptype = 1, opertor = "抽奖赠送等积分", opertime = DateTime.Now, orderid = 0, ordername = "抽奖赠送等积分", remark = "抽奖赠送等积分" }; new B2bCrmData().Adjust_dengjifen(djflog, pror.ERNIE_uid, proernie.Com_id, prow.Award_Get_Num); if (pro > 0) { rtstr = "您中奖的" + prow.Award_Get_Num + "元,已经打入您的积分中,请查收!"; } else { rtstr = "中奖信息已经提交成功!"; } } else { rtstr = "中奖信息已经提交成功!"; } } else { rtstr = "中奖信息已经提交成功!"; } } } } } else { return(JsonConvert.SerializeObject(new { rt = -1, msg = "中奖信息提交失败" })); } return(JsonConvert.SerializeObject(new { rt = 1, msg = rtstr })); } else { return(JsonConvert.SerializeObject(new { rt = -1, msg = "中奖信息提交失败!" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { rt = -1, msg = ex.Message })); throw; } }
public static string ERNIEChoujiang(ERNIE_Record recordinfo) { //先产生个随机码超出范围的随机号,后面根据活动设定重新获得随机号,防止没有查询到活动时无返回随机码 Random ra = new Random(); var code = ra.Next(98888888, 99888888); try { //先判断活动 var erniedate = MemberERNIEData.ERNIEGetActById(recordinfo.ERNIE_id); if (erniedate != null) { if (erniedate.Runstate == 1 && erniedate.Online == 1 && erniedate.ERNIE_star < DateTime.Now) { //运行中,在起始时间内 if (erniedate.ERNIE_end.AddDays(1) < DateTime.Now) //超出日期则显示活动已经结束,时间按结束日期的23:59:59秒 { return(JsonConvert.SerializeObject(new { error = "此次活动已经结束", sn = code, success = false })); } code = ra.Next((98888888 - erniedate.ERNIE_RateNum), 98888888); recordinfo.ERNIE_code = code; //赋值随机码 recordinfo.Ip = CommonFunc.GetRealIP(); //记录IP recordinfo.ERNIE_time = DateTime.Now; //记录时间 //读取用户信息 B2bCrmData crmmodel = new B2bCrmData(); B2b_crm memberinfo = crmmodel.b2b_crmH5(recordinfo.ERNIE_openid, erniedate.Com_id); if (memberinfo != null) { recordinfo.ERNIE_uid = memberinfo.Id; //读取用户ID,必须是已关注用户才能抽奖 var ERNIE_Limit = erniedate.ERNIE_Limit; //抽奖频率 var Limit_Num = erniedate.Limit_Num; //抽奖次数 var searchdate = MemberERNIEData.SearchChoujiang(recordinfo, ERNIE_Limit); //查询是否抽过奖 if (searchdate < Limit_Num) { var insertdate = MemberERNIEData.InsertChoujiang(recordinfo);//插入抽奖 //判断是否中奖。可以重复,按指定 var panduanchoujiang = MemberERNIEData.ChoujiangSearchAwardcode(insertdate, recordinfo.ERNIE_id); if (panduanchoujiang > 0) { //如果中奖, //处理中奖,返回中奖级别 var zhongjiang = MemberERNIEData.ZhongjiangAwardcode(insertdate, panduanchoujiang, memberinfo.Id); if (zhongjiang > 0) { return(JsonConvert.SerializeObject(new { error = "", insert_id = insertdate, success = true, prizetype = zhongjiang, sn = code })); } } } else { return(JsonConvert.SerializeObject(new { error = "您已经参加过抽奖活动", sn = code, success = false })); } } else { return(JsonConvert.SerializeObject(new { error = "只有关注微信用户才能参与抽奖", sn = code, success = false })); } } else { return(JsonConvert.SerializeObject(new { error = "活动尚未开始,请稍后再关注", sn = code, success = false })); } } return(JsonConvert.SerializeObject(new { error = "", sn = code, success = false })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { error = "", sn = code, success = false })); throw; } }
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; } } }