/// <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();
}
