/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WalleProject.Model.t_news model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_news(");
strSql.Append("new_title,new_creatDate,new_cate_id,new_pic_id,new_content,new_valid)");
strSql.Append(" values (");
strSql.Append("@new_title,@new_creatDate,@new_cate_id,@new_pic_id,@new_content,@new_valid)");
MySqlParameter[] parameters =
{
new MySqlParameter("@new_title", MySqlDbType.VarChar, 20),
new MySqlParameter("@new_creatDate", MySqlDbType.DateTime),
new MySqlParameter("@new_cate_id", MySqlDbType.Int32, 10),
new MySqlParameter("@new_pic_id", MySqlDbType.Int32, 10),
new MySqlParameter("@new_content", MySqlDbType.Text),
new MySqlParameter("@new_valid", MySqlDbType.VarChar, 2)
};
parameters[0].Value = model.new_title;
parameters[1].Value = model.new_creatDate;
parameters[2].Value = model.new_cate_id;
parameters[3].Value = model.new_pic_id;
parameters[4].Value = model.new_content;
parameters[5].Value = model.new_valid;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtnew_title.Text.Trim().Length == 0)
{
strErr += "新闻标题不能为空！\\n";
}
if (!PageValidate.IsNumber(txtnew_cate_id.SelectedValue))
{
strErr += "新闻类型格式错误！\\n";
}
if (this.content.InnerHtml.Trim().Length == 0)
{
strErr += "内容不能为空！\\n";
}
if (this.txtnew_valid.Text.Trim().Length == 0)
{
strErr += "不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string new_title = this.txtnew_title.Text;
int new_cate_id = int.Parse(this.txtnew_cate_id.SelectedValue);
string new_content = this.content.InnerHtml;
string new_valid = this.txtnew_valid.Text;
WalleProject.Model.t_news model = new WalleProject.Model.t_news();
model.new_title = new_title;
model.new_cate_id = new_cate_id;
HttpPostedFile file = fup_com_img.PostedFile;
if (file != null)
{
model.new_pic_id = UploadFile(file);
}
else
{
if (!PageValidate.IsNumber(lb_i_img.SelectedValue))
{
strErr += "图片没有选择！\\n";
MessageBox.Show(this, strErr);
return;
}
int new_pic_id = int.Parse(this.lb_i_img.SelectedValue) == -1?1:int.Parse(this.lb_i_img.SelectedValue);
}
model.new_content = new_content;
model.new_valid = new_valid;
model.new_creatDate = DateTime.Now;
WalleProject.BLL.t_news bll = new WalleProject.BLL.t_news();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "NewsManage.aspx");
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtEditnew_title.Text.Trim().Length == 0)
{
strErr += "new_title不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtEditnew_creatDate.Text))
{
strErr += "new_creatDate格式错误！\\n";
}
if (!PageValidate.IsNumber(txtEditnew_cate_id.Text))
{
strErr += "new_cate_id格式错误！\\n";
}
if (!PageValidate.IsNumber(txtEditnew_pic_id.Text))
{
strErr += "new_pic_id格式错误！\\n";
}
if (this.txtEditnew_content.Text.Trim().Length == 0)
{
strErr += "new_content不能为空！\\n";
}
if (this.txtEditnew_valid.Text.Trim().Length == 0)
{
strErr += "new_valid不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string new_title = this.txtEditnew_title.Text;
DateTime new_creatDate = DateTime.Parse(this.txtEditnew_creatDate.Text);
int new_cate_id = int.Parse(this.txtEditnew_cate_id.Text);
int new_pic_id = int.Parse(this.txtEditnew_pic_id.Text);
string new_content = this.txtEditnew_content.Text;
string new_valid = this.txtEditnew_valid.Text;
int new_ID = int.Parse(this.lblnew_ID.Text);
WalleProject.Model.t_news model = new WalleProject.Model.t_news();
model.new_title = new_title;
model.new_creatDate = new_creatDate;
model.new_cate_id = new_cate_id;
model.new_pic_id = new_pic_id;
model.new_content = new_content;
model.new_valid = new_valid;
model.new_ID = new_ID;
WalleProject.BLL.t_news bll = new WalleProject.BLL.t_news();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
private void ShowInfo(int new_ID)
{
WalleProject.BLL.t_news bll = new WalleProject.BLL.t_news();
WalleProject.Model.t_news model = bll.GetModel(new_ID);
this.lblnew_title.Text = model.new_title;
this.lblnew_creatDate.Text = model.new_creatDate.ToString();
this.lblnew_cate_id.Text = model.new_cate_id.ToString();
this.lblnew_pic_id.Text = model.new_pic_id.ToString();
this.lblnew_content.Text = Server.HtmlDecode(PageValidate.Decode(model.new_content));
this.lblnew_valid.Text = model.new_valid;
this.lblnew_ID.Text = model.new_ID.ToString();
}
private void ShowInfo(int new_ID)
{
WalleProject.BLL.t_news bll = new WalleProject.BLL.t_news();
WalleProject.Model.t_news model = bll.GetModel(new_ID);
this.txtEditnew_title.Text = model.new_title;
this.txtEditnew_creatDate.Text = model.new_creatDate.ToString();
this.txtEditnew_cate_id.Text = model.new_cate_id.ToString();
this.txtEditnew_pic_id.Text = model.new_pic_id.ToString();
this.txtEditnew_content.Text = model.new_content;
this.txtEditnew_valid.Text = model.new_valid;
this.lblnew_ID.Text = model.new_ID.ToString();
}
private void ShowEditInfo(int new_ID)
{
WalleProject.BLL.t_news bll = new WalleProject.BLL.t_news();
WalleProject.Model.t_news model = bll.GetModel(new_ID);
this.txtEditnew_title.Text = model.new_title;
this.txtEditnew_cate_id.Text = model.new_cate_id.ToString();
this.lb_i_img.SelectedValue = model.new_pic_id.ToString();
this.content.InnerHtml = Server.HtmlDecode(PageValidate.Decode(model.new_content));
this.txtEditnew_valid.Text = model.new_valid;
this.img_i_mo.Src = new BLL.t_picture().GetModel(int.Parse(model.new_pic_id.ToString())).pic_valid;
this.imgID.Text = model.new_pic_id.ToString();
Label1.Text = model.new_ID.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WalleProject.Model.t_news model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_news set ");
strSql.Append("new_title=@new_title,");
strSql.Append("new_creatDate=@new_creatDate,");
strSql.Append("new_cate_id=@new_cate_id,");
strSql.Append("new_pic_id=@new_pic_id,");
strSql.Append("new_content=@new_content,");
strSql.Append("new_valid=@new_valid");
strSql.Append(" where new_ID=@new_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@new_title", MySqlDbType.VarChar, 20),
new MySqlParameter("@new_creatDate", MySqlDbType.DateTime),
new MySqlParameter("@new_cate_id", MySqlDbType.Int32, 10),
new MySqlParameter("@new_pic_id", MySqlDbType.Int32, 10),
new MySqlParameter("@new_content", MySqlDbType.Text),
new MySqlParameter("@new_valid", MySqlDbType.VarChar, 2),
new MySqlParameter("@new_ID", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.new_title;
parameters[1].Value = model.new_creatDate;
parameters[2].Value = model.new_cate_id;
parameters[3].Value = model.new_pic_id;
parameters[4].Value = model.new_content;
parameters[5].Value = model.new_valid;
parameters[6].Value = model.new_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_news DataRowToModel(DataRow row)
{
WalleProject.Model.t_news model = new WalleProject.Model.t_news();
if (row != null)
{
if (row["new_title"] != null)
{
model.new_title = row["new_title"].ToString();
}
if (row["new_creatDate"] != null && row["new_creatDate"].ToString() != "")
{
model.new_creatDate = DateTime.Parse(row["new_creatDate"].ToString());
}
if (row["new_cate_id"] != null && row["new_cate_id"].ToString() != "")
{
model.new_cate_id = int.Parse(row["new_cate_id"].ToString());
}
if (row["new_pic_id"] != null && row["new_pic_id"].ToString() != "")
{
model.new_pic_id = int.Parse(row["new_pic_id"].ToString());
}
if (row["new_content"] != null)
{
model.new_content = row["new_content"].ToString();
}
if (row["new_valid"] != null)
{
model.new_valid = row["new_valid"].ToString();
}
if (row["new_ID"] != null && row["new_ID"].ToString() != "")
{
model.new_ID = int.Parse(row["new_ID"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WalleProject.Model.t_news GetModel(int new_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select new_title,new_creatDate,new_cate_id,new_pic_id,new_content,new_valid,new_ID from t_news ");
strSql.Append(" where new_ID=@new_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@new_ID", MySqlDbType.Int32)
};
parameters[0].Value = new_ID;
WalleProject.Model.t_news model = new WalleProject.Model.t_news();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体(三个表连接)
/// </summary>
public WalleProject.Model.t_news GetNewsModel(int new_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select * from t_news inner join t_newscategory on t_news.new_cate_id=t_newscategory.newc_ID
inner join t_picture on t_news.new_pic_id=t_picture.pic_ID ");
strSql.Append(" where new_ID=@new_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@new_ID", MySqlDbType.Int32)
};
parameters[0].Value = new_ID;
WalleProject.Model.t_news model = new WalleProject.Model.t_news();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
if (row != null)
{
if (row["new_title"] != null)
{
model.new_title = row["new_title"].ToString();
}
if (row["new_creatDate"] != null && row["new_creatDate"].ToString() != "")
{
model.new_creatDate = DateTime.Parse(row["new_creatDate"].ToString());
}
if (row["new_cate_id"] != null && row["new_cate_id"].ToString() != "")
{
model.new_cate_id = int.Parse(row["new_cate_id"].ToString());
}
if (row["new_pic_id"] != null && row["new_pic_id"].ToString() != "")
{
model.new_pic_id = int.Parse(row["new_pic_id"].ToString());
}
if (row["new_content"] != null)
{
model.new_content = row["new_content"].ToString();
}
if (row["new_valid"] != null)
{
model.new_valid = row["new_valid"].ToString();
}
if (row["new_ID"] != null && row["new_ID"].ToString() != "")
{
model.new_ID = int.Parse(row["new_ID"].ToString());
}
if (row["newc_name"] != null && row["new_ID"].ToString() != "")
{
model.newscategory.newc_name = row["newc_name"].ToString();
}
if (row["pic_valid"] != null && row["new_ID"].ToString() != "")
{
model.picture.pic_valid = row["pic_valid"].ToString();
}
}
return(model);
}
else
{
return(null);
}
}
