/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.article_nav model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_article_nav("); strSql.Append("n_title,n_url,n_state,n_sequence,n_desc)"); strSql.Append(" values ("); strSql.Append("@n_title,@n_url,@n_state,@n_sequence,@n_desc)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@n_title", SqlDbType.NVarChar, 100), new SqlParameter("@n_url", SqlDbType.NVarChar, 100), new SqlParameter("@n_state", SqlDbType.TinyInt, 1), new SqlParameter("@n_sequence", SqlDbType.Int, 4), new SqlParameter("@n_desc", SqlDbType.NText) }; parameters[0].Value = model.n_title; parameters[1].Value = model.n_url; parameters[2].Value = model.n_state; parameters[3].Value = model.n_sequence; parameters[4].Value = model.n_desc; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(string n_title, string n_url, int n_state, int n_sequence, string n_desc) { Model.article_nav model = new Model.article_nav(); model.n_title = n_title; model.n_url = n_url; model.n_state = n_state; model.n_sequence = n_sequence; model.n_desc = n_desc; return(Add(model)); }
private void ShowInfo(int _id) { BLL.article_nav_BLL bll = new BLL.article_nav_BLL(); Model.article_nav model = bll.GetModel(_id); txtNavTitle.Text = model.n_title; rblIsState.SelectedValue = model.n_state.ToString(); txtNavSequence.Text = model.n_sequence.ToString(); txtNavUrl.Text = model.n_url; txtNavDesc.Text = model.n_desc; }
private bool DoAdd() { bool result = true; Model.article_nav model = new Model.article_nav(); BLL.article_nav_BLL bll = new BLL.article_nav_BLL(); model.n_state = int.Parse(rblIsState.SelectedValue); model.n_title = txtNavTitle.Text.Trim(); model.n_sequence = int.Parse(txtNavSequence.Text.Trim()); model.n_url = txtNavUrl.Text.Trim(); model.n_desc = txtNavDesc.Text.Trim(); if (bll.Add(model) < 1) { result = false; } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.article_nav model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_article_nav set "); strSql.Append("n_title=@n_title,"); strSql.Append("n_url=@n_url,"); strSql.Append("n_state=@n_state,"); strSql.Append("n_sequence=@n_sequence,"); strSql.Append("n_desc=@n_desc"); strSql.Append(" where n_id=@n_id"); SqlParameter[] parameters = { new SqlParameter("@n_title", SqlDbType.NVarChar, 100), new SqlParameter("@n_url", SqlDbType.NVarChar, 100), new SqlParameter("@n_state", SqlDbType.TinyInt, 1), new SqlParameter("@n_sequence", SqlDbType.Int, 4), new SqlParameter("@n_desc", SqlDbType.NText), new SqlParameter("@n_id", SqlDbType.Int, 4) }; parameters[0].Value = model.n_title; parameters[1].Value = model.n_url; parameters[2].Value = model.n_state; parameters[3].Value = model.n_sequence; parameters[4].Value = model.n_desc; parameters[5].Value = model.n_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private bool DoEdit(int _id) { bool result = true; BLL.article_nav_BLL bll = new BLL.article_nav_BLL(); Model.article_nav model = bll.GetModel(_id); model.n_state = int.Parse(rblIsState.SelectedValue); model.n_title = txtNavTitle.Text.Trim(); model.n_url = txtNavUrl.Text.Trim(); model.n_sequence = int.Parse(txtNavSequence.Text.Trim()); model.n_desc = txtNavDesc.Text; if (!bll.Update(model)) { result = false; } return(result); }