private void genReporte(string sdate, string edate)
{
Reportes re = new Reportes();
DataTable dt = re.CuotasPendientesReporte(sdate, edate);
int[] colSize = { 80, 180, 70, 60 };
LlenarLista listaLLena = new LlenarLista(this.m_list, dt, colSize);
SqlDataReader ingreso = re.CuotasPendientesReporteSUMA(sdate, edate);
////populate total
this.m_list.SuspendLayout();
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
item.SubItems.Add(ingreso["BCAPITAL"].ToString()); //mora
item.SubItems.Add(ingreso["Interes"].ToString()); //interes
item.SubItems.Add(ingreso["BInteres"].ToString()); //interes
double capitalstr = 0.00;
double interesstr = 0.00;
double bcapitalstr = 0.00;
double binteresstr = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["BCapital"].ToString() != "")
{
bcapitalstr = Double.Parse(ingreso["BCapital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["BInteres"].ToString() != "")
{
binteresstr = Double.Parse(ingreso["BInteres"].ToString());
}
capitallabel.Text = String.Format("{0:C}", capitalstr);
bcapitallabel.Text = String.Format("{0:C}", bcapitalstr);
interestlabel.Text = String.Format("{0:C}", interesstr);
bintereslabel.Text = String.Format("{0:C}", binteresstr);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void reportebtn_Click(object sender, EventArgs e)
{
Reportes re = new Reportes();
DataTable dt = re.DataCreditoReporte();
int[] colSize = { 80, 80, 200, 150, 80, 80 };
LlenarLista listaLLena = new LlenarLista(this.dc_list, dt, colSize, "DATACREDITO");
loaded = true;
}
private void genReporte(string sdate, string edate)
{
Reportes re = new Reportes();
DataTable dt = re.CuotasPendientesReporte(sdate, edate);
int[] colSize = {80,180,70,60};
LlenarLista listaLLena = new LlenarLista(this.m_list,dt,colSize);
SqlDataReader ingreso = re.CuotasPendientesReporteSUMA(sdate, edate);
////populate total
this.m_list.SuspendLayout();
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
item.SubItems.Add(ingreso["BCAPITAL"].ToString()); //mora
item.SubItems.Add(ingreso["Interes"].ToString()); //interes
item.SubItems.Add(ingreso["BInteres"].ToString()); //interes
double capitalstr = 0.00;
double interesstr = 0.00;
double bcapitalstr = 0.00;
double binteresstr = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["BCapital"].ToString() != "")
{
bcapitalstr = Double.Parse(ingreso["BCapital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["BInteres"].ToString() != "")
{
binteresstr = Double.Parse(ingreso["BInteres"].ToString());
}
capitallabel.Text = String.Format("{0:C}", capitalstr);
bcapitallabel.Text = String.Format("{0:C}", bcapitalstr);
interestlabel.Text = String.Format("{0:C}", interesstr);
bintereslabel.Text = String.Format("{0:C}", binteresstr);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void genReporte(string sdate, string edate)
{
Cliente c = new Cliente();
DataTable dt = c.IngresoMensual(sdate, edate);
// clienteListalv. = dt;
int[] colsize = { 90, 70, 250, 60, 90, 90, 90 };
LlenarLista llenar = new LlenarLista(this.m_list, dt, colsize);
//FillList(this.m_list, dt);
SqlDataReader ingreso = c.IngresoMensualSuma(sdate, edate);
//populate total
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
item.SubItems.Add(ingreso["Interes"].ToString()); //interes
// item.SubItems.Add(ingreso["Mora"].ToString()); //mora place holder
item.SubItems.Add(ingreso["Monto"].ToString());
double capitalstr = 0.00;
double interesstr = 0.00;
double morastr = 0.00;
double t = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["Mora"].ToString() != "")
{
morastr = Double.Parse(ingreso["Mora"].ToString());
}
capitallb.Text = String.Format("{0:C}", capitalstr);
interestlb.Text = String.Format("{0:C}", interesstr);
moralb.Text = String.Format("{0:C}", morastr);
t = capitalstr + interesstr + morastr;
totallb.Text = String.Format("{0:C}", t);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void genReporte(string sdate, string edate)
{
Cliente c = new Cliente();
DataTable dt = c.IngresoMensual(sdate, edate);
// clienteListalv. = dt;
int[] colsize = {90,70,250,60,90,90,90 };
LlenarLista llenar = new LlenarLista(this.m_list, dt,colsize);
//FillList(this.m_list, dt);
SqlDataReader ingreso = c.IngresoMensualSuma(sdate, edate);
//populate total
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
item.SubItems.Add(ingreso["Interes"].ToString()); //interes
// item.SubItems.Add(ingreso["Mora"].ToString()); //mora place holder
item.SubItems.Add(ingreso["Monto"].ToString());
double capitalstr = 0.00;
double interesstr = 0.00;
double morastr = 0.00;
double t = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
if (ingreso["Interes"].ToString() != "")
{
interesstr = Double.Parse(ingreso["Interes"].ToString());
}
if (ingreso["Mora"].ToString() != "")
{
morastr = Double.Parse(ingreso["Mora"].ToString());
}
capitallb.Text = String.Format("{0:C}", capitalstr);
interestlb.Text = String.Format("{0:C}", interesstr);
moralb.Text = String.Format("{0:C}", morastr);
t = capitalstr + interesstr + morastr;
totallb.Text = String.Format("{0:C}", t);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void ClienteLista_Load(object sender, EventArgs e)
{
fechatxt.Text = DateTime.Now.ToString("dd-MM-yyyy");
string tmpfecha = DateTime.Now.ToString("yyyy-MM-dd");
Cliente c = new Cliente();
DataTable dt = c.ClienteListaHoy(tmpfecha);
LlenarLista llenar;
// clienteListalv. = dt;
FillList(this.m_list, dt);
dt = c.ClienteListaAtraso("0");
int[] col = {90,270,90};
llenar = new LlenarLista(this.m_listaatraso, dt,col);
//load inactivo
dt = c.ClienteListaAtraso("1");
llenar = new LlenarLista(this.inactivolistview, dt, col);
}
private void ClienteLista_Load(object sender, EventArgs e)
{
fechatxt.Text = DateTime.Now.ToString("dd-MM-yyyy");
string tmpfecha = DateTime.Now.ToString("yyyy-MM-dd");
Cliente c = new Cliente();
DataTable dt = c.ClienteListaHoy(tmpfecha);
LlenarLista llenar;
// clienteListalv. = dt;
FillList(this.m_list, dt);
dt = c.ClienteListaAtraso("0");
int[] col = { 90, 270, 90 };
llenar = new LlenarLista(this.m_listaatraso, dt, col);
//load inactivo
dt = c.ClienteListaAtraso("1");
llenar = new LlenarLista(this.inactivolistview, dt, col);
}
private void genReporte(string sdate, string edate)
{
Reportes re = new Reportes();
DataTable dt = re.BalanceClienteReporte();
int[] colSize = { 100, 350, 100 };
LlenarLista listaLLena = new LlenarLista(this.m_list, dt, colSize);
SqlDataReader ingreso = re.BalanceClienteReporteSUMA();
////populate total
this.m_list.SuspendLayout();
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
double capitalstr = 0.00;
double interesstr = 0.00;
double bcapitalstr = 0.00;
double binteresstr = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
capitallabel.Text = String.Format("{0:C}", capitalstr);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void genReporte(string sdate, string edate)
{
Reportes re = new Reportes();
DataTable dt = re.BalanceClienteReporte();
int[] colSize = { 100, 350, 100 };
LlenarLista listaLLena = new LlenarLista(this.m_list, dt, colSize);
SqlDataReader ingreso = re.BalanceClienteReporteSUMA();
////populate total
this.m_list.SuspendLayout();
ListViewItem item = new ListViewItem();
item.Text = "TOTAL";
item.SubItems.Add("-");
item.SubItems.Add("-");
item.SubItems.Add("-");
if (ingreso.Read())
{
item.SubItems.Add(ingreso["Capital"].ToString()); //capital
double capitalstr = 0.00;
double interesstr = 0.00;
double bcapitalstr = 0.00;
double binteresstr = 0.00;
if (ingreso["Capital"].ToString() != "")
{
capitalstr = Double.Parse(ingreso["Capital"].ToString());
}
capitallabel.Text = String.Format("{0:C}", capitalstr);
}
this.m_list.Items.Add(item);
this.m_list.ResumeLayout();
}
private void reportebtn_Click(object sender, EventArgs e)
{
Reportes re = new Reportes();
DataTable dt = re.DataCreditoReporte();
int[] colSize = { 80,80,200, 150, 80,80 };
LlenarLista listaLLena = new LlenarLista(this.dc_list, dt, colSize,"DATACREDITO");
loaded = true;
}