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);
}
}
