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