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;
}
}
}
