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 int AwardInsertOrUpdate(Member_ERNIE_Award model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand(AwardSQLInsertOrUpdate);
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@ERNIE_id", model.ERNIE_id);
cmd.AddParam("@Award_class", model.Award_class);
cmd.AddParam("@Award_title", model.Award_title);
cmd.AddParam("@Award_num", model.Award_num);
cmd.AddParam("@Award_type", model.Award_type);
cmd.AddParam("@Award_Get_Num", model.Award_Get_Num);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}
public static int ERNIEEditAwardInfo(Member_ERNIE_Award actinfo)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalMemberERNIED(sql);
int result = internalData.AwardInsertOrUpdate(actinfo);
return(result);
}
catch
{
throw;
}
}
}
public static Member_ERNIE_Award ERNIEAwardget(int actid, int topclass)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalMemberERNIED(sql);
Member_ERNIE_Award result = internalData.ERNIEAwardget(actid, topclass);
return(result);
}
catch
{
throw;
}
}
}
public static Member_ERNIE_Award ERNIEGetAwardById(int actid)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalMemberERNIED(sql);
Member_ERNIE_Award result = internalData.ERNIEGetAwardById(actid);
return(result);
}
catch
{
throw;
}
}
}
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;
}
}
}
