public string FnBl_BBName(Cls_RecoCommon CM)
{
try
{
sql = "Select Convert(Varchar(500),BANKNAME)+', '+Convert(Varchar(500),MIDNAME) as BBName from BANKNAME where BRCD='" + CM.BRCD + "'";
sql = Conn.sExecuteScalar(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(sql);
}
public string FnBL_GetGlName(Cls_RecoCommon CM)
{
try
{
CM.sql = "SELECT GLNAME+'_'+CONVERT(VARCHAR(10),GLCODE) FROM GLMAST WHERE SUBGLCODE='" + CM.SUBGLCODE + "' AND BRCD='" + CM.BRCD + "'";
CM.sql = Conn.sExecuteScalar(CM.sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(CM.sql);
}
