/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">RouteComment对象</param>
public int Add(ClassLibrary.Model.RouteComment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("UserName,Nickname,Anonymous,routeID,Grade,Email,Content,Checked,CreatedTime");
strSql.Append(") VALUES (");
strSql.Append("@UserName,@Nickname,@Anonymous,@routeID,@Grade,@Email,@Content,@Checked,@CreatedTime)");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@Nickname", SqlDbType.NVarChar, 60),
new SqlParameter("@Anonymous", SqlDbType.Bit, 1),
new SqlParameter("@routeID", SqlDbType.Int, 4),
new SqlParameter("@Grade", SqlDbType.TinyInt, 1),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@Content", SqlDbType.NVarChar, 200),
new SqlParameter("@Checked", SqlDbType.Bit, 1),
new SqlParameter("@CreatedTime", SqlDbType.DateTime)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Nickname;
parameters[2].Value = model.Anonymous;
parameters[3].Value = model.routeID;
parameters[4].Value = model.Grade;
parameters[5].Value = model.Email;
parameters[6].Value = model.Content;
parameters[7].Value = model.Checked;
parameters[8].Value = model.CreatedTime;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="ID">主键ID</param>
/// <returns>RouteComment对象</returns>
public ClassLibrary.Model.RouteComment GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID,UserName,Nickname,Anonymous,routeID,Grade,Email,Content,Checked,CreatedTime");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary.Model.RouteComment model = new ClassLibrary.Model.RouteComment();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
model.ID = ID;
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["UserName"] != DBNull.Value)
{
model.UserName = Convert.ToString(dt.Rows[0]["UserName"]);
}
if (dt.Rows[0]["Nickname"] != DBNull.Value)
{
model.Nickname = Convert.ToString(dt.Rows[0]["Nickname"]);
}
if (dt.Rows[0]["Anonymous"] != DBNull.Value)
{
model.Anonymous = Convert.ToBoolean(dt.Rows[0]["Anonymous"]);
}
if (dt.Rows[0]["routeID"] != DBNull.Value)
{
model.routeID = Convert.ToInt32(dt.Rows[0]["routeID"]);
}
if (dt.Rows[0]["Grade"] != DBNull.Value)
{
model.Grade = Convert.ToByte(dt.Rows[0]["Grade"]);
}
if (dt.Rows[0]["Email"] != DBNull.Value)
{
model.Email = Convert.ToString(dt.Rows[0]["Email"]);
}
if (dt.Rows[0]["Content"] != DBNull.Value)
{
model.Content = Convert.ToString(dt.Rows[0]["Content"]);
}
if (dt.Rows[0]["Checked"] != DBNull.Value)
{
model.Checked = Convert.ToBoolean(dt.Rows[0]["Checked"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">RouteComment对象</param>
/// <returns>影响行数</returns>
public int Update(ClassLibrary.Model.RouteComment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("UPDATE {0} SET ", table));
strSql.Append("UserName=@UserName,");
strSql.Append("Nickname=@Nickname,");
strSql.Append("Anonymous=@Anonymous,");
strSql.Append("routeID=@routeID,");
strSql.Append("Grade=@Grade,");
strSql.Append("Email=@Email,");
strSql.Append("Content=@Content,");
strSql.Append("Checked=@Checked,");
strSql.Append("CreatedTime=@CreatedTime");
strSql.Append(" WHERE ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@Nickname", SqlDbType.NVarChar, 60),
new SqlParameter("@Anonymous", SqlDbType.Bit, 1),
new SqlParameter("@routeID", SqlDbType.Int, 4),
new SqlParameter("@Grade", SqlDbType.TinyInt, 1),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@Content", SqlDbType.NVarChar, 200),
new SqlParameter("@Checked", SqlDbType.Bit, 1),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.Nickname;
parameters[3].Value = model.Anonymous;
parameters[4].Value = model.routeID;
parameters[5].Value = model.Grade;
parameters[6].Value = model.Email;
parameters[7].Value = model.Content;
parameters[8].Value = model.Checked;
parameters[9].Value = model.CreatedTime;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
//添加评论
private void AddComment()
{
if (!isLogin)
{
Response.Write("<script>alert('仅登录会员可评论...');history.back(-1);</script>");
return;
}
ClassLibrary.Model.RouteComment model = new ClassLibrary.Model.RouteComment();
model.routeID = Convert.ToInt32(Function.GetFormString("routeID"));
model.Nickname = Function.GetFormString("Nickname");
model.Email = HttpUtility.HtmlEncode(Function.GetFormString("Email"));
model.Grade = Convert.ToByte(Function.GetFormString("xing"));
model.Content = HttpUtility.HtmlEncode(Function.GetFormString("Content"));
string pingyin = Function.GetFormString("pingyin");
model.UserName = userName;
if (!string.IsNullOrEmpty(Function.GetFormString("Anonymous")))
{
model.Anonymous = Convert.ToBoolean(Function.GetFormString("Anonymous"));
}
model.Checked = false;
if (Session["ValidateCode"] == null)
{
Response.Write("<script>alert('验证码输入错误，请重新输入。');history.back(-1);</script>");
return;
}
else if (Request.Form["yanz"] != Session["ValidateCode"].ToString())
{
Response.Write("<script>alert('验证码输入错误，请重新输入。');history.back(-1);</script>");
return;
}
DataTable myTable = cmtBLL.GetData("routeID=" + model.routeID);
DateTime lastTime = DateTime.Now;
bool existcomment = false;
foreach (DataRow dr in myTable.Rows)
{
lastTime = DateTime.Parse(dr["CreatedTime"].ToString());
existcomment = true;
break;
}
System.TimeSpan ts = DateTime.Now - lastTime;
if (existcomment && ts.Days == 0 && ts.Hours == 0 && ts.Minutes <= 3)
{
Response.Write("<script>alert('请3分钟后重新输入！');history.back(-1);</script>");
return;
}
if (cmtBLL.Add(model) > 0)
{
Response.Write("<script>alert('评论成功！');location.href='/" + pingyin + "/" + model.routeID + ".html';</script>");
}
else
{
Response.Write("<script>alert('评论失败，数据错误，请重试。。。');location.href='/" + pingyin + "/" + model.routeID + ".html';</script>");
}
}
