/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WalleProject.Model.t_message model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_message(");
strSql.Append("mess_content,mess_date,mess_inpotance,mess_valid,mess_type)");
strSql.Append(" values (");
strSql.Append("@mess_content,@mess_date,@mess_inpotance,@mess_valid,@mess_type)");
MySqlParameter[] parameters =
{
new MySqlParameter("@mess_content", MySqlDbType.Text),
new MySqlParameter("@mess_date", MySqlDbType.DateTime),
new MySqlParameter("@mess_inpotance", MySqlDbType.Int32, 10),
new MySqlParameter("@mess_valid", MySqlDbType.VarChar, 2),
new MySqlParameter("@mess_type", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.mess_content;
parameters[1].Value = model.mess_date;
parameters[2].Value = model.mess_inpotance;
parameters[3].Value = model.mess_valid;
parameters[4].Value = model.mess_type;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_message DataRowToModel(DataRow row)
{
WalleProject.Model.t_message model = new WalleProject.Model.t_message();
if (row != null)
{
if (row["mess_ID"] != null && row["mess_ID"].ToString() != "")
{
model.mess_ID = int.Parse(row["mess_ID"].ToString());
}
if (row["mess_content"] != null)
{
model.mess_content = row["mess_content"].ToString();
}
if (row["mess_date"] != null && row["mess_date"].ToString() != "")
{
model.mess_date = DateTime.Parse(row["mess_date"].ToString());
}
if (row["mess_inpotance"] != null && row["mess_inpotance"].ToString() != "")
{
model.mess_inpotance = int.Parse(row["mess_inpotance"].ToString());
}
if (row["mess_valid"] != null)
{
model.mess_valid = row["mess_valid"].ToString();
}
if (row["mess_type"] != null)
{
model.mess_type = row["mess_type"].ToString();
}
}
return(model);
}
private void ShowInfo(int mess_ID)
{
WalleProject.BLL.t_message bll = new WalleProject.BLL.t_message();
WalleProject.Model.t_message model = bll.GetModel(mess_ID);
this.lblmess_ID.Text = model.mess_ID.ToString();
this.txtmess_content.Text = model.mess_content;
this.txtmess_date.Text = model.mess_date.ToString();
this.txtmess_inpotance.Text = model.mess_inpotance.ToString();
this.txtmess_valid.Text = model.mess_valid;
this.txtmess_type.Text = model.mess_type;
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtmess_content.Text.Trim().Length == 0)
{
strErr += "mess_content不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtmess_date.Text))
{
strErr += "mess_date格式错误！\\n";
}
if (!PageValidate.IsNumber(txtmess_inpotance.Text))
{
strErr += "mess_inpotance格式错误！\\n";
}
if (this.txtmess_valid.Text.Trim().Length == 0)
{
strErr += "mess_valid不能为空！\\n";
}
if (this.txtmess_type.Text.Trim().Length == 0)
{
strErr += "mess_type不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int mess_ID = int.Parse(this.lblmess_ID.Text);
string mess_content = this.txtmess_content.Text;
DateTime mess_date = DateTime.Parse(this.txtmess_date.Text);
int mess_inpotance = int.Parse(this.txtmess_inpotance.Text);
string mess_valid = this.txtmess_valid.Text;
string mess_type = this.txtmess_type.Text;
WalleProject.Model.t_message model = new WalleProject.Model.t_message();
model.mess_ID = mess_ID;
model.mess_content = mess_content;
model.mess_date = mess_date;
model.mess_inpotance = mess_inpotance;
model.mess_valid = mess_valid;
model.mess_type = mess_type;
WalleProject.BLL.t_message bll = new WalleProject.BLL.t_message();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WalleProject.Model.t_message model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_message set ");
strSql.Append("mess_content=@mess_content,");
strSql.Append("mess_date=@mess_date,");
strSql.Append("mess_inpotance=@mess_inpotance,");
strSql.Append("mess_valid=@mess_valid,");
strSql.Append("mess_type=@mess_type");
strSql.Append(" where mess_ID=@mess_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@mess_content", MySqlDbType.Text),
new MySqlParameter("@mess_date", MySqlDbType.DateTime),
new MySqlParameter("@mess_inpotance", MySqlDbType.Int32, 10),
new MySqlParameter("@mess_valid", MySqlDbType.VarChar, 2),
new MySqlParameter("@mess_type", MySqlDbType.VarChar, 20),
new MySqlParameter("@mess_ID", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.mess_content;
parameters[1].Value = model.mess_date;
parameters[2].Value = model.mess_inpotance;
parameters[3].Value = model.mess_valid;
parameters[4].Value = model.mess_type;
parameters[5].Value = model.mess_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_message GetModel(int mess_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select mess_ID,mess_content,mess_date,mess_inpotance,mess_valid,mess_type from t_message ");
strSql.Append(" where mess_ID=@mess_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@mess_ID", MySqlDbType.Int32)
};
parameters[0].Value = mess_ID;
WalleProject.Model.t_message model = new WalleProject.Model.t_message();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
