/// <summary> /// 添加竞猜结果 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddJCScore(JC_Score model) { string sql = @"INSERT INTO [JC_Score] ([ID],[QuizId],[SiteCode],[OpenID],[GuessScore],[AddTime],[State]) VALUES (@ID,@QuizId,@SiteCode,@OpenID,@GuessScore,@AddTime,@State)"; System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", model.ID), new System.Data.SqlClient.SqlParameter("@QuizId", model.QuizId), new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode), new System.Data.SqlClient.SqlParameter("@OpenID", model.OpenID), new System.Data.SqlClient.SqlParameter("@GuessScore", model.GuessScore), new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now), new System.Data.SqlClient.SqlParameter("@State", (model.State == 1?1:0)), }; int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
void SaveJCGScore() { string hscorevalue = string.Empty; string vscorevalue = string.Empty; if (Request["qid"] != null && Request["qid"] != "") { JC_ScoreDAL dal = new JC_ScoreDAL(); if (dal.ExistJCScore(Request["qid"], strOpenID)) { Response.Write("{\"message\":\"您已经操作过了,请不要重复操作!\"}"); } else { JC_Score model = new JC_Score(); model.ID = Guid.NewGuid().ToString("N").ToUpper(); model.OpenID = strOpenID; model.QuizId = Request["qid"].ToString(); if (Request["hscore"] != null && Request["hscore"] != "") { hscorevalue = Request["hscore"]; } else { hscorevalue = "0"; } if (Request["vscore"] != null && Request["vscore"] != "") { vscorevalue = Request["vscore"]; } else { vscorevalue = "0"; } model.GuessScore = hscorevalue + ":" + vscorevalue; model.State = 0; model.SiteCode = Session["strSiteCode"].ToString(); if (dal.AddJCScore(model)) { Response.Write("{\"message\":\"操作成功!\"}"); } else { Response.Write("{\"message\":\"操作失败,请核对后再操作!\"}"); } } } else { Response.Write("{\"message\":\"操作失败,请核对后再操作!\"}"); } Response.End(); }
/// <summary> /// 更新竞猜结果信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateJCScore(JC_Score model) { string safeslq = ""; safeslq = "UPDATE JC_Score SET "; if (model.QuizId != null && model.QuizId != "") { safeslq += "QuizId='" + model.QuizId + "',"; } if (model.SiteCode != null && model.SiteCode != "") { safeslq += "SiteCode='" + model.SiteCode + "',"; } if (model.OpenID != null && model.OpenID != "") { safeslq += "OpenID='" + model.OpenID + "',"; } if (model.GuessScore != null && model.GuessScore != "") { safeslq += "GuessScore='" + model.GuessScore + "',"; } if (model.State.ToString() != null && model.State.ToString() != "") { safeslq += "State=" + (model.State == 1?1:0) + ","; } safeslq += "AddTime='" + DateTime.Now + "' where ID='" + model.ID + "'"; int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
void SaveJCGScore() { string hscorevalue = string.Empty; string vscorevalue = string.Empty; if (strQuizID != null && strQuizID != "") { JC_ScoreDAL dal = new JC_ScoreDAL(); if (!string.IsNullOrEmpty(strOpenID)) { if (dal.ExistJCScore(strQuizID, strOpenID)) { Response.Write("{\"message\":\"不能重复提交!\"}"); } else { JC_Score model = new JC_Score(); model.ID = Guid.NewGuid().ToString("N").ToUpper(); model.OpenID = strOpenID; model.QuizId = strQuizID; string hscore = Common.Common.NoHtml(Request["hscore"]); string vscore = Common.Common.NoHtml(Request["vscore"]); if (hscore != null && hscore != "") { hscorevalue = hscore; } else { hscorevalue = "0"; } if (vscore != null && vscore != "") { vscorevalue = vscore; } else { vscorevalue = "0"; } model.GuessScore = hscorevalue + ":" + vscorevalue; model.State = 0; model.SiteCode = Session["strSiteCode"].ToString(); if (dal.AddJCScore(model)) { Response.Write("{\"message\":\"操作成功!\"}"); } else { Response.Write("{\"message\":\"操作失败!\"}"); } } } else { Response.Write("{\"message\":\"不能重复提交!\"}"); } } else { Response.Write("{\"message\":\"操作失败!\"}"); } Response.End(); }