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