예제 #1
0
        private string PopulateCounterUserwise(string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.UserName = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.PopulateCounterUserwise(reportProp);

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                if (dt.Rows.Count > 0)
                {
                    StringBuilder sb = new StringBuilder();
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append(dt.Rows[i]["counterid"].ToString() + "#" + dt.Rows[i]["countername"].ToString() + "$");
                    }
                    return(sb.ToString());
                }
                else
                {
                    return("0#No Data Found$");
                }
            }
        }
예제 #2
0
        private string DailyLoginLogout(string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DailyLoginLogout(reportProp);

            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=5>" + "Daily Login Logout Report" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                sb.Append("<th>" + "Sr No" + "</th>");
                sb.Append("<th>" + "COUNTERNAME" + "</th>");
                sb.Append("<th>" + "USERNAME" + "</th>");

                sb.Append("<th>" + "LOGINDATE" + "</th>");
                sb.Append("<th>" + "LOGOUTDATE" + "</th>");
                sb.Append("</tr>");


                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");


                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["COUNTERNAME"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["USERNAME"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["LOGINDATE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["LOGOUTDATE"].ToString() + "</td>");


                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #3
0
        private string DatewiseSPTS(string sdo, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = sdo;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DatewiseSPTS(reportProp);

            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=7>" + "Date wise & Subdivision wise Payment transaction Summary" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    sb.Append("<th>" + dt.Columns[i].ColumnName.ToString() + "</th>");
                }
                sb.Append("</tr>");


                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");

                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            sb.Append("<td>" + dt.Rows[i][j].ToString() + "</td>");
                        }
                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #4
0
        private string CancelTrasaction(string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.CancelTrasaction(reportProp);

            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=11>" + "Cancellation Transaction Report" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    sb.Append("<th>" + dt.Columns[i].ColumnName.ToString() + "</th>");
                }
                sb.Append("</tr>");


                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");

                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            sb.Append("<td>" + dt.Rows[i][j].ToString() + "</td>");
                        }
                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td colspan=11>No Record Found</td></tr>");
                }
                //sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #5
0
        private DataTable DailyLoginLogout(string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DailyLoginLogout(reportProp);

            return(dt);
        }
예제 #6
0
        private DataTable CancelTrasaction(string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.CancelTrasaction(reportProp);

            return(dt);
        }
예제 #7
0
        private DataTable DailySubDWiseSummary(string SubDivision, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DailySubDWiseSummary(reportProp);

            return(dt);
        }
예제 #8
0
        private DataTable dailycheckexport(string SubDivision, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DailyCRTransactionWiseexport(reportProp);

            return(dt);
        }
예제 #9
0
        private DataTable DatewiseSPTSexport(string sdo, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = sdo;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DatewiseSPTSexport(reportProp);

            return(dt);
        }
예제 #10
0
        private DataTable DailyChequeWise(string SubDivision, string CounterName, string Bank, string User, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.Bank        = Bank;
            reportProp.UserName    = User;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DailyChequeWise(reportProp);

            return(dt);
        }
예제 #11
0
        private DataTable exporttoexcel(string SubDivision, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;

            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.ReportDailyPCSheet(reportProp);


            return(dt);
        }
예제 #12
0
        private string PaymentData(string SubDivision, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;

            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.PaymentData(reportProp);



            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=15>" + "Daily Payment Data" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                sb.Append("<th>" + "SDO" + "</th>");
                sb.Append("<th>" + "ACCNo" + "</th>");
                sb.Append("<th>" + "Counter No" + "</th>");
                sb.Append("<th>" + "ReceiptNo" + "</th>");
                sb.Append("<th>" + "AMOUNT" + "</th>");
                sb.Append("<th>" + "RDATE" + "</th>");
                sb.Append("<th>" + "CHEQUENO" + "</th>");
                sb.Append("<th>" + "CHQ DATE" + "</th>");
                sb.Append("<th>" + "BANK" + "</th>");
                sb.Append("<th>" + "Mode Of Payment" + "</th>");
                sb.Append("<th>" + "Status" + "</th>");
                sb.Append("<th>" + "CounterName" + "</th>");
                sb.Append("<th>" + "Entered Time" + "</th>");
                sb.Append("<th>" + "Consumer Name" + "</th>");
                sb.Append("</tr>");

                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>" + dt.Rows[i]["SDO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["Counter No"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ReceiptNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["RDATE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CHQ DATE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["BANK"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["Mode Of Payment"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["Status"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CounterName"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["Entered Time"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["Consumer Name"].ToString() + "</td>");


                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='9'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #13
0
        private string DailyPCSheet(string SubDivision, string CounterName, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;

            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.ReportDailyPCSheet(reportProp);



            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=9>" + "Daily Payment ControlSheet" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                sb.Append("<th>" + "Sr No" + "</th>");
                sb.Append("<th>" + "ACCNo" + "</th>");
                sb.Append("<th>" + "PAYDATE" + "</th>");
                sb.Append("<th>" + "COUNTERNO" + "</th>");
                sb.Append("<th>" + "ReceiptNo" + "</th>");
                sb.Append("<th>" + "AMOUNT" + "</th>");
                sb.Append("<th>" + "CASH/CHEQUE" + "</th>");
                sb.Append("<th>" + "CHEQUENO" + "</th>");
                sb.Append("<th>" + "USER" + "</th>");
                sb.Append("</tr>");

                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["PAYDATE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["COUNTERNO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ReceiptNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CASH/CHEQUE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["USER"].ToString() + "</td>");
                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='9'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #14
0
        private string DailyCSUserWise(string CounterName, string user, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.CounterName = CounterName;
            reportProp.UserName    = user;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal    reportbal = new report_bal();
            DataTable     dt        = reportbal.DailyCSUserWise(reportProp);
            StringBuilder sb        = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=7>" + "Daily Collection Summary User Wise" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");


                sb.Append("<th>" + "User Name" + "</th>");
                sb.Append("<th>" + "TOTAL CASHSTUBS" + "</th>");
                sb.Append("<th>" + "TOTALCASHS Amount" + "</th>");
                sb.Append("<th>" + "TOTAL CHQ STUBS" + "</th>");
                sb.Append("<th>" + "TOTAL CHQ Amount" + "</th>");
                sb.Append("<th>" + "Total Stub" + "</th>");
                sb.Append("<th>" + "TotalAmount" + "</th>");

                sb.Append("</tr>");


                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");


                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");

                        sb.Append("<td>" + dt.Rows[i]["username"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["TOTAL CASHSTUBS"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["TOTALCASHSAMount"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["TOTAL CHQ STUBS"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["TOTALCHQAmount"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["TotalStub"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["TotalAmount"].ToString() + "</td>");

                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #15
0
        private string repReceiptno(string SubDivision, string CounterName, string fromdate, string todate, string userid, string Receiptno)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            reportProp.Receiptno   = Receiptno;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.Receiptno(reportProp);



            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=10>" + "Cashier location allocation report" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                sb.Append("<th>" + "Sr No" + "</th>");
                sb.Append("<th>" + "ACCNo" + "</th>");
                sb.Append("<th>" + "PAYDATE" + "</th>");
                sb.Append("<th>" + "COUNTERNO" + "</th>");
                sb.Append("<th>" + "ReceiptNo" + "</th>");
                sb.Append("<th>" + "AMOUNT" + "</th>");
                sb.Append("<th>" + "CASH/CHEQUE" + "</th>");
                sb.Append("<th>" + "CHEQUENO" + "</th>");
                sb.Append("<th>" + "USER" + "</th>");
                sb.Append("<th>" + "Print" + "</th>");
                sb.Append("</tr>");

                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["PAYDATE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["COUNTERNO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ReceiptNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CASH/CHEQUE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["USER"].ToString() + "</td>");
                        sb.Append("<td ><img src='images/print.jpeg' alt='delete' onclick=PrintReceipt('");
                        sb.Append(dt.Rows[i]["paymentid"].ToString().Trim() + "') /></td>");

                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='9'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }
예제 #16
0
        private string DailyChequeWise(string SubDivision, string CounterName, string Bank, string User, string fromdate, string todate, string userid)
        {
            report_Prop reportProp = new report_Prop();

            reportProp.SubDivision = SubDivision;
            reportProp.CounterName = CounterName;
            reportProp.Bank        = Bank;
            reportProp.UserName    = User;
            reportProp.fromdate    = fromdate;
            reportProp.todate      = todate;
            reportProp.UserId      = userid;
            report_bal reportbal = new report_bal();
            DataTable  dt        = reportbal.DailyChequeWise(reportProp);

            StringBuilder sb = new StringBuilder();

            if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
            {
                return("0#" + reportbal.ErrMessage + "$");
            }
            else
            {
                sb.Append("<tr>");
                sb.Append("<th colspan=9>" + "Daily Cheque Report Cheque Wise" + "</th>");
                sb.Append("</tr>");
                sb.Append("<tr>");
                sb.Append("<th>" + "Sr No" + "</th>");
                sb.Append("<th>" + "SDO" + "</th>");
                sb.Append("<th>" + "SDO Name" + "</th>");

                sb.Append("<th>" + "ACCNo" + "</th>");
                sb.Append("<th>" + "CHEQUENO" + "</th>");
                sb.Append("<th>" + "CHQ DATE" + "</th>");
                sb.Append("<th>" + "BANK" + "</th>");
                sb.Append("<th>" + "UNDER A/C" + "</th>");

                sb.Append("<th>" + "AMOUNT" + "</th>");

                sb.Append("</tr>");


                if (dt.Rows.Count > 0)
                {
                    sb.Append("$");


                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        sb.Append("<tr>");
                        sb.Append("<td>" + dt.Rows[i]["SrNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["SDO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["SDO Name"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["ACCNo"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CHEQUENO"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["CHQ DATE"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["BANK NAME"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["UNDER A/C"].ToString() + "</td>");
                        sb.Append("<td>" + dt.Rows[i]["AMOUNT"].ToString() + "</td>");
                        sb.Append("</tr>");
                    }
                }
                else
                {
                    sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
                }
                //sb.Append("<tr><td colspan='13'>No Record Found</td></tr>");
            }


            return(sb.ToString());
        }