public static T_CMS_Static_ContractTermCollection Search(SearchFilter SearchKey) { T_CMS_Static_ContractTermCollection collection = new T_CMS_Static_ContractTermCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Static_ContractTerm_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey))) { while (reader.Read()) { T_CMS_Static_ContractTerm obj = new T_CMS_Static_ContractTerm(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Static_ContractTermCollection GetbyUser(string CreatedUser) { T_CMS_Static_ContractTermCollection collection = new T_CMS_Static_ContractTermCollection(); T_CMS_Static_ContractTerm obj; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Static_ContractTerm_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Static_ContractTermCollection GetAllItem() { T_CMS_Static_ContractTermCollection collection = new T_CMS_Static_ContractTermCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Static_ContractTerm_GetAll", null)) { while (reader.Read()) { T_CMS_Static_ContractTerm obj = new T_CMS_Static_ContractTerm(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }