//1009 15-11-2017 public DataTable FnBL_GetRecoveryStatRep_1009(ClsRecoveryGeneration RS) { try { sql = "Exec Isp_Recovery_Statement_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(ClsRecoveryGeneration 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 DataTable Fn_GetCustno(ClsRecoveryGeneration RS) { try { Sql = " Exec Isp_Rec_SMS @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "', " + " @RecDiv='" + RS.RECDIV + "',@RecCode='" + RS.RECCODE + "'," + " @EDate='" + Conn.ConvertDate(RS.ASONDT) + "'"; DT = Conn.GetDatatable(Sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(DT); }
public int Fn_InsertSMS(ClsRecoveryGeneration RS) { try { Sql = " Exec Isp_Rec_SMS @Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "', " + " @RecDiv='" + RS.RECDIV + "',@RecCode='" + RS.RECCODE + "',@AuthMid='" + RS.MID + "',@CreateMid='" + RS.MID + "', " + " @EDate='" + Conn.ConvertDate(RS.ASONDT) + "'"; Res = Conn.sExecuteQuery(Sql); } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); } return(Res); }
public int FnBl_GetCustPostings(ClsRecoveryGeneration 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 + "'"; } else { Sql = "Exec Isp_Recovery_CustStatement_X @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 int FnBl_GetPostings(ClsRecoveryGeneration 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 string FnBl_GetPostingTotal(ClsRecoveryGeneration RS) { string RES = ""; try { if (RS.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='" + RS.CustNo + "',@Flag='" + RS.FL + "',@Brcd='" + RS.BRCD + "',@ForMM='" + RS.MM + "',@ForYY='" + RS.YY + "',@RecCode='" + RS.RECCODE + "',@RecDiv='" + RS.RECDIV + "'"; } else { Sql = "Exec Isp_Recovery_CustStatement_X @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); }