コード例 #1
0
ファイル: Nomina.cs プロジェクト: daguilae/HRM
        private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)
        {
            codEmps = new List<int>();
            eSTADO_NOMINATextBox.Text = "1";

            hRM_ENC_NOMINABindingNavigatorSaveItem.Enabled = true;
            ClaseConexion conn2 = new ClaseConexion();
            hRM_DET_NOMINADataGridView.Visible = false;
            dataGridView1.Visible = true;
            string consultagrid = "SELECT HRM_EMPLEADO.COD_EMPLEADO, NOM_PRIMARIO, APELLIDOS, SALARIO, TIPO_INGRESO, VAL_INGRESO, TIPO_DEDUCCION, SALARIO * (VAL_DEDUCCION / 100) as Descuento, VAL_INGRESO + (SALARIO - SALARIO * (VAL_DEDUCCION / 100)) as Sueldo_Neto FROM  [Nomina].[dbo].[HRM_EMPLEADO] inner join Nomina.dbo.HRM_MADEDUCCION on HRM_EMPLEADO.COD_AREA = HRM_MADEDUCCION.COD_EMPLEADO inner join Nomina.dbo.HRM_ENC_DEDUCCION on HRM_MADEDUCCION.COD_ENC_DEDUCCION = HRM_ENC_DEDUCCION.COD_ENC_DEDUCCION  inner join  Nomina.dbo.HRM_DEDUCCION on HRM_ENC_DEDUCCION.COD_ENC_DEDUCCION = HRM_DEDUCCION.COD_ENC_DEDUCCION, Nomina.dbo.HRM_INGRESO ";
            //SqlCommand ejecugrid = new SqlCommand(consultagrid, conn);
            //ejecugrid.ExecuteNonQuery();
            DataTable tabla = new DataTable();
            SqlDataAdapter consultag2 = new SqlDataAdapter(consultagrid, conn2.abrirconexion());
            consultag2.Fill(tabla);
            dataGridView1.DataSource = tabla;
            //Me.DataGridView3.DefaultCellStyle.WrapMode = DataGridViewTriState.True
            this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
               int rango = dataGridView1.Rows.Count;
               Console.WriteLine(rango);
               try
               {

               foreach (DataGridViewRow row in dataGridView1.Rows)
               {
                   // string valorcol2 = row.Cells[1].Text;
                   codEmps.Add(Convert.ToInt32(row.Cells[0].Value));
                   brutos.Add(Convert.ToDecimal(row.Cells[3].Value));
                   netos.Add(Convert.ToDecimal(row.Cells[8].Value));
                   String seleccionaencombo = row.Cells[3].Value.ToString() + " " +row.Cells[8].Value.ToString();
                   Console.WriteLine(seleccionaencombo);
               }
               }
               catch (Exception)
               {

               }

            //for (int it = 0; it < rango -1; it++)
            //{
            //    Console.WriteLine(it);
            //    String seleccionaencombo = Convert.ToDecimal(dataGridView1.Rows.SharedRow(it).Cells[3].Value);
            //    Console.WriteLine(seleccionaencombo.ToString());
            ////    //String seleccionaencombo2 = dataGridView1.Rows.SharedRow(i).Cells[7].Value.ToString();
            ////    //Console.WriteLine(seleccionaencombo2);
            //}
               fEC_NOMINADateTimePicker.Text = "";
               fEC_PERIODODateTimePicker.Text = "";
        }
コード例 #2
0
ファイル: DeduccionXarea.cs プロジェクト: daguilae/HRM
        private void DeduccionXarea_Load(object sender, EventArgs e)
        {
            DataGridView3.Visible = false;

             SqlConnection conn = new SqlConnection(connstring);
            conn.Open();
               ClaseConexion conn2 = new ClaseConexion();

            SqlDataAdapter consulta3 = new SqlDataAdapter("SELECT TOP 1000 [COD_AREA] as Codigo, [DES_AREA] as Area, [ESTADO_AREA] as Estado FROM [Nomina].[dbo].[HRM_AREA]", conn2.abrirconexion());

            DataSet ds = new DataSet();
            consulta3.Fill(ds, "HRM_AREA");
            ComboBox1.DataSource = ds.Tables[0];
            ComboBox1.ValueMember = "Area";

            SqlDataAdapter consulta2 = new SqlDataAdapter("SELECT TOP 1000 [COD_ENC_DEDUCCION], [TIPO_DEDUCCION], [ESTADO_DEDU] FROM [Nomina].[dbo].[HRM_ENC_DEDUCCION]", conn2.abrirconexion());
            DataSet ds2 = new DataSet();
            consulta2.Fill(ds2, "HRM_ENC_DEDUCCION");
            ComboBox2.DataSource = ds2.Tables[0];
            ComboBox2.ValueMember = "TIPO_DEDUCCION";

            //SqlDataAdapter consulta = new SqlDataAdapter("SELECT TOP 1000 [COD_AREA], [DES_AREA], [ESTADO_AREA] FROM [Nomina].[dbo].[HRM_AREA] INNER JOIN [Nomina].[dbo].[HRM_MADEDUCCION] ON HRM_AREA.COD_AREA = HRM_MADEDUCCION.COD_EMPLEADO", conn);
            //SqlDataAdapter consulta = new SqlDataAdapter("SELECT TOP 1000 [COD_AREA] as Codigo, [DES_AREA] as Area, [ESTADO_AREA] as Estado FROM [Nomina].[dbo].[HRM_AREA] where ESTADO_AREA = 1", conn2.abrirconexion());

            //    DataSet ds3 = new DataSet();
            //consulta.Fill(ds3, "HRM_AREA");
            //DataGridView2.DataSource = ds3.Tables[0];
            //DataGridView2.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
            //DataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            string consulta = "SELECT COD_AREA as Codigo, DES_AREA as Area, ESTADO_AREA as Estado FROM Nomina.dbo.HRM_AREA where ESTADO_AREA like '%1%' ";
               DataTable tabla = new DataTable();

            SqlDataAdapter consulta5 = new SqlDataAdapter(consulta, conn2.abrirconexion());
            consulta5.Fill(tabla);
            DataGridView2.DataSource = tabla;
            DataGridView2.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
            DataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            conn.Close();
        }
コード例 #3
0
ファイル: DeduccionXarea.cs プロジェクト: daguilae/HRM
        private void Button1_Click(object sender, EventArgs e)
        {
            ClaseConexion conn2 = new ClaseConexion();
            //DataGridView1.Rows.Add(ComboBox2.Text);
            DataGridViewRow row = new DataGridViewRow();
            row.SetValues(ComboBox2.Text);

            //for (int i = 0; i < DataGridView1.Rows.Count - 1; i++)
            //{
                //if (DataGridView1.Rows.SharedRow(i).Cells[0].Value.ToString() != ComboBox2.SelectedText)
                //{
                    //DataGridView1.Rows.Add(ComboBox2.Text);
               // }

               // }
                    List<String> datos = new List<string>();

                    for (int i = 0; i < DataGridView1.Rows.Count - 1; i++)
                    {
                        string dato;
                        dato = DataGridView1.Rows.SharedRow(i).Cells[0].Value.ToString();
                        //DataGridView1.Rows.Add(ComboBox2.Text);
                        //DataGridView1.DataSource
                        datos.Add(dato);
                    }
                    if (datos.Contains(ComboBox2.Text))
                    {
                        Console.WriteLine("repetido");
                    }
                    else {
                        //nuevos = new List<int>();
                        DataGridView1.Rows.Add(ComboBox2.Text);
                        string tipo = ComboBox2.SelectedValue.ToString();
                        SqlCommand consultan = new SqlCommand("SELECT TOP 1 [COD_ENC_DEDUCCION] FROM [Nomina].[dbo].[HRM_ENC_DEDUCCION] where HRM_ENC_DEDUCCION.TIPO_DEDUCCION like '%" + tipo + "%'", conn2.abrirconexion());
                        int encdeduccion = Convert.ToInt32(consultan.ExecuteScalar());
                        //int encdeduccion = ;//.Columns[0].ToString());
                        //Console.WriteLine(encdeduccion);
                        //listadetalles.Add(encdeduccion);
                        nuevos.Add(encdeduccion);
                        //Console.WriteLine("repetido");
                    }
        }
コード例 #4
0
ファイル: Nomina.cs プロジェクト: daguilae/HRM
        private void hRM_ENC_NOMINABindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.hRM_ENC_NOMINABindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.nominaDataSet);
            ClaseConexion conn2 = new ClaseConexion();
            SqlCommand consultan = new SqlCommand("SELECT TOP 1 [COD_ENCNOMINA] FROM [Nomina].[dbo].[HRM_ENC_NOMINA] order by COD_ENCNOMINA desc", conn2.abrirconexion());
            int encnomina = Convert.ToInt32(consultan.ExecuteScalar());
            int Contro = 0;
            try
            {
                foreach (int i2 in codEmps)
                {

                    Console.WriteLine("insert");
                    Console.WriteLine(i2);

                    string inserta = "INSERT INTO [dbo].[HRM_DET_NOMINA]([CAN_SUELDOBRUTO],[CAN_SUELDONETO],[COD_EMPLEADO],[COD_ENCNOMINA]) VALUES (@bruto, @neto, @codemple, @encnomina)";

                    SqlCommand Comando = new SqlCommand(inserta, conn2.abrirconexion());
                    Comando.Parameters.AddWithValue("@bruto", brutos[Contro]);
                    Comando.Parameters.AddWithValue("@neto", netos[Contro]);
                    Comando.Parameters.AddWithValue("@codemple", i2);
                    Comando.Parameters.AddWithValue("@encnomina", encnomina);
                    Comando.ExecuteNonQuery();
                    Contro++;
                }
            }
            catch (Exception)
            {
            }
        }