public List <newsTypeInfo> GetAll(out int total) { List <newsTypeInfo> list = null; var t = 0; SqlParameter[] param = { new SqlParameter("@totalrow", DbType.Int32) { Direction = ParameterDirection.Output } }; SqlCommand comx; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_newsType_GetAll", param, out comx); if (r != null) { list = new List <newsTypeInfo>(); while (r.Read()) { var info = new newsTypeInfo(); info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); list.Add(info); } r.Close(); r.Dispose(); t = int.Parse(comx.Parameters[0].Value.ToString()); } total = t; return(list); }
public int Add(newsTypeInfo info) { SqlParameter[] param = { new SqlParameter("@name", info.name), new SqlParameter("@link", info.link) }; return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_newsType_Add", param).ToString())); }
public int Update(newsTypeInfo info) { SqlParameter[] param = { new SqlParameter("@id", info.id) , new SqlParameter("@name",info.name), new SqlParameter("@link", info.link) }; return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_newsType_Update", param)); }
public newsTypeInfo GetInfo(int id) { newsTypeInfo info = null; SqlParameter[] param = { new SqlParameter("@id", id) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_newsType_GetById", param); if (r != null) { info = new newsTypeInfo(); while (r.Read()) { info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); } r.Close(); r.Dispose(); } return(info); }