/// <summary>
/// 添加获奖用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddAwardUsers(LuckyAwardUsers model)
{
string sql = @"INSERT INTO [Game_LuckyAwardUsers]
(ID,ActID,AID,OpenID,NickName,Phone,SNCode,SendAward,AddTime,IsDel)
VALUES
(@ID,@ActID,@AID,@OpenID,@NickName,@Phone,@SNCode,@SendAward,@AddTime,@IsDel)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@ActID", model.ActID),
new System.Data.SqlClient.SqlParameter("@AID", model.AID),
new System.Data.SqlClient.SqlParameter("@OpenID", model.OpenID),
new System.Data.SqlClient.SqlParameter("@NickName", model.NickName),
new System.Data.SqlClient.SqlParameter("@Phone", model.Phone),
new System.Data.SqlClient.SqlParameter("@SNCode", model.SNCode),
new System.Data.SqlClient.SqlParameter("@SendAward", model.SendAward),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now),
new System.Data.SqlClient.SqlParameter("@IsDel", (model.IsDel == 1?1:0))
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新获奖用户信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAwardUsers(LuckyAwardUsers model)
{
string safesql = "";
safesql = " update Game_LuckyAwardUsers set ";
if (model.ActID.ToString() != null && model.ActID.ToString() != "")
{
safesql += "[ActID]='" + model.ActID + "',";
}
if (model.AID.ToString() != null && model.AID.ToString() != "")
{
safesql += "[AID]='" + model.AID + "',";
}
if (model.OpenID != null && model.OpenID != "")
{
safesql += "[OpenID]='" + model.OpenID + "',";
}
if (model.NickName != null && model.NickName != "")
{
safesql += "[NickName]='" + model.NickName + "',";
}
if (model.Phone != null && model.Phone != "")
{
safesql += "[Phone]='" + model.Phone + "',";
}
if (model.SNCode != null && model.SNCode != "")
{
safesql += "[SNCode]='" + model.SNCode + "',";
}
safesql += "[SendAward]=" + (model.SendAward == 1 ? 1 : 0) + ",";
safesql += "[IsDel]=" + (model.IsDel == 1 ? 1 : 0);
safesql += " where id='" + model.ID + "' ";
int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加用户信息
/// </summary>
void SaveUser()
{
string sncode = string.Empty;
if (strOpenID.Trim() != null && strOpenID.Trim() != "")
{
if (!AwardUserDal.ExistAwardUser(strOpenID, "", "", "", strActID))
{
LuckyAwardUsers usermodel = new LuckyAwardUsers();
usermodel.ID = Guid.NewGuid().ToString("N").ToUpper();
usermodel.IsDel = 0;
usermodel.OpenID = strOpenID;
usermodel.SendAward = 0;
usermodel.ActID = strActID;
if (AwardUserDal.AddAwardUsers(usermodel))
{
Response.Write("{\"success\":true}");
}
else
{
Response.Write("{\"error\":\"invalid\"}");
}
}
else
{
sncode = AwardUserDal.GetSNCodeByPhone(strOpenID, "", "", strActID);
if (sncode.Trim() != null && sncode.Trim() != "")
{
Response.Write("{\"error\":\"getsn\",\"sn\":\"" + sncode + "\"}");
}
else
{
//Response.Write("{\"error\":\"isdoing\"}");
Response.Write("{\"success\":true}");
}
}
}
else
{
Response.Write("{\"error\":true,\"msg\":\"操作失败，请重新操作\"}"); return;
}
}
void setPhone()
{
string SNCode = string.Empty;
string Phone = string.Empty;
if (Request["sncode"] != null && Request["sncode"] != "")
{
SNCode = Common.Common.NoHtml(Request["sncode"]);
}
if (Request["phone"] != null && Request["phone"] != "")
{
Phone = Common.Common.NoHtml(Request["phone"]);
}
//Response.Write("{\"success\":true}");
if (strOpenID != null && strOpenID != "")
{
LuckyAwardUsers usermodel = new LuckyAwardUsers();
}
else
{
Response.Write("{\"error\":\"操作失败，请重新操作\"}");
}
}
/// <summary>
/// 用户注册
/// </summary>
void saveUserinfo()
{
if (strOpenID != null && strOpenID != "")
{
if (!AwardUserDal.ExistAwardUser(strOpenID, "", "", "", ""))
{
LuckyAwardUsers usermodel = new LuckyAwardUsers();
usermodel.ID = Guid.NewGuid().ToString("N").ToUpper();
usermodel.IsDel = 0;
usermodel.OpenID = strOpenID;
usermodel.SendAward = 0;
usermodel.ActID = strActID;
if (AwardUserDal.AddAwardUsers(usermodel))
{
Random ran = new Random();
int RandKey = ran.Next(0, 6);
string strGuid = Guid.NewGuid().ToString("N");
string strSN = GenerateCheckCode(7);
string strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D04";
switch (RandKey)
{
case 1:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D01";
break;
case 2:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D02";
break;
case 3:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D03";
break;
case 4:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D04";
break;
case 5:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D05";
break;
case 6:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D06";
break;
default:
strCouActID = "AC87CE288FC24F23B7B68CE8F3D93D04";
break;
}
CouponDAL cdal = new CouponDAL();
Model.ACT.Coupon coupon = null;
coupon = new Model.ACT.Coupon()
{
ID = strGuid,
SiteCode = strSiteCode,
SiteActivityID = strCouActID,
OpenID = strOpenID,
CouponCode = strSN,
CouponStatus = 0
};
cdal.InsertInfo(coupon);
Response.Write("{\"success\":\"true\",\"prizetype\":\"" + RandKey.ToString() + "\",\"sn\":\"a" + strSN + "\"}");
}
else
{
Response.Write("{\"error\":\"invalid\"}");
}
}
else
{
//Response.Write("{\"prizetype\":\"null\",\"sn\":\"no\"}");
Response.Write("{\"error\":\"isdoing\"}");
}
}
else
{
Response.Write("{\"prizetype\":\"null\",\"sn\":\"no\"}");
}
}
