public static LTD_InfoCategory GetDefaultLtdInfoCategory() { LTD_InfoCategory ltdInfoCategory = null; Database db = HaveDb(); if (db != null) { long totalPages = 0; long totalItems = 0; List<LTD_InfoCategory> categoryList = GetPagedLtdInfoCategory(1, 1, out totalPages, out totalItems, "", " Where IsDefault=@0", true); if (totalItems > 0) { ltdInfoCategory = categoryList[0]; } else if (totalItems ==0) { categoryList = DataSource.GetPagedLtdInfoCategory(1, 1, out totalPages, out totalItems, "", ""); if (totalItems > 0) { ltdInfoCategory = categoryList[0]; } } } else { Dictionary<Guid, LTD_InfoCategory> allLtdInfoCategoryList = FileSource.LoadLTDInfoCategoryData(); foreach (KeyValuePair<Guid, LTD_InfoCategory> item in allLtdInfoCategoryList) { ltdInfoCategory = item.Value; if (item.Value.IsDefault == true) { ltdInfoCategory = item.Value; break; } } } return ltdInfoCategory; }
public static CNS_DataRefType GetCnsDataRefType(string dataRefType) { CNS_DataRefType cnsDataRefType = null; Database db = HaveDb(); if (db != null) { cnsDataRefType = db.SingleOrDefault<CNS_DataRefType>("SELECT * FROM CNS_DataRefType Where DataRefType=@0", dataRefType); } else { Dictionary<Guid, CNS_DataRefType> allCnsDataRefTypeList = FileSource.LoadCNSDataRefTypeData(); foreach (KeyValuePair<Guid, CNS_DataRefType> item in allCnsDataRefTypeList) { if (item.Value.DataRefType == dataRefType) { cnsDataRefType = item.Value; break; } } } return cnsDataRefType; }