public int FnBL_BindRecCustDiv(Cls_RecoBindDropdown BD, string CustNo)
{
try
{
BD.sql = "Select Convert(varchar(100),A.RECDIV)+'-'+Convert(varchar(100),A.DESCR) name,A.RECDIV id from PAYMAST A Inner join Master M On A.RECDIV = M.BRANCHNAME Where A.RECCODE=0 And M.CustNo = '" + CustNo + "' Order by A.RECCODE";
Conn.FillDDL(BD.Ddl, BD.sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(BD.IntRes);
}
public int FnBL_BindRecDiv(Cls_RecoBindDropdown BD)
{
try
{
BD.sql = "Select Convert(varchar(100),RECDIV)+'-'+Convert(varchar(100),DESCR) name,RECDIV id from PAYMAST where RECCODE=0 Order by RECCODE";
Conn.FillDDL(BD.Ddl, BD.sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(BD.IntRes);
}
public int FnBL_BindDropDown(Cls_RecoBindDropdown BD)
{
try
{
BD.sql = "SELECT Convert(varchar(100),BRCD)+'-'+Convert(varchar(100),MIDNAME) name,BRCD id from BANKNAME WHERE BRCD<>0 ORDER BY BRCD";
Conn.FillDDL(BD.Ddl, BD.sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(BD.IntRes);
}
public int FnBL_BindRecDept(Cls_RecoBindDropdown BD)
{
try
{
// BD.sql = "Select Convert(varchar(100),RECCODE)+'-'+Convert(varchar(100),DESCR) name,RECCODE id from PAYMAST " +
// " where RECDIV='" + BD.RECDIV + "' and BRCD='" + BD.BRCD + "' Order by RECCODE";
BD.sql = "Select Convert(varchar(100),DESCR)+'-'+Convert(varchar(100),RECCODE) name,RECCODE id from PAYMAST " +
" where RECDIV='" + BD.RECDIV + "' and BRCD='" + BD.BRCD + "' Order by RECCODE";
Conn.FillDDL(BD.Ddl, BD.sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(BD.IntRes);
}
