public bool Add(M_Review model)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("ModelType", SqlDbType.TinyInt), new SqlParameter("InfoId", SqlDbType.NVarChar), new SqlParameter("ReviewTitle", SqlDbType.NVarChar), new SqlParameter("IsArgue", SqlDbType.Bit), new SqlParameter("IsSquare", SqlDbType.TinyInt), new SqlParameter("BrarNum", SqlDbType.Int), new SqlParameter("FightNum", SqlDbType.Int), new SqlParameter("IsElite", SqlDbType.Bit), new SqlParameter("ReviewContent", SqlDbType.NText), new SqlParameter("ReviewTime", SqlDbType.DateTime), new SqlParameter("UserNum", SqlDbType.NVarChar), new SqlParameter("ReviewIP", SqlDbType.NVarChar), new SqlParameter("IsCheck", SqlDbType.Bit) };
commandParameters[0].Value = model.ModelType;
commandParameters[1].Value = model.InfoId;
commandParameters[2].Value = model.ReviewTitle;
commandParameters[3].Value = model.IsArgue;
commandParameters[4].Value = model.IsSquare;
commandParameters[5].Value = model.BrarNum;
commandParameters[6].Value = model.FightNum;
commandParameters[7].Value = model.IsElite;
commandParameters[8].Value = model.ReviewContent;
commandParameters[9].Value = model.ReviewTime;
commandParameters[10].Value = model.UserNum;
commandParameters[11].Value = model.ReviewIP;
commandParameters[12].Value = model.IsCheck;
return (SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_Review_Add", commandParameters) > 0);
}
public bool Add(M_Review model)
{
return this.iReview.Add(model);
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetNoStore();
bool reviewIsCheck = false;
B_Review bll = new B_Review();
B_SiteInfo SiteBll = new B_SiteInfo();
B_User bllUser = new B_User();
M_Review model = new M_Review();
M_User userModel = null;
if (Request.Form["txtIsLogin"] == "False")
{
if (Request.Form["btnSubmit"] == "登录")
{
bool flaglogin = true;
string msgBox = string.Empty;
if (Request.Form["UserName"].ToString().Trim() == "")
{
flaglogin = false;
msgBox = "<script>alert('用户名必须填写');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
else if (Request.Form["userPwd"].ToString().Trim() == "")
{
flaglogin = false;
msgBox = "<script>alert('密码必须填写');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
if (flaglogin)
{
ltMsg.Text = "";
string logName = "";
string pwd = "";
string cookieType = "";
logName = Function.UrlDecode(Request.Form["UserName"].ToString());
pwd = Function.MD5Encrypt(Request.Form["userPwd"].ToString());
cookieType = "No";
if ((!string.IsNullOrEmpty(logName)) && (!string.IsNullOrEmpty(pwd)))
{
B_SiteInfo siteInfo = new B_SiteInfo();
M_Site siteModel = siteInfo.GetSiteModel();
M_User modelLogin = bllUser.GetUser(logName);
if (modelLogin != null && siteModel != null)
{
//用户登录
bool flag = bllUser.Login(logName, pwd);
if (flag && (!string.IsNullOrEmpty(cookieType)))
{
HttpCookie cookie = new HttpCookie("User");
cookie["uId"] = modelLogin.UserID.ToString();
cookie["logN"] = modelLogin.LogName;
cookie["pd"] = modelLogin.UserPwd;
switch (cookieType)
{
case "onehour":
cookie.Expires = DateTime.Now.AddHours(1);
break;
case "oneday":
cookie.Expires = DateTime.Now.AddDays(1);
break;
case "oneweek":
cookie.Expires = DateTime.Now.AddDays(7);
break;
case "onemounth":
cookie.Expires = DateTime.Now.AddMonths(1);
break;
case "oneyear":
cookie.Expires = DateTime.Now.AddYears(1);
break;
case "No":
default:
break;
}
Response.Cookies.Add(cookie);
string lastLoginIP = string.Empty;
if (Request.UserHostAddress != null)
{
lastLoginIP = Request.UserHostAddress;
}
DateTime currLoginTime = DateTime.Now;
DateTime oldLoginTime = modelLogin.LastLoginTime;
bllUser.LoginSuccess(modelLogin.UserID, lastLoginIP, currLoginTime);
if (oldLoginTime.Date != currLoginTime.Date)
{
B_Money moneyBll = new B_Money();
moneyBll.Integral(siteModel.LoginScore, modelLogin.UserID);
}
msgBox = "<script>alert('登录成功');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
else
{
msgBox = "<script>alert('登录失败');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
}
else
{
msgBox = "<script>alert('登录失败');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
}
}
ltMsg.Text = msgBox;
}
else
{
if (Request.Form["hidNoName"].ToString() == "False")
{
ltMsg.Text = "<script>alert('本系统设置了不允许匿名评论，请先登录');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
else
{
//根据栏目的设置,对论评论审核进行初始化
if (Request.Form["hidColCommentSet"].ToString() == "True")
reviewIsCheck = false;
else
reviewIsCheck = true;
string validateCode = string.Empty;
string flag = Request.Form["hidValidate"];
if (flag == "True")
{
if (Session["ValidateCode"] == null)
{
Response.Write("<script language='javascript'>alert('你在登陆页面停留的时间过长，验证码已经失效');window.history.back();</script>");
Response.End();
}
//验证码错误
validateCode = Session["ValidateCode"].ToString().ToLower();
if (validateCode.ToLower() != Request.Form["txtValidate"].ToString().Trim().ToLower())
{
Response.Write("<script language='javascript'>alert('验证码错误');window.history.back();</script>");
Response.End();
}
}
if (bllUser.IsLogin())
{
M_User loginUserModel = bllUser.GetCookie();
userModel = bllUser.GetUser(loginUserModel.LogName);
}
model.ModelType = int.Parse(Request.Form["hidModeType"].ToString());
model.InfoId = Request.Form["hidNewsId"].ToString();
if (Request.Form["hidUserGroupViewIsCheck"] == "True" && bllUser.IsLogin())
reviewIsCheck = true;
model.IsCheck = reviewIsCheck;
model.ReviewTitle = ""; //评论标题
model.IsArgue = false;
model.IsSquare = 3;
model.BrarNum = 0;
model.FightNum = 0;
model.IsElite = false;
model.ReviewContent = SiteBll.GetFiltering(Request.Form["txtContent"].ToString()); //评论内容
model.ReviewTime = DateTime.Now; //评论时间
if (bllUser.IsLogin()) //是否是登录用户
model.UserNum = userModel.UserID.ToString();
else
model.UserNum = "0";
model.ReviewIP = Request.UserHostAddress; //评论用户的IP
if (bll.Add(model))
{
if (!reviewIsCheck)
ltMsg.Text = "<script>alert('评论成功，将在审核后显示出来');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
else
ltMsg.Text = "<script>window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
}
}
}
else
{
if (Request.Form["hidNoName"].ToString() == "False")
{
ltMsg.Text = "<script>alert('本系统设置了不允许匿名评论，请先登录');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
else
{
//根据栏目的设置,对论评论审核进行初始化
if (Request.Form["hidColCommentSet"].ToString() == "True")
reviewIsCheck = false;
else
reviewIsCheck = true;
string validateCode = string.Empty;
string flag = Request.Form["hidValidate"];
if (flag == "True")
{
if (Session["ValidateCode"] == null)
{
Response.Write("<script language='javascript'>alert('你在登陆页面停留的时间过长，验证码已经失效');window.history.back();</script>");
Response.End();
}
//验证码错误
validateCode = Session["ValidateCode"].ToString().ToLower();
if (validateCode.ToLower() != Request.Form["txtValidate"].ToString().Trim().ToLower())
{
Response.Write("<script language='javascript'>alert('验证码错误');window.history.back();</script>");
Response.End();
}
}
if (bllUser.IsLogin())
{
M_User loginUserModel = bllUser.GetCookie();
userModel = bllUser.GetUser(loginUserModel.LogName);
}
model.ModelType = int.Parse(Request.Form["hidModeType"].ToString());
model.InfoId = Request.Form["hidNewsId"].ToString();
if (Request.Form["hidUserGroupViewIsCheck"] == "True" && bllUser.IsLogin())
reviewIsCheck = true;
model.IsCheck = reviewIsCheck;
model.ReviewTitle = ""; //评论标题
model.IsArgue = false;
model.IsSquare = 3;
model.BrarNum = 0;
model.FightNum = 0;
model.IsElite = false;
model.ReviewContent = SiteBll.GetFiltering(Request.Form["txtContent"].ToString()); //评论内容
model.ReviewTime = DateTime.Now; //评论时间
if (bllUser.IsLogin()) //是否是登录用户
model.UserNum = userModel.UserID.ToString();
else
model.UserNum = "0";
model.ReviewIP = Request.UserHostAddress; //评论用户的IP
if (bll.Add(model))
{
if (!reviewIsCheck)
ltMsg.Text = "<script>alert('评论成功，将在审核后显示出来');window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
else
ltMsg.Text = "<script>window.location.href('" + Request.UrlReferrer.ToString() + "');</script>";
}
}
}
}
public M_Review GetModel(int ID)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@TypeId", SqlDbType.Int, 4) };
commandParameters[0].Value = ID;
commandParameters[1].Value = 4;
M_Review review = new M_Review();
DataSet set = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_Review_Oper", commandParameters);
review.Id = ID;
if (set.Tables[0].Rows.Count > 0)
{
if (set.Tables[0].Rows[0]["ModelType"].ToString() != "")
{
review.ModelType = int.Parse(set.Tables[0].Rows[0]["ModelType"].ToString());
}
review.InfoId = set.Tables[0].Rows[0]["InfoId"].ToString();
review.ReviewTitle = set.Tables[0].Rows[0]["ReviewTitle"].ToString();
if (set.Tables[0].Rows[0]["IsArgue"].ToString() != "")
{
if ((set.Tables[0].Rows[0]["IsArgue"].ToString() == "1") || (set.Tables[0].Rows[0]["IsArgue"].ToString().ToLower() == "true"))
{
review.IsArgue = true;
}
else
{
review.IsArgue = false;
}
}
if (set.Tables[0].Rows[0]["IsSquare"].ToString() != "")
{
review.IsSquare = int.Parse(set.Tables[0].Rows[0]["IsSquare"].ToString());
}
if (set.Tables[0].Rows[0]["BrarNum"].ToString() != "")
{
review.BrarNum = int.Parse(set.Tables[0].Rows[0]["BrarNum"].ToString());
}
if (set.Tables[0].Rows[0]["FightNum"].ToString() != "")
{
review.FightNum = int.Parse(set.Tables[0].Rows[0]["FightNum"].ToString());
}
if (set.Tables[0].Rows[0]["IsElite"].ToString() != "")
{
if ((set.Tables[0].Rows[0]["IsElite"].ToString() == "1") || (set.Tables[0].Rows[0]["IsElite"].ToString().ToLower() == "true"))
{
review.IsElite = true;
}
else
{
review.IsElite = false;
}
}
review.ReviewContent = set.Tables[0].Rows[0]["ReviewContent"].ToString();
if (set.Tables[0].Rows[0]["ReviewTime"].ToString() != "")
{
review.ReviewTime = DateTime.Parse(set.Tables[0].Rows[0]["ReviewTime"].ToString());
}
review.UserNum = set.Tables[0].Rows[0]["UserNum"].ToString();
review.ReviewIP = set.Tables[0].Rows[0]["ReviewIP"].ToString();
if (set.Tables[0].Rows[0]["IsCheck"].ToString() != "")
{
if ((set.Tables[0].Rows[0]["IsCheck"].ToString() == "1") || (set.Tables[0].Rows[0]["IsCheck"].ToString().ToLower() == "true"))
{
review.IsCheck = true;
return review;
}
review.IsCheck = false;
}
return review;
}
return null;
}
public void UpdateIsCheck(int id)
{
bool flag = true;
M_Review review = new M_Review();
if (this.GetModel(id).IsCheck)
{
flag = false;
}
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@TypeId", SqlDbType.Int, 4), new SqlParameter("@IsCheck", SqlDbType.Bit) };
commandParameters[0].Value = id;
commandParameters[1].Value = 3;
commandParameters[2].Value = flag;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_Review_Oper", commandParameters);
}
