/// <summary>
/// 得到一个对象实体
/// </summary>
public DtCms.Model.AllReviews GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,KindId,ParentId,UserName,Grade,Content,IsLock,AddTime from dt_AllReviews ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
DtCms.Model.AllReviews model = new DtCms.Model.AllReviews();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["KindId"].ToString() != "")
{
model.KindId = int.Parse(ds.Tables[0].Rows[0]["KindId"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "")
{
model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString());
}
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
if (ds.Tables[0].Rows[0]["Grade"].ToString() != "")
{
model.Grade = int.Parse(ds.Tables[0].Rows[0]["Grade"].ToString());
}
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "")
{
model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.AllReviews model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_AllReviews(");
strSql.Append("KindId,ParentId,UserName,Grade,Content,IsLock,AddTime)");
strSql.Append(" values (");
strSql.Append("@KindId,@ParentId,@UserName,@Grade,@Content,@IsLock,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@KindId", SqlDbType.Int, 4),
new SqlParameter("@ParentId", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 30),
new SqlParameter("@Grade", SqlDbType.Int, 4),
new SqlParameter("@Content", SqlDbType.NVarChar, 3000),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.KindId;
parameters[1].Value = model.ParentId;
parameters[2].Value = model.UserName;
parameters[3].Value = model.Grade;
parameters[4].Value = model.Content;
parameters[5].Value = model.IsLock;
parameters[6].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public void ProcessRequest(HttpContext context)
{
string action = context.Request.Params["action"];
if (action == "add")
{
//取得站点配置信息
DtCms.Model.WebSet webset = new DtCms.BLL.WebSet().loadConfig(Utils.GetXmlMapPath("Configpath"));
int _kindId;
int _parentId;
string _code = context.Request.Form["txtCode"];
string _username = context.Request.Form["txtUserName"];
int _grade;
string _content = context.Request.Form["txtContent"];
//获得栏目ID
if (!int.TryParse(context.Request.Params["kindId"] as string, out _kindId))
{
context.Response.Write("{msg:0, msgbox:\"无法找到你所要评论的栏目！\"}");
return;
}
//获得信息ID
if (!int.TryParse(context.Request.Params["parentId"] as string, out _parentId))
{
context.Response.Write("{msg:0, msgbox:\"无法找到你所要评论的信息！\"}");
return;
}
//校检验证码
if (string.IsNullOrEmpty(_code))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入验证码！\"}");
return;
}
if (context.Session["DtCode"] == null)
{
context.Response.Write("{msg:0, msgbox:\"对不起，系统找不到生成的验证码！\"}");
return;
}
if (_code.ToLower() != (context.Session["DtCode"].ToString()).ToLower())
{
context.Response.Write("{msg:0, msgbox:\"您输入的验证码与系统的不一致！\"}");
return;
}
//获得评价星级
if (!int.TryParse(context.Request.Form["hidStar"] as string, out _grade))
{
context.Response.Write("{msg:0, msgbox:\"请对此商品作出评价再提交！\"}");
return;
}
//检查用户名
if (string.IsNullOrEmpty(_username))
{
context.Response.Write("{msg:0, msgbox:\"对不起，请输入您的昵称！\"}");
return;
}
//检查输入的内容
if (string.IsNullOrEmpty(_content))
{
context.Response.Write("{msg:0, msgbox:\"请输入您要评论的信息内容！\"}");
return;
}
//开始写入数据
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
DtCms.Model.AllReviews model = new DtCms.Model.AllReviews();
model.KindId = _kindId;
model.ParentId = _parentId;
model.UserName = _username.Trim();
model.Grade = _grade;
model.Content = Utils.ToHtml(_content);
model.IsLock = webset.IsCheckComment; //评论是否需要审核
model.AddTime = DateTime.Now;
bll.Add(model);
context.Response.Write("{msg:1, msgbox:\"您的评论已提交成功，感谢您的支持！\"}");
return;
}
else if (action == "list")
{
int kindId;
int parentId;
int pageIndex;
int pageSize;
//获得栏目ID
if (!int.TryParse(context.Request.Params["kindId"] as string, out kindId))
{
context.Response.Write("错误提示1，请勿提交非法字符！");
return;
}
//获得信息ID
if (!int.TryParse(context.Request.Params["parentId"] as string, out parentId))
{
context.Response.Write("错误提示2，请勿提交非法字符！");
return;
}
//获得当前页
if (!int.TryParse(context.Request.Params["pageIndex"] as string, out pageIndex))
{
context.Response.Write("错误提示3，请勿提交非法字符！");
return;
}
//获得每页大小
if (!int.TryParse(context.Request.Params["pageSize"] as string, out pageSize))
{
context.Response.Write("错误提示4，请勿提交非法字符！");
return;
}
DtCms.BLL.AllReviews bll = new DtCms.BLL.AllReviews();
DataSet ds = bll.GetPageList(pageSize, pageIndex, "IsLock=0 and KindId=" + kindId + " and ParentId=" + parentId, "AddTime desc");
//如果记录存在
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
context.Response.Write("<div class=\"item\">\n");
context.Response.Write("<div class=\"user\">\n");
context.Response.Write("<span class=\"u-name\">网友：" + dr["UserName"].ToString() + "</span>\n");
context.Response.Write("<span class=\"star star" + dr["Grade"].ToString() + "\"></span>\n");
context.Response.Write("<span class=\"date-ask\">" + dr["AddTime"] + "</span>\n");
context.Response.Write("</div>\n");
context.Response.Write("<dl class=\"answer\">\n");
context.Response.Write("<dt><b></b>评论内容：</dt>\n");
context.Response.Write("<dd><div class=\"content\">" + dr["Content"].ToString() + "</div></dd>\n");
context.Response.Write("</dl>\n");
context.Response.Write("</div>\n");
}
}
else
{
//context.Response.Write("<p>暂无评论信息！</p>");
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.AllReviews model)
{
return(dal.Add(model));
}
