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