public bool Delete(string empresaid, tb_plla_pdt_tabla22 BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPllaPdtTabla22_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { Sql_Error = ex.Message; throw new Exception(ex.Message); } } } }
public bool Update(string empresaid, tb_plla_pdt_tabla22 BE) { //return tablaDA.Update(empresaid, BE); bool zreturn = tablaDA.Update(empresaid, BE); Sql_Error = tablaDA.Sql_Error; return zreturn; }
public DataSet GetAll_Consulta(string empresaid, tb_plla_pdt_tabla22 BE) { //return tablaDA.GetAll_Consulta(empresaid, BE); DataSet xreturn = null; xreturn = tablaDA.GetAll_Consulta(empresaid, BE); Sql_Error = tablaDA.Sql_Error; return xreturn; }
public DataSet GetAll(string empresaid, tb_plla_pdt_tabla22 BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPllaPdtTabla22_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid; cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 120).Value = BE.rubroname; //cmd.Parameters.Add("@eEssaRegu", SqlDbType.Bit).Value = BE.eEssaRegu; //cmd.Parameters.Add("@eEssaPesq", SqlDbType.Bit).Value = BE.eEssaPesq; //cmd.Parameters.Add("@eEssaAgra", SqlDbType.Bit).Value = BE.eEssaAgra; //cmd.Parameters.Add("@eEssaSctr", SqlDbType.Bit).Value = BE.eEssaSctr; //cmd.Parameters.Add("@eImpextsolid", SqlDbType.Bit).Value = BE.eImpextsolid; //cmd.Parameters.Add("@eFdsartista", SqlDbType.Bit).Value = BE.eFdsartista; //cmd.Parameters.Add("@eSenati", SqlDbType.Bit).Value = BE.eSenati; //cmd.Parameters.Add("@tSnp", SqlDbType.Bit).Value = BE.tSnp; //cmd.Parameters.Add("@tSpp", SqlDbType.Bit).Value = BE.tSpp; //cmd.Parameters.Add("@tRenta5", SqlDbType.Bit).Value = BE.tRenta5; //cmd.Parameters.Add("@pEssaRegu", SqlDbType.Bit).Value = BE.pEssaRegu; //cmd.Parameters.Add("@pEssaCprev", SqlDbType.Bit).Value = BE.pEssaCprev; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { Sql_Error = ex.Message; throw new Exception(ex.Message); } } } }
private void Frm_Planilla_RubrosDescuento_Activated(object sender, EventArgs e) { if (Sw_LOad) { cmbfiltrotipoplanilla.ValueMember = "tipoplla"; cmbfiltrotipoplanilla.DisplayMember = "tipopllaname"; var BL = new tb_plla_tipoplanillaBL(); var BE = new tb_plla_tipoplanilla(); BE.norden = 1; BE.ver_blanco = 0; tmpcursor = BL.GetAll_Consulta(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; cmbfiltrotipoplanilla.SelectedValue = string.Empty; if (BL.Sql_Error.Length == 0) { cmbfiltrotipoplanilla.DataSource = tmpcursor; if (tmpcursor.Rows.Count > 0) { cmbfiltrotipoplanilla.SelectedValue = tmpcursor.Rows[0]["tipoplla"]; } } cmbmodalidad.ValueMember = "cele"; cmbmodalidad.DisplayMember = "descripcion"; var BL1 = new tb_plla_tab0100BL(); var BE1 = new tb_plla_tab0100(); BE1.ver_blanco = 1; cmbmodalidad.DataSource = BL1.gspTbPllaModalidadRubros(VariablesPublicas.EmpresaID.ToString(), BE1).Tables[0]; cmbtipocalculo.ValueMember = "cele"; cmbtipocalculo.DisplayMember = "descripcion"; var BL2 = new tb_plla_tab0100BL(); var BE2 = new tb_plla_tab0100(); BE2.ver_blanco = 1; cmbtipocalculo.DataSource = BL2.gspTbPllaTipoCalculoRubros(VariablesPublicas.EmpresaID.ToString(), BE2).Tables[0]; cmbtipo.ValueMember = "cele"; cmbtipo.DisplayMember = "descripcion"; var BL3 = new tb_plla_tab0100BL(); var BE3 = new tb_plla_tab0100(); BE3.ver_blanco = 1; cmbtipo.DataSource = BL3.GetTipoDescuento(VariablesPublicas.EmpresaID.ToString(), BE3).Tables[0]; RequeryTipoPlanilla(); cmbrubrorpts.ValueMember = "rubroid"; cmbrubrorpts.DisplayMember = "descripcion"; var BL4 = new tb_plla_pdt_tabla22BL(); var BE4 = new tb_plla_pdt_tabla22(); BE4.relrubroidtipo = GlobalVars.GetInstance().RubrosDescuentoRPTS; BE4.detallado = 1; BE4.norden = 1; BE4.incluir_blanco = 1; cmbrubrorpts.DataSource = BL4.GetAll_Consulta(VariablesPublicas.EmpresaID, BE4).Tables[0]; U_RefrescaControles(); CargaDatos(); U_RefrescaControles(); Sw_LOad = false; } }
private BindingSource NewMethoRRtps() { var BL = new tb_plla_pdt_tabla22BL(); var BE = new tb_plla_pdt_tabla22(); var table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; var rows = table.Rows; object[] cell; var dic = new Dictionary<string, string>(); var binding = new BindingSource(); foreach (DataRow item in rows) { cell = item.ItemArray; dic.Add(cell[0].ToString(), cell[0].ToString() + " " + cell[1].ToString()); cell = null; } binding.DataSource = dic; return binding; }
public DataSet GetAll_Consulta(string empresaid, tb_plla_pdt_tabla22 BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPllaPdtTabla22_CONSULTA", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid; cmd.Parameters.Add("@rubroidlikeleft", SqlDbType.VarChar, 4).Value = BE.rubroidlikeleft; cmd.Parameters.Add("@relrubroidtipo", SqlDbType.VarChar, 100).Value = BE.relrubroidtipo; cmd.Parameters.Add("@rubronamelike1", SqlDbType.VarChar, 120).Value = BE.rubronamelike1; cmd.Parameters.Add("@rubronamelike2", SqlDbType.VarChar, 120).Value = BE.rubronamelike2; cmd.Parameters.Add("@rubronamelike3", SqlDbType.VarChar, 120).Value = BE.rubronamelike3; cmd.Parameters.Add("@detallado", SqlDbType.Int).Value = BE.detallado; cmd.Parameters.Add("@norden", SqlDbType.Int).Value = BE.norden; cmd.Parameters.Add("@incluir_blanco", SqlDbType.Int).Value = BE.incluir_blanco; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { Sql_Error = ex.Message; throw new Exception(ex.Message); } } } }
public bool Update(string empresaid, tb_plla_pdt_tabla22 BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPllaPdtTabla22_UPDATE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid; cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 120).Value = BE.rubroname; cmd.Parameters.Add("@eEssaRegu", SqlDbType.Bit).Value = BE.eEssaRegu; cmd.Parameters.Add("@eEssaPesq", SqlDbType.Bit).Value = BE.eEssaPesq; cmd.Parameters.Add("@eEssaAgra", SqlDbType.Bit).Value = BE.eEssaAgra; cmd.Parameters.Add("@eEssaSctr", SqlDbType.Bit).Value = BE.eEssaSctr; cmd.Parameters.Add("@eImpextsolid", SqlDbType.Bit).Value = BE.eImpextsolid; cmd.Parameters.Add("@eFdsartista", SqlDbType.Bit).Value = BE.eFdsartista; cmd.Parameters.Add("@eSenati", SqlDbType.Bit).Value = BE.eSenati; cmd.Parameters.Add("@tSnp", SqlDbType.Bit).Value = BE.tSnp; cmd.Parameters.Add("@tSpp", SqlDbType.Bit).Value = BE.tSpp; cmd.Parameters.Add("@tRenta5", SqlDbType.Bit).Value = BE.tRenta5; cmd.Parameters.Add("@pEssaRegu", SqlDbType.Bit).Value = BE.pEssaRegu; cmd.Parameters.Add("@pEssaCprev", SqlDbType.Bit).Value = BE.pEssaCprev; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { Sql_Error = ex.Message; throw new Exception(ex.Message); } } } }