public List <InquirePriceModel> GetInquirePriceList(string SortColumns, int StartRecord, int MaxRecords, int InquirePriceCodeEqual, string ProjectNameEqual, string InquireObjectEqual, string RequirementEqual, int AduitingEqual, string Field1Equal) { List <InquirePriceModel> models = new List <InquirePriceModel>(); InquirePriceQueryModel objQueryModel = new InquirePriceQueryModel(); objQueryModel.StartRecord = StartRecord; objQueryModel.MaxRecords = MaxRecords; objQueryModel.SortColumns = SortColumns; objQueryModel.InquirePriceCodeEqual = InquirePriceCodeEqual; objQueryModel.ProjectNameEqual = ProjectNameEqual; objQueryModel.InquireObjectEqual = InquireObjectEqual; objQueryModel.RequirementEqual = RequirementEqual; objQueryModel.AduitingEqual = AduitingEqual; objQueryModel.Field1Equal = Field1Equal; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); models = new InquirePriceBLL().GetModels(objQueryModel, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(models); }
public List <InquirePriceModel> GetInquirePriceList(InquirePriceQueryModel QueryModel) { List <InquirePriceModel> models = new List <InquirePriceModel>(); using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); if (QueryModel == null) { QueryModel = new InquirePriceQueryModel(); } models = new InquirePriceBLL().GetModels(QueryModel, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(models); }
public List <InquirePriceModel> GetModels(InquirePriceQueryModel ObjQueryModel, SqlTransaction Transaction) { InquirePriceDAL edal = new InquirePriceDAL(Transaction); return(edal.Select(ObjQueryModel)); }