// 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);
}
