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