/// <summary>
/// combo 공통 함수
/// </summary>
/// <param name="CodeClassId">콤보 쿼리 수행되는 변수 조건값 ex) 사용콤보(USEYN), 검사결과 (RESULT), 적치대 (RACK) 등</param>
/// <returns></returns>
public static List <ComboCodeModel> GetComboCodeList(string CodeClassId)
{
List <ComboCodeModel> ComboData = new List <ComboCodeModel>();
List <SqlParameter> Params = new List <SqlParameter>();
Params.Add(new SqlParameter("@codeclassid", CodeClassId));
try
{
var InputResultDic = dbManager.CallSelectProcedure("selectCode", Params);
if (InputResultDic.Count > 0)
{
ComboCodeModel codeModel = new ComboCodeModel();
for (int i = 0; i < InputResultDic.Count; i++)
{
codeModel = new ComboCodeModel();
codeModel.CODEID = InputResultDic[i]["CODEID"].ToString();
codeModel.CODENAME = InputResultDic[i]["CODENAME"].ToString();
ComboData.Add(codeModel);
}
}
}
catch (Exception ee)
{
LogFactory.Log(ee);
}
return(ComboData);
}
/// <summary>
/// 작성자 : 윤보미
/// 설명 : 설비유형 콤보리스트 반환
/// </summary>
/// <returns></returns>
static List <ComboCodeModel> GetEqpTypeList()
{
List <ComboCodeModel> code = GetComboCodeList("EQUIPMENT");
ComboCodeModel rack = code.Find(x => x.CODEID.Equals("EQUIPMENT_RACK"));
if (!IsNullOrWhiteSpace(rack))
{
code.Remove(rack);
}
return(code);
}
