public int Update(Model.DictConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update DictConfig set Title=@Title,Val=@Val,Bid=@Bid,OrderId=@OrderId where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Title", model.Title),
new SqlParameter("@Val", model.Val),
new SqlParameter("@Bid", model.Bid),
new SqlParameter("@OrderId", model.OrderId),
new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(Model.DictConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into DictConfig(Title,Val,Bid,OrderId) values(");
strSql.Append("@Title,@Val,@Bid,@OrderId)");
SqlParameter[] parameters =
{
new SqlParameter("@Title", model.Title),
new SqlParameter("@Val", model.Val),
new SqlParameter("@Bid", model.Bid),
new SqlParameter("@OrderId", model.OrderId),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public Model.DictConfigModel GetModel(int id)
{
StringBuilder sql = new StringBuilder();
sql.Append("select a.* from DictConfig a where a.Id=" + id);
Model.DictConfigModel model = new Model.DictConfigModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
model.Id = Convert.ToInt32(dr["Id"].ToString());
model.Title = dr["Title"].ToString();
model.Val = dr["Val"].ToString();
model.Bid = Convert.ToInt32(dr["Bid"].ToString());
model.OrderId = Convert.ToInt32(dr["OrderId"].ToString());
}
dr.Close();
return(model);
}
