/// <summary>
/// 修改赛跑用户信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCRUser(RC_Users model)
{
string safesql = "";
safesql = " update RC_Users set ";
if (model.OpenID != null && model.OpenID != "")
{
safesql += "[OpenID]='" + model.OpenID + "',";
}
if (model.RaceID != null && model.RaceID != "")
{
safesql += "[RaceID]='" + model.RaceID + "',";
}
if (model.Speed != null && model.Speed != "")
{
safesql += "[Speed]='" + model.Speed + "',";
}
safesql += "[IsDel]=" + (model.IsDel == 1 ? 1 : 0) + ",";
safesql += "[IsWin]=" + (model.IsWin == 1 ? 1 : 0);
safesql += " where id='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加赛跑用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddRCUser(RC_Users model)
{
string sql = @"INSERT INTO [RC_Users]
([ID],[RaceID],[OpenID],[Speed],[IsDel],[IsWin],[AddTime])
VALUES
(@ID,@RaceID,@OpenID,@Speed,@IsDel,@IsWin,@AddTime)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@RaceID", model.RaceID),
new System.Data.SqlClient.SqlParameter("@OpenID", model.OpenID),
new System.Data.SqlClient.SqlParameter("@Speed", model.Speed),
new System.Data.SqlClient.SqlParameter("@IsDel", (model.IsDel == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@IsWin", (model.IsWin == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加或更新用户速度
/// </summary>
void AddNewRace()
{
string nickname = string.Empty;
string speed = string.Empty;
if (Request["nickname"] != null && Request["nickname"] != "")
{
nickname = Common.Common.NoHtml(Request["nickname"].ToString());
}
if (Request["speed"] != null && Request["speed"] != "")
{
speed = Common.Common.NoHtml(Request["speed"].ToString());
}
RC_Users model = new RC_Users();
RC_UsersDAL dal = new RC_UsersDAL();
if (nickname.Trim() != null && nickname.Trim() != "")
{
if (dal.ExistUser(nickname, strID))
{
string uid = string.Empty;
uid = dal.GetRaceUserValue("ID", nickname, strID).ToString();
if (speed.Trim() != null && speed.Trim() != "")
{
if (dal.UpdateUserSpeedByOpenID(uid, speed, strID))
{
Response.Write("{\"success\":\"true\"}");
}
else
{
Response.Write("{\"success\":\"操作失败\"}");
}
}
}
else
{
model.ID = Guid.NewGuid().ToString("N").ToUpper();
model.OpenID = nickname;
if (speed.Trim() != null && speed.Trim() != "")
{
model.Speed = speed;
}
model.IsDel = 0;
model.IsWin = 0;
model.RaceID = strID;
if (dal.AddRCUser(model))
{
Response.Write("{\"success\":\"true\"}");
}
else
{
Response.Write("{\"success\":\"操作失败\"}");
}
}
}
}
