//1009 15-11-2017
public DataTable FnBL_GetRecoveryStatRep_1009(ClsRecoveryStatement RS)
{
try
{
sql = "Exec Isp_Recovery_Create_1009 @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@OnDate='" + Conn.ConvertDate(RS.ASONDT) + "',@RecDiv=" + RS.RECDIV + ",@RecCode=" + RS.RECCODE + ",@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "'";
RS.DT = Conn.GetDatatable(RS.sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(RS.DT);
}
public string FnBl_GetBANKCode(ClsRecoveryStatement RS)
{
string RES = "";
try
{
Sql = "Select BANKCD from BANKNAME where BRCD=0";
RES = Conn.sExecuteScalar(Sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(RES);
}
public int FnBl_GetPostings(ClsRecoveryStatement RS)
{
try
{
if (RS.BANKCODE == "1009")
{
// Sql = "Exec Isp_Recovery_Statement_1009 @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'";
Sql = "Exec Isp_Recovery_Create_1009 @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'";
}
else
{
//Sql = "Exec Isp_Recovery_Statement @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'";
Sql = "Exec Isp_Recovery_Create @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'";
}
Res = Conn.sBindGrid(RS.GD, Sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(Res);
}
public int FnBl_GetCustPostings(ClsRecoveryStatement RS)
{
try
{
if (RS.BANKCODE == "1009")
{
Sql = "Exec Isp_Recovery_CustStatement_X_1009 @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "',@CustNo='" + RS.CustNo + "'";
//Sql = "Exec Isp_Recovery_CustStatement_1009 @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "',@CustNo='" + RS.CustNo + "'";
}
else
{
Sql = "Exec Isp_Recovery_CustStatement_X @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "',@CustNo='" + RS.CustNo + "'";
//Sql = "Exec Isp_Recovery_CustStatement @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "',@CustNo='" + RS.CustNo + "'";
}
Res = Conn.sBindGrid(RS.GD, Sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(Res);
}
public string FnBl_GetPostingTotal_1(ClsRecoveryStatement RS1)
{
string RES = "";
try
{
if (RS1.BANKCODE == "1009")
{
//Sql = "Exec Isp_Recovery_CustStatement_1009 @Custno='" + RS.CustNo + "',@Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'";
Sql = "Exec Isp_Recovery_CustStatement_X_1009 @Custno='" + RS1.CustNo + "',@Flag='" + RS1.FL + "',@Brcd='" + RS1.BRCD + "',@ForMM='" + RS1.MM + "',@ForYY='" + RS1.YY + "',@RecCode='" + RS1.RECCODE + "',@RecDiv='" + RS1.RECDIV + "'";
}
else
{
Sql = "Exec Isp_Recovery_CustStatement_X @Custno='" + RS1.CustNo + "',@Flag='" + RS1.FL + "',@Brcd='" + RS1.BRCD + "',@ForMM='" + RS1.MM + "',@ForYY='" + RS1.YY + "',@RecCode='" + RS1.RECCODE + "',@RecDiv='" + RS1.RECDIV + "'";
//Sql = "Exec Isp_Recovery_CustStatement @Custno='" + RS.CustNo + "',@Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'";
}
RES = Conn.sExecuteScalar(Sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(RES);
}
