// Big size private static DataTable GetSizeRotateTableWithSizerunId(int sizerunValueId) { var sizeEntity = PdmCacheManager.DictCodeKeyPdmEntityBlCache[EmEntityCode.SizeRunDetail.ToString()]; string connectionInfo = PLMSEntityClrBL.GetConnectionInfoWithCode(sizeEntity.DataSourceFrom); string querySizeRotate = @" select SizeRunRotateID ,SizeOrder ,SizeName from tblSizeRunRotate where SizeRunId = @sizeRunId order by SizeOrder "; // need to filter using (SqlConnection conn = new SqlConnection(connectionInfo)) { //SqlContext. conn.Open(); SqlCommand cmdSize = new SqlCommand(querySizeRotate, conn); SqlParameter paraSizeRunrunIdValueId = new SqlParameter("@sizeRunId", sizerunValueId); cmdSize.Parameters.Add(paraSizeRunrunIdValueId); DataTable sizeRotateTable = DataAcessHelper.GetDataTableQueryResult(cmdSize); return(sizeRotateTable); } }
public static Dictionary <int, List <LookupItemDto> > GetDictEntityLookItemDtoFromDataBase(List <int> entityIDs) { var discitnEntitIds = entityIDs.Distinct().ToList(); Dictionary <int, List <LookupItemDto> > dictEntityDisplayInfoList = new Dictionary <int, List <LookupItemDto> >(); List <PdmEntityBlClrDto> listPdmEntityDto = PdmCacheManager.DictPdmEntityBlEntity.Where(pair => entityIDs.Contains(pair.Key)).Select(pair => pair.Value).ToList(); Dictionary <string, List <PdmEntityBlClrDto> > dictConnInfoSysDefineEntityList = new Dictionary <string, List <PdmEntityBlClrDto> >(); List <PdmEntityBlClrDto> userDefineEntityList = new List <PdmEntityBlClrDto>(); List <PdmEntityBlClrDto> enumEntityList = new List <PdmEntityBlClrDto>(); // need to classify entity type !! foreach (PdmEntityBlClrDto pdmEntityBlClrDto in listPdmEntityDto) { //tblCompanySetup= if (pdmEntityBlClrDto.EntityType == (int)EmEntityType.SystemDefineTable) { // need to filter tblsketch ,tblskech could come fro mother applcation place //if (pdmEntityBlClrDto.EntityCode == EmEntityCode.Sketch.ToString ()) // continue; string connectInfo = PLMSEntityClrBL.GetConnectionInfoWithCode(pdmEntityBlClrDto.DataSourceFrom); // CLROutput.OutputDebug(pdmEntityBlClrDto.EntityCode + "c?" + connectInfo); pdmEntityBlClrDto.ConnectInfo = connectInfo; // CLROutput.OutputDebug("pdmEntityBlClrDto.ConnectInfo=" + pdmEntityBlClrDto.ConnectInfo); if (dictConnInfoSysDefineEntityList.ContainsKey(connectInfo)) { List <PdmEntityBlClrDto> listEntityDto = dictConnInfoSysDefineEntityList[connectInfo]; listEntityDto.Add(pdmEntityBlClrDto); } else // not include conenction info key: first time { List <PdmEntityBlClrDto> listEntityDto = new List <PdmEntityBlClrDto>(); dictConnInfoSysDefineEntityList.Add(connectInfo, listEntityDto); listEntityDto.Add(pdmEntityBlClrDto); } } else if (pdmEntityBlClrDto.EntityType == (int)EmEntityType.UserDefineTable) { userDefineEntityList.Add(pdmEntityBlClrDto); } else if (pdmEntityBlClrDto.EntityType == (int)EmEntityType.PDMEnum) { enumEntityList.Add(pdmEntityBlClrDto); } } // foreach (string connectInfo in dictConnInfoSysDefineEntityList.Keys) { using (SqlConnection conn = new SqlConnection(connectInfo)) { conn.Open(); List <PdmEntityBlClrDto> listEntityDto = dictConnInfoSysDefineEntityList[connectInfo]; GetSysDefineDictLookItem(conn, dictEntityDisplayInfoList, listEntityDto); } } using (SqlConnection conn = new SqlConnection(PLMConstantString.PLM_APP_ConnectionString)) { conn.Open(); PLMSEntityClrBL.GetEnumDictLookItemNew(conn, dictEntityDisplayInfoList, enumEntityList); PLMSEntityClrBL.GetUserDefineDictLookItem(conn, dictEntityDisplayInfoList, userDefineEntityList); } return(dictEntityDisplayInfoList); }