protected void btnSubmit_Click(object sender, EventArgs e) { try { Model_UserOrder_Comment commet = new Model_UserOrder_Comment(); BLL_UserOrder_Comment bll = new BLL_UserOrder_Comment(); commet.comment_id = Guid.NewGuid().ToString(); commet.create_time = DateTime.Now; if (pfunction.FilterKeyWords(this.txtcomment.Value)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('评论内容存在敏感词汇,请重新填写。',{icon:2,time:2000});</script>"); return; } else { commet.comment_content = txtcomment.Value.Trim(); } commet.comment_evaluate = Convert.ToDecimal(hidscore.Value); commet.order_num = order_num; commet.user_id = FloginUser.UserId; if (bll.Add(commet)) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.msg('评论成功',{time:1000,icon:1},function(){window.parent.loadData();parent.layer.close(index);});", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.msg('评论失败',{time:2000,icon:2});", true); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.msg('" + ex + "',{time:5000,icon:2});", true); } }
public bool Add(Model_UserOrder_Comment model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into UserOrder_Comment("); builder.Append("comment_id,order_num,user_id,comment_content,comment_evaluate,create_time,remark)"); builder.Append(" values ("); builder.Append("@comment_id,@order_num,@user_id,@comment_content,@comment_evaluate,@create_time,@remark)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@comment_id", SqlDbType.VarChar, 0x24), new SqlParameter("@order_num", SqlDbType.VarChar, 50), new SqlParameter("@user_id", SqlDbType.VarChar, 0x24), new SqlParameter("@comment_content", SqlDbType.VarChar, 0x7d0), new SqlParameter("@comment_evaluate", SqlDbType.Decimal, 5), new SqlParameter("@create_time", SqlDbType.DateTime), new SqlParameter("@remark", SqlDbType.VarChar, 0x7d0) }; cmdParms[0].Value = model.comment_id; cmdParms[1].Value = model.order_num; cmdParms[2].Value = model.user_id; cmdParms[3].Value = model.comment_content; cmdParms[4].Value = model.comment_evaluate; cmdParms[5].Value = model.create_time; cmdParms[6].Value = model.remark; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_UserOrder_Comment> DataTableToList(DataTable dt) { List <Model_UserOrder_Comment> list = new List <Model_UserOrder_Comment>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_UserOrder_Comment item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Update(Model_UserOrder_Comment model) { StringBuilder builder = new StringBuilder(); builder.Append("update UserOrder_Comment set "); builder.Append("order_num=@order_num,"); builder.Append("user_id=@user_id,"); builder.Append("comment_content=@comment_content,"); builder.Append("comment_evaluate=@comment_evaluate,"); builder.Append("create_time=@create_time,"); builder.Append("remark=@remark"); builder.Append(" where comment_id=@comment_id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@order_num", SqlDbType.VarChar, 50), new SqlParameter("@user_id", SqlDbType.VarChar, 0x24), new SqlParameter("@comment_content", SqlDbType.VarChar, 0x7d0), new SqlParameter("@comment_evaluate", SqlDbType.Decimal, 5), new SqlParameter("@create_time", SqlDbType.DateTime), new SqlParameter("@remark", SqlDbType.VarChar, 0x7d0), new SqlParameter("@comment_id", SqlDbType.VarChar, 0x24) }; cmdParms[0].Value = model.order_num; cmdParms[1].Value = model.user_id; cmdParms[2].Value = model.comment_content; cmdParms[3].Value = model.comment_evaluate; cmdParms[4].Value = model.create_time; cmdParms[5].Value = model.remark; cmdParms[6].Value = model.comment_id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_UserOrder_Comment DataRowToModel(DataRow row) { Model_UserOrder_Comment comment = new Model_UserOrder_Comment(); if (row != null) { if (row["comment_id"] != null) { comment.comment_id = row["comment_id"].ToString(); } if (row["order_num"] != null) { comment.order_num = row["order_num"].ToString(); } if (row["user_id"] != null) { comment.user_id = row["user_id"].ToString(); } if (row["comment_content"] != null) { comment.comment_content = row["comment_content"].ToString(); } if ((row["comment_evaluate"] != null) && (row["comment_evaluate"].ToString() != "")) { comment.comment_evaluate = new decimal?(decimal.Parse(row["comment_evaluate"].ToString())); } if ((row["create_time"] != null) && (row["create_time"].ToString() != "")) { comment.create_time = new DateTime?(DateTime.Parse(row["create_time"].ToString())); } if (row["remark"] != null) { comment.remark = row["remark"].ToString(); } } return(comment); }
public bool Add(Model_UserOrder_Comment model) { return(this.dal.Add(model)); }
public bool Update(Model_UserOrder_Comment model) { return(this.dal.Update(model)); }