/// <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\":\"操作失败\"}"); } } } }