protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtmessageNo.Text.Trim().Length == 0) { strErr += "messageNo不能为空!\\n"; } if (this.txtemployeeNo.Text.Trim().Length == 0) { strErr += "employeeNo不能为空!\\n"; } if (this.txtmemberNo.Text.Trim().Length == 0) { strErr += "memberNo不能为空!\\n"; } if (!PageValidate.IsDateTime(txtreleaseDate.Text)) { strErr += "releaseDate格式错误!\\n"; } if (this.txtmessageContent.Text.Trim().Length == 0) { strErr += "messageContent不能为空!\\n"; } if (this.txtreplyContent.Text.Trim().Length == 0) { strErr += "replyContent不能为空!\\n"; } if (!PageValidate.IsDateTime(txtreplyDate.Text)) { strErr += "replyDate格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string messageNo = this.txtmessageNo.Text; string employeeNo = this.txtemployeeNo.Text; string memberNo = this.txtmemberNo.Text; DateTime releaseDate = DateTime.Parse(this.txtreleaseDate.Text); string messageContent = this.txtmessageContent.Text; string replyContent = this.txtreplyContent.Text; DateTime replyDate = DateTime.Parse(this.txtreplyDate.Text); BookShop.Model.Message model = new BookShop.Model.Message(); model.messageNo = messageNo; model.employeeNo = employeeNo; model.memberNo = memberNo; model.releaseDate = releaseDate; model.messageContent = messageContent; model.replyContent = replyContent; model.replyDate = replyDate; BookShop.BLL.Message bll = new BookShop.BLL.Message(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(string messageNo) { BookShop.BLL.Message bll = new BookShop.BLL.Message(); BookShop.Model.Message model = bll.GetModel(messageNo); this.lblmessageNo.Text = model.messageNo; this.lblemployeeNo.Text = model.employeeNo; this.lblmemberNo.Text = model.memberNo; this.lblreleaseDate.Text = model.releaseDate.ToString(); this.lblmessageContent.Text = model.messageContent; this.lblreplyContent.Text = model.replyContent; this.lblreplyDate.Text = model.replyDate.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BookShop.Model.Message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Message set "); strSql.Append("employeeNo=@employeeNo,"); strSql.Append("memberNo=@memberNo,"); strSql.Append("releaseDate=@releaseDate,"); strSql.Append("messageContent=@messageContent,"); strSql.Append("replyContent=@replyContent,"); strSql.Append("replyDate=@replyDate"); strSql.Append(" where messageNo=@messageNo "); SqlParameter[] parameters = { new SqlParameter("@employeeNo", SqlDbType.Char, 8), new SqlParameter("@memberNo", SqlDbType.Char, 9), new SqlParameter("@releaseDate", SqlDbType.DateTime), new SqlParameter("@messageContent", SqlDbType.VarChar, 100), new SqlParameter("@replyContent", SqlDbType.VarChar, 100), new SqlParameter("@replyDate", SqlDbType.DateTime), new SqlParameter("@messageNo", SqlDbType.Char, 10) }; parameters[0].Value = model.employeeNo; parameters[1].Value = model.memberNo; parameters[2].Value = model.releaseDate; parameters[3].Value = model.messageContent; parameters[4].Value = model.replyContent; parameters[5].Value = model.replyDate; parameters[6].Value = model.messageNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BookShop.Model.Message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Message("); strSql.Append("messageNo,employeeNo,memberNo,releaseDate,messageContent,replyContent,replyDate)"); strSql.Append(" values ("); strSql.Append("@messageNo,@employeeNo,@memberNo,@releaseDate,@messageContent,@replyContent,@replyDate)"); SqlParameter[] parameters = { new SqlParameter("@messageNo", SqlDbType.Char, 10), new SqlParameter("@employeeNo", SqlDbType.Char, 8), new SqlParameter("@memberNo", SqlDbType.Char, 9), new SqlParameter("@releaseDate", SqlDbType.DateTime), new SqlParameter("@messageContent", SqlDbType.VarChar, 100), new SqlParameter("@replyContent", SqlDbType.VarChar, 100), new SqlParameter("@replyDate", SqlDbType.DateTime) }; parameters[0].Value = model.messageNo; parameters[1].Value = model.employeeNo; parameters[2].Value = model.memberNo; parameters[3].Value = model.releaseDate; parameters[4].Value = model.messageContent; parameters[5].Value = model.replyContent; parameters[6].Value = model.replyDate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BookShop.Model.Message DataRowToModel(DataRow row) { BookShop.Model.Message model = new BookShop.Model.Message(); if (row != null) { if (row["messageNo"] != null) { model.messageNo = row["messageNo"].ToString(); } if (row["employeeNo"] != null) { model.employeeNo = row["employeeNo"].ToString(); } if (row["memberNo"] != null) { model.memberNo = row["memberNo"].ToString(); } if (row["releaseDate"] != null && row["releaseDate"].ToString() != "") { model.releaseDate = DateTime.Parse(row["releaseDate"].ToString()); } if (row["messageContent"] != null) { model.messageContent = row["messageContent"].ToString(); } if (row["replyContent"] != null) { model.replyContent = row["replyContent"].ToString(); } if (row["replyDate"] != null && row["replyDate"].ToString() != "") { model.replyDate = DateTime.Parse(row["replyDate"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public BookShop.Model.Message GetModel(string messageNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 messageNo,employeeNo,memberNo,releaseDate,messageContent,replyContent,replyDate from Message "); strSql.Append(" where messageNo=@messageNo "); SqlParameter[] parameters = { new SqlParameter("@messageNo", SqlDbType.Char, 10) }; parameters[0].Value = messageNo; BookShop.Model.Message model = new BookShop.Model.Message(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }