public static DataTable Get_ItemSubGroup_ByItemGroup(string IG_ID)
{
string strSqlString = "";
try
{
strSqlString = " Select 0 value,'--Select Sub Group--' Text,0 RSN " +
" UNION ALL " +
" Select ISG_ID ,Item_SubGroup,1 RSN " +
" from M_AT_Mst_ItemSubGroup " +
" WHERE Fk_IG_ID=" + IG_ID +
" Order By RSN asc, Text asc ";
return(MEF.DA_GetDataTable(strSqlString));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
