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