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 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; }