public DataSet GetAll(string empresaid, tb_constantesgenerales BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbConstantesgenerales_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.VarChar, 3).Value = BE.local;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@perimes", SqlDbType.Char, 2).Value = BE.perimes;
/*cmd.Parameters.Add("@tcamb", SqlDbType.Decimal).Value = BE.tcamb;
cmd.Parameters.Add("@igv", SqlDbType.Decimal).Value = BE.igv;*/
cmd.Parameters.Add("@inprec", SqlDbType.Char, 1).Value = BE.inprec;
cmd.Parameters.Add("@tipfactura", SqlDbType.Char, 2).Value = BE.tipfactura;
cmd.Parameters.Add("@tipboleta", SqlDbType.Char, 2).Value = BE.tipboleta;
cmd.Parameters.Add("@tipordprod", SqlDbType.Char, 2).Value = BE.tipordprod;
cmd.Parameters.Add("@tipordcomp", SqlDbType.Char, 2).Value = BE.tipordcomp;
cmd.Parameters.Add("@tipproforma", SqlDbType.Char, 2).Value = BE.tipproforma;
cmd.Parameters.Add("@tipguia1", SqlDbType.Char, 2).Value = BE.tipguia1;
cmd.Parameters.Add("@tipguia2", SqlDbType.Char, 2).Value = BE.tipguia2;
cmd.Parameters.Add("@tipguia3", SqlDbType.Char, 2).Value = BE.tipguia3;
cmd.Parameters.Add("@tipajusteing", SqlDbType.Char, 2).Value = BE.tipajusteing;
cmd.Parameters.Add("@tipajustesal", SqlDbType.Char, 2).Value = BE.tipajustesal;
cmd.Parameters.Add("@monedn", SqlDbType.Char, 1).Value = BE.monedn;
cmd.Parameters.Add("@monede", SqlDbType.Char, 1).Value = BE.monede;
cmd.Parameters.Add("@monedu", SqlDbType.Char, 1).Value = BE.monedu;
cmd.Parameters.Add("@monednsimbolo", SqlDbType.VarChar, 30).Value = BE.monednsimbolo;
cmd.Parameters.Add("@monedesimbolo", SqlDbType.VarChar, 30).Value = BE.monedesimbolo;
/*cmd.Parameters.Add("@posl1", SqlDbType.SmallInt).Value = BE.posl1;
cmd.Parameters.Add("@longl1", SqlDbType.SmallInt).Value = BE.longl1;
cmd.Parameters.Add("@posl2", SqlDbType.SmallInt).Value = BE.posl2;
cmd.Parameters.Add("@longl2", SqlDbType.SmallInt).Value = BE.longl2;
cmd.Parameters.Add("@posl3", SqlDbType.SmallInt).Value = BE.posl3;
cmd.Parameters.Add("@longl3", SqlDbType.SmallInt).Value = BE.longl3;*/
cmd.Parameters.Add("@descl1", SqlDbType.VarChar, 30).Value = BE.descl1;
cmd.Parameters.Add("@descl2", SqlDbType.VarChar, 30).Value = BE.descl2;
cmd.Parameters.Add("@descl3", SqlDbType.VarChar, 30).Value = BE.descl3;
/*cmd.Parameters.Add("@fechdigini", SqlDbType.DateTime).Value = BE.fechdigini;
cmd.Parameters.Add("@fechdigfin", SqlDbType.DateTime).Value = BE.fechdigfin;*/
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Delete(string empresaid, tb_constantesgenerales BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbConstantesgenerales_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.VarChar, 3).Value = BE.local;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update(string empresaid, tb_constantesgenerales BE)
{
return tablaDA.Update(empresaid, BE);
}
public bool Insert(string empresaid, tb_constantesgenerales BE)
{
return tablaDA.Insert(empresaid, BE);
}
public DataSet GetAll(string empresaid, tb_constantesgenerales BE)
{
return tablaDA.GetAll(empresaid, BE);
}
public bool Update(string empresaid, tb_constantesgenerales BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbConstantesgenerales_UPDATE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.VarChar, 3).Value = BE.local;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@perimes", SqlDbType.Char, 2).Value = BE.perimes;
cmd.Parameters.Add("@fechadocedit", SqlDbType.Bit).Value = BE.fechadocedit;
cmd.Parameters.Add("@tcamb", SqlDbType.Decimal).Value = BE.tcamb;
cmd.Parameters.Add("@igv", SqlDbType.Decimal).Value = BE.igv;
cmd.Parameters.Add("@inprec", SqlDbType.Char, 1).Value = BE.inprec;
cmd.Parameters.Add("@tipfactura", SqlDbType.Char, 2).Value = BE.tipfactura;
cmd.Parameters.Add("@tipboleta", SqlDbType.Char, 2).Value = BE.tipboleta;
cmd.Parameters.Add("@tipordprod", SqlDbType.Char, 2).Value = BE.tipordprod;
cmd.Parameters.Add("@tipordcomp", SqlDbType.Char, 2).Value = BE.tipordcomp;
cmd.Parameters.Add("@tipproforma", SqlDbType.Char, 2).Value = BE.tipproforma;
cmd.Parameters.Add("@tipguia1", SqlDbType.Char, 2).Value = BE.tipguia1;
cmd.Parameters.Add("@tipguia2", SqlDbType.Char, 2).Value = BE.tipguia2;
cmd.Parameters.Add("@tipguia3", SqlDbType.Char, 2).Value = BE.tipguia3;
cmd.Parameters.Add("@tipajusteing", SqlDbType.Char, 2).Value = BE.tipajusteing;
cmd.Parameters.Add("@tipajustesal", SqlDbType.Char, 2).Value = BE.tipajustesal;
cmd.Parameters.Add("@monedn", SqlDbType.Char, 1).Value = BE.monedn;
cmd.Parameters.Add("@monede", SqlDbType.Char, 1).Value = BE.monede;
cmd.Parameters.Add("@monedu", SqlDbType.Char, 1).Value = BE.monedu;
cmd.Parameters.Add("@monednsimbolo", SqlDbType.VarChar, 30).Value = BE.monednsimbolo;
cmd.Parameters.Add("@monedesimbolo", SqlDbType.VarChar, 30).Value = BE.monedesimbolo;
cmd.Parameters.Add("@posl1", SqlDbType.SmallInt).Value = BE.posl1;
cmd.Parameters.Add("@longl1", SqlDbType.SmallInt).Value = BE.longl1;
cmd.Parameters.Add("@posl2", SqlDbType.SmallInt).Value = BE.posl2;
cmd.Parameters.Add("@longl2", SqlDbType.SmallInt).Value = BE.longl2;
cmd.Parameters.Add("@posl3", SqlDbType.SmallInt).Value = BE.posl3;
cmd.Parameters.Add("@longl3", SqlDbType.SmallInt).Value = BE.longl3;
cmd.Parameters.Add("@descl1", SqlDbType.VarChar, 30).Value = BE.descl1;
cmd.Parameters.Add("@descl2", SqlDbType.VarChar, 30).Value = BE.descl2;
cmd.Parameters.Add("@descl3", SqlDbType.VarChar, 30).Value = BE.descl3;
cmd.Parameters.Add("@fechdigini", SqlDbType.DateTime).Value = BE.fechdigini;
cmd.Parameters.Add("@fechdigfin", SqlDbType.DateTime).Value = BE.fechdigfin;
cmd.Parameters.Add("@ctactecli", SqlDbType.Char, 7).Value = BE.ctacteclie;
cmd.Parameters.Add("@ctacteinv", SqlDbType.Char, 7).Value = BE.ctacteinv;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void get_constantesGen(String dominioid, String moduloid, String local)
{
constantesgeneralesBL BL = new constantesgeneralesBL();
tb_constantesgenerales BE = new tb_constantesgenerales();
DataTable dt = new DataTable();
try
{
dt = BL.GetOne(VariablesPublicas.EmpresaID, dominioid, moduloid, local).Tables[0];
VariablesPublicas.perianio = dt.Rows[0]["perianio"].ToString().Trim();
VariablesPublicas.perimes = dt.Rows[0]["perimes"].ToString().Trim();
VariablesPublicas.igv = dt.Rows[0]["igv"].ToString().Trim();
VariablesPublicas.fechdigini = dt.Rows[0]["fechdigini"].ToString().Trim();
VariablesPublicas.fechdigfin = dt.Rows[0]["fechdigfin"].ToString().Trim();
}
catch (Exception ex)
{
ex.ToString();
VariablesPublicas.perianio = "";
VariablesPublicas.perimes = "";
VariablesPublicas.igv = "";
VariablesPublicas.fechdigini = "";
VariablesPublicas.fechdigfin = "";
MessageBoxEx.Show("Registrar en constantes Generales !!!", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Update()
{
var BL = new constantesgeneralesBL();
var BE = new tb_constantesgenerales();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.perianio = sperianio.SelectedItem.ToString();
BE.perimes = sperimes.SelectedValue.ToString().Trim().PadLeft(2, '0');
BE.tcamb = Convert.ToDecimal(tcamb.Text.Trim());
BE.igv = Convert.ToDecimal(igv.Text.Trim().ToUpper());
BE.inprec = inprec.Text.Trim().ToUpper();
BE.tipfactura = tipfactura.Text.Trim().ToUpper();
BE.tipboleta = tipboleta.Text.Trim().ToUpper();
BE.tipordprod = tipordprod.Text.Trim().ToUpper();
BE.tipordcomp = tipordcomp.Text.Trim().ToUpper();
BE.tipproforma = tipproforma.Text.Trim().ToUpper();
BE.tipguia1 = tipguia1.Text.Trim().ToUpper();
BE.tipguia2 = tipguia2.Text.Trim().ToUpper();
BE.tipguia3 = tipguia3.Text.Trim().ToUpper();
BE.tipajusteing = tipajusteing.Text.Trim().ToUpper();
BE.tipajustesal = tipajustesal.Text.Trim().ToUpper();
BE.monedn = monedn.Text.Trim().ToUpper();
BE.monede = monede.Text.Trim().ToUpper();
BE.monedu = monedu.Text.Trim().ToUpper();
BE.monednsimbolo = monednsimbolo.Text.Trim().ToUpper();
BE.monedesimbolo = monedesimbolo.Text.Trim().ToUpper();
BE.posl1 = Convert.ToInt16(posl1.Text.Trim().ToUpper());
BE.longl1 = Convert.ToInt16(longl1.Text.Trim().ToUpper());
BE.posl2 = Convert.ToInt16(posl2.Text.Trim().ToUpper());
BE.longl2 = Convert.ToInt16(longl2.Text.Trim().ToUpper());
BE.posl3 = Convert.ToInt16(posl3.Text.Trim().ToUpper());
BE.longl3 = Convert.ToInt16(longl3.Text.Trim().ToUpper());
BE.descl1 = descl1.Text.Trim().ToUpper();
BE.descl2 = descl2.Text.Trim().ToUpper();
BE.descl3 = descl3.Text.Trim().ToUpper();
if (fechdigini.Text.Trim().Length == 0)
{
BE.fechdigini = Convert.ToDateTime("01/01/1900");
}
else
{
BE.fechdigini = Convert.ToDateTime(fechdigini.Text.Trim());
}
if (fechdigfin.Text.Trim().Length == 0)
{
BE.fechdigfin = Convert.ToDateTime("01/01/1900");
}
else
{
BE.fechdigfin = Convert.ToDateTime(fechdigfin.Text.Trim());
}
BE.ctacteclie = "0000308";
BE.ctacteinv = "0007483";
try
{
if (BL.Update(EmpresaID, BE))
{
if ((perianio != sperianio.SelectedValue) || (perimes != sperimes.SelectedValue))
{
Close();
VariablesPublicas.CerrarSession = true;
DL0Logistica.MainLogistica.ActiveForm.Close();
}
}
else
{
MessageBox.Show("Contacte con Sistemas");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Delete()
{
var BL = new constantesgeneralesBL();
var BE = new tb_constantesgenerales();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
try
{
if (BL.Delete(EmpresaID, BE))
{
MessageBox.Show("Se eliminó con éxito");
Nuevo();
}
else
{
MessageBox.Show("Contactese con Sistemas");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Insert()
{
var BL = new constantesgeneralesBL();
var BE = new tb_constantesgenerales();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.perianio = sperianio.SelectedItem.ToString();
BE.perimes = sperimes.SelectedValue.ToString().Trim().PadLeft(2, '0');
BE.tcamb = (tcamb.Text.Trim() == string.Empty) ? 0 : Convert.ToDecimal(tcamb.Text.Trim());
BE.igv = (igv.Text.Trim() == string.Empty) ? 18 : Convert.ToDecimal(igv.Text.Trim());
BE.inprec = inprec.Text.Trim().ToUpper();
BE.tipfactura = tipfactura.Text.Trim().ToUpper();
BE.tipboleta = tipboleta.Text.Trim().ToUpper();
BE.tipordprod = tipordprod.Text.Trim().ToUpper();
BE.tipordcomp = tipordcomp.Text.Trim().ToUpper();
BE.tipproforma = tipproforma.Text.Trim().ToUpper();
BE.tipguia1 = tipguia1.Text.Trim().ToUpper();
BE.tipguia2 = tipguia2.Text.Trim().ToUpper();
BE.tipguia3 = tipguia3.Text.Trim().ToUpper();
BE.tipajusteing = tipajusteing.Text.Trim().ToUpper();
BE.tipajustesal = tipajustesal.Text.Trim().ToUpper();
BE.monedn = monedn.Text.Trim().ToUpper();
BE.monede = monede.Text.Trim().ToUpper();
BE.monedu = monedu.Text.Trim().ToUpper();
BE.monednsimbolo = monednsimbolo.Text.Trim().ToUpper();
BE.monedesimbolo = monedesimbolo.Text.Trim().ToUpper();
BE.posl1 = Convert.ToInt16((posl1.Text.Trim() == string.Empty) ? "0" : posl1.Text.Trim());
BE.longl1 = Convert.ToInt16((longl1.Text.Trim() == string.Empty) ? "0" : longl1.Text.Trim());
BE.posl2 = Convert.ToInt16((posl2.Text.Trim() == string.Empty) ? "0" : posl2.Text.Trim());
BE.longl2 = Convert.ToInt16((longl2.Text.Trim() == string.Empty) ? "0" : longl2.Text.Trim());
BE.posl3 = Convert.ToInt16((posl3.Text.Trim() == string.Empty) ? "0" : posl3.Text.Trim());
BE.longl3 = Convert.ToInt16((longl3.Text.Trim() == string.Empty) ? "0" : longl3.Text.Trim());
BE.descl1 = descl1.Text.Trim().ToUpper();
BE.descl2 = descl2.Text.Trim().ToUpper();
BE.descl3 = descl3.Text.Trim().ToUpper();
BE.fechdigini = (fechdigini.Text.Trim().Length == 0) ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(fechdigini.Text.Trim());
BE.fechdigfin = (fechdigfin.Text.Trim().Length == 0) ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(fechdigfin.Text.Trim());
try
{
if (BL.Insert(EmpresaID, BE))
{
if ((perianio != sperianio.SelectedValue) || (perimes != sperimes.SelectedValue))
{
Close();
VariablesPublicas.CerrarSession = true;
MainMercaderia.ActiveForm.Close();
}
}
else
{
MessageBox.Show("Conectese Con Sistemas", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void get_val_fechadoc()
{
try
{
constantesgeneralesBL BL = new constantesgeneralesBL();
tb_constantesgenerales BE = new tb_constantesgenerales();
DataTable dt = new DataTable();
dt = BL.GetOne(EmpresaID, dominio, modulo, local).Tables[0];
if (dt.Rows.Count > 0)
{
perianio = dt.Rows[0]["perianio"].ToString().Trim();
// Vamos Obtener el Check de Perimes Local Para Usar el Perimes de Constanantes o del Bapconfig
var BL2 = new sys_localBL();
var BE2 = new tb_sys_local();
DataTable dt2 = new DataTable();
BE2.dominioid = dominio.ToString();
BE2.moduloid = modulo.ToString(); ;
BE2.local = local.ToString();
dt2 = BL2.GetAll(VariablesPublicas.EmpresaID, BE2).Tables[0];
if (dt2.Rows.Count > 0)
{
if (Convert.ToBoolean(dt2.Rows[0]["perimeslocal"]))
{
// Hemos Fijado el Perimes en BapConfig
perimes = _perimes;
}
else
{
// Ponemos el Perimes de Constantes Generales
perimes = dt.Rows[0]["perimes"].ToString().Trim();
}
}
if (dt.Rows[0]["fechadocedit"].ToString().Trim().Length > 0)
{
fechadocedit = Convert.ToBoolean(dt.Rows[0]["fechadocedit"]);
}
}
DateTime fechaactual = DateTime.Today;
DateTime fechaperiodo = Convert.ToDateTime("01" + "/" + perimes + "/" + perianio);
if (fechadocedit)
{
//DateTime primerdia = new DateTime(fechaperiodo.Year, fechaperiodo.Month, 1);
//DateTime ultimodia = primerdia.AddMonths(1).AddDays(-1);
//if (fechaactual.Day <= ultimodia.Day)
//{
// fechdoc.Value = Convert.ToDateTime(fechaactual.Day + "/" + perimes + "/" + perianio);
//}
//else
//{
// fechdoc.Value = Convert.ToDateTime(ultimodia.Day + "/" + perimes + "/" + perianio);
//}
//fechdoc.MaxDate = ultimodia;
//fechdoc.MinDate = primerdia;
}
else
{
if (fechaactual.Month == fechaperiodo.Month && fechaactual.Year == fechaperiodo.Year)
{
fechdoc.Value = fechaactual;
//fechdoc.Enabled = false;
}
else
{
MessageBox.Show("Actualizar a Periodo Actual en Tabla Constantes Generales !!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
statusDoc = false;
}
}
get_tipocambio(fechdoc.Text);
get_tipimptoid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
statusDoc = false;
}
}