public carreerTypeInfo GetInfo(int id) { carreerTypeInfo info = null; SqlParameter[] param = { new SqlParameter("@id", id) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_carreer_Type_GetById", param); if (r != null) { info = new carreerTypeInfo(); while (r.Read()) { info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); info.sort = (object)r["sort"].ToString(); info.description = r["description"].ToString(); info.keyword = r["keyword"].ToString(); } r.Close(); r.Dispose(); } return(info); }
private void AddNewCate() { var info = new carreerTypeInfo(); info.name = txtCategoryname.Text; info.link = "/" + UnicodeUtility.UrlRewriting(info.name) + ".html"; info.sort = int.Parse(txtSort.Text); ServiceFactory.GetInstanceCarreerType().Add(info); }
public int Add(carreerTypeInfo info) { SqlParameter[] param = { new SqlParameter("@name", info.name), new SqlParameter("@link", info.link), new SqlParameter("@sort", info.sort), new SqlParameter("@description", info.description), new SqlParameter("@keyword", info.keyword) }; return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_carreer_Type_Add", param).ToString())); }
public int Update(carreerTypeInfo info) { SqlParameter[] param = { new SqlParameter("@id", info.id) , new SqlParameter("@name",info.name), new SqlParameter("@link", info.link), new SqlParameter("@sort", info.sort), new SqlParameter("@description", info.description), new SqlParameter("@keyword", info.keyword) }; return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_carreer_Type_Update", param)); }
public List <carreerTypeInfo> GetList(int pageIndex, int pageSize, out int total) { List <carreerTypeInfo> list = null; var t = 0; SqlParameter[] param = { new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize), new SqlParameter("@totalrow", DbType.Int32) { Direction = ParameterDirection.Output } }; SqlCommand comx; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_carreer_Type_GetList", param, out comx); if (r != null) { list = new List <carreerTypeInfo>(); while (r.Read()) { var info = new carreerTypeInfo(); info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); info.sort = (object)r["sort"].ToString(); info.description = r["description"].ToString(); info.keyword = r["keyword"].ToString(); list.Add(info); } r.Close(); r.Dispose(); t = int.Parse(comx.Parameters[2].Value.ToString()); } total = t; return(list); }
public List <carreerTypeInfo> GetAll() { List <carreerTypeInfo> list = null; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_carreer_Type_GetAll", null); if (r != null) { list = new List <carreerTypeInfo>(); while (r.Read()) { var info = new carreerTypeInfo(); info.id = Int32.Parse(r["id"].ToString()); info.name = r["name"].ToString(); info.link = r["link"].ToString(); info.sort = int.Parse(r["sort"].ToString()); list.Add(info); } r.Close(); r.Dispose(); } return(list); }