private void genReporte(string sdate, string edate) { Reportes re = new Reportes(); DataTable dt = re.GastosOperacionalesReporte(sdate, edate); int[] colSize = { 60, 70, 200, 240, 70 }; FillList(this.m_list, dt, colSize); }
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(); }
public void ProcesarCuotas(string pid, string fecha,bool domora) { Reportes re = new Reportes(); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraCuotas(fecha, pid); adapter.Fill(ds); double totalmora = 0; double capven = 0; double intven = 0; int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ListViewItem item = new ListViewItem(); item.Text = row["HISTORIAID"].ToString(); item.SubItems.Add(row["PRESTAMOID"].ToString()); item.SubItems.Add(row["Cuota"].ToString()); item.SubItems.Add(row["CL_CODIGO"].ToString()); item.SubItems.Add(row["CL_NOMBRE"].ToString()); item.SubItems.Add(row["Capital"].ToString()); double mora = 0; double interes = 0; if (Double.TryParse(row["Capital"].ToString(), out mora)) { capven += mora; mora = Math.Floor(mora * 0.05); totalmora += mora; item.SubItems.Add(mora.ToString()); } if (Double.TryParse(row["Interes"].ToString(), out interes)) { intven += interes; } if (domora) { re.setUpdateCuotaMora(row["HISTORIAID"].ToString(), mora); actualizarBackgroundWorker1.ReportProgress(counter, item); } counter++; } if (domora) { re.setUpdatePrestamoMora(pid, totalmora); } re.setUpdatePrestamoCapVen(pid, capven, intven); }
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(); }
public void ProcesarCuotas(string pid, string fecha, bool domora) { Reportes re = new Reportes(); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraCuotas(fecha, pid); adapter.Fill(ds); double totalmora = 0; double capven = 0; double intven = 0; int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ListViewItem item = new ListViewItem(); item.Text = row["HISTORIAID"].ToString(); item.SubItems.Add(row["PRESTAMOID"].ToString()); item.SubItems.Add(row["Cuota"].ToString()); item.SubItems.Add(row["CL_CODIGO"].ToString()); item.SubItems.Add(row["CL_NOMBRE"].ToString()); item.SubItems.Add(row["Capital"].ToString()); double mora = 0; double interes = 0; if (Double.TryParse(row["Capital"].ToString(), out mora)) { capven += mora; mora = Math.Floor(mora * 0.05); totalmora += mora; item.SubItems.Add(mora.ToString()); } if (Double.TryParse(row["Interes"].ToString(), out interes)) { intven += interes; } if (domora) { re.setUpdateCuotaMora(row["HISTORIAID"].ToString(), mora); actualizarBackgroundWorker1.ReportProgress(counter, item); } counter++; } if (domora) { re.setUpdatePrestamoMora(pid, totalmora); } re.setUpdatePrestamoCapVen(pid, capven, intven); }
private void dc_list_ItemCheck(object sender, ItemCheckEventArgs e) { if (loaded) { //setUpdateDataCredito int indexnum = e.Index; int num = 0; string pid = dc_list.Items[indexnum].SubItems[0].Text; if (e.NewValue == CheckState.Checked) { num = 1; } Reportes re = new Reportes(); re.setUpdateDataCredito(pid, num); } }
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.GastosOperacionalesReporte(sdate, edate); int[] colSize = { 60, 70, 200, 240,70 }; FillList(this.m_list, dt, colSize); }
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 actualizarBackgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { Reportes re = new Reportes(); //set all capven and intven to 0 re.UpdateAllPrestamoCapVen(); // procesar semanales primero. if ( semanalTexBox.Text != "") { double dia = -1 * Double.Parse(semanalTexBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "S"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(),hoy.ToString("yyyy-MM-dd"),semanalCheckBox.Checked); counter++; } } if (diarioTextBox.Text != "") { double dia = -1 * Double.Parse(diarioTextBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "D"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"),diarioCheckBox.Checked); counter++; } } if (quincenalTexBox.Text != "") { double dia = -1 * Double.Parse(quincenalTexBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "Q"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"), quincenalCheckBox.Checked); counter++; } } if (mensualTexBox.Text != "") { int dia = -1 * int.Parse(mensualTexBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "M"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"), mensualCheckBox.Checked); counter++; } } }
private void actualizarBackgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { Reportes re = new Reportes(); //set all capven and intven to 0 re.UpdateAllPrestamoCapVen(); // procesar semanales primero. if (semanalTexBox.Text != "") { double dia = -1 * Double.Parse(semanalTexBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "S"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"), semanalCheckBox.Checked); counter++; } } if (diarioTextBox.Text != "") { double dia = -1 * Double.Parse(diarioTextBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "D"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"), diarioCheckBox.Checked); counter++; } } if (quincenalTexBox.Text != "") { double dia = -1 * Double.Parse(quincenalTexBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "Q"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"), quincenalCheckBox.Checked); counter++; } } if (mensualTexBox.Text != "") { int dia = -1 * int.Parse(mensualTexBox.Text); DateTime hoy = DateTime.Now.AddDays(dia); DataSet ds = new DataSet(); SqlDataAdapter adapter = re.getPrestamoMoraList(hoy.ToString("yyyy-MM-dd"), "M"); adapter.Fill(ds); int counter = 1; foreach (DataRow row in ds.Tables[0].Rows) { ProcesarCuotas(row["PRESTAMO"].ToString(), hoy.ToString("yyyy-MM-dd"), mensualCheckBox.Checked); counter++; } } }