private void CmdBusCli_Click(object sender, EventArgs e) { DataTable dtres = new DataTable(); CN_ges_planproduccion o_plan = new CN_ges_planproduccion(); CN_ges_planventas o_planven = new CN_ges_planventas(); o_plan.mysConec = mysConec; o_plan.BuscarPlanProduccionActivo(STU_SISTEMA.EMPRESAID); dtres = o_plan.dtLista; if (dtres == null) { return; } if (dtres.Rows.Count == 0) { return; } LblIdPlaVen.Text = Convert.ToInt32(dtres.Rows[0]["n_id"]).ToString(); TxtPlaVen.Text = dtres.Rows[0]["c_des"].ToString(); TxtFchIni.Text = Convert.ToDateTime(dtres.Rows[0]["d_fchini"]).ToString(); TxtFchFin.Text = Convert.ToDateTime(dtres.Rows[0]["d_fchfin"]).ToString(); }
void MostrarInfo() { int n_row = 0; DataTable dtres = new DataTable(); CN_ges_planventas o_plaven = new CN_ges_planventas(); o_plaven.mysConec = mysConec; FgProEmp1.Rows.Count = 2; o_plaven.PlanVentasUnificado(); // CARGAMOS PLAN DE VENTAS UNFIFIADO dtres = o_plaven.dtLista; if (o_plaven.booOcurrioError == false) { funFlex.b_AlternarColor = true; MostrarCabeceraMes(Convert.ToInt32(dtres.Rows[0]["n_idmesini"]), dtres); //funFlex.FlexMostrarDatos(FgProEmp1, arrCabeceraFlex1, dtres, 2, true); } else { MessageBox.Show("¡ No se puede mostrar el plan de ventas unificado por el siguiente motivo: " + o_plaven.StrErrorMensaje + " !", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); } o_plaven = null; }
void MostrarDatosItems() { int n_row = 0; int n_numanos = 0; double n_valor; DataTable dtResult = new DataTable(); CN_ges_planventas o_plan = new CN_ges_planventas(); dtResult = funDatos.DataTableFiltrar(dtItems, "n_id = " + n_IdItem + ""); if (dtResult.Rows.Count != 0) { TxtCodPro.Text = dtResult.Rows[0]["c_codpro"].ToString(); TxtDes.Text = dtResult.Rows[0]["c_despro"].ToString(); TxtUniMed.Text = dtResult.Rows[0]["c_abrpre"].ToString(); } o_plan.mysConec = mysConec; o_plan.VentasItemxPorAnos(STU_SISTEMA.EMPRESAID, n_IdItem); dtResult = o_plan.dtLista; FgItems.Rows.Count = 2; if (dtResult != null) { if (dtResult.Rows.Count != 0) { funFlex.FlexMostrarDatos(FgItems, arrCabeceraFlex1, dtResult, 2, true); FgItems.SelectionMode = C1.Win.C1FlexGrid.SelectionModeEnum.Row; n_numanos = dtResult.Rows.Count; // CALCULAMOS EL TOTAL double n_totalmes = 0; FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(FgItems.Rows.Count - 1, 1, "TOTAL ==>"); n_totalmes = funFlex.FlexSumarCol(FgItems, 2, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 2, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 3, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 3, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 4, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 4, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 5, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 5, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 6, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 6, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 7, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 7, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 8, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 8, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 9, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 9, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 10, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 10, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 11, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 11, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 12, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 12, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 13, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 13, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 14, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 14, n_totalmes.ToString("0.00")); //CALCULAMOS EL PROMEDIO FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(FgItems.Rows.Count - 1, 1, "PROMEDIO ==>"); double n_total = 0; Double n_promedio = 0; n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 2)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 2, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 3)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 3, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 4)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 4, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 5)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 5, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 6)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 6, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 7)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 7, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 8)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 8, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 9)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 9, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 10)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 10, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 11)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 11, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 12)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 12, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 13)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 13, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 14)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 14, n_promedio.ToString("0.00")); } } string[] c_datos = new string[12]; int n_fil = 0; int n_ele = 0; string c_dato = ""; n_row = 0; for (n_row = 2; n_row <= FgItems.Rows.Count - 3; n_row++) { n_ele = 0; for (n_fil = 2; n_fil <= FgItems.Cols.Count - 4; n_fil++) { c_datos[n_ele] = Convert.ToDouble(funFunciones.NulosN(FgItems.GetData(n_row, n_fil))).ToString("0.00"); n_ele = n_ele + 1; } c_dato = HallarPromedio(c_datos).ToString("0.00"); FgItems.SetData(n_row, FgItems.Cols.Count - 1, c_dato); } funFlex.Flex_PintarCeldas(FgItems, FgItems.Rows.Count - 2, 1, FgItems.Rows.Count - 1, 14, Color.Black, Color.Coral); funFlex.Flex_PintarCeldas(FgItems, 2, FgItems.Cols.Count - 2, FgItems.Rows.Count - 1, FgItems.Cols.Count - 1, Color.Black, Color.LightCoral); MostrarPlanVenta(); }