public bool Delete(string empresaid, tb_modulo_local_tipodoc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbModuloLocalTipodoc_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.Char, 3).Value = BE.local;
cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll(string empresaid, tb_modulo_local_tipodoc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbModuloLocalTipodoc_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.Char, 3).Value = BE.local;
cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc;
cmd.Parameters.Add("@tipodocname", SqlDbType.VarChar, 40).Value = BE.tipodocname;
cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid;
cmd.Parameters.Add("@tipodoccontratipo", SqlDbType.Char, 2).Value = BE.tipodoccontratipo;
cmd.Parameters.Add("@tipodoctipotransac", SqlDbType.Char, 1).Value = BE.tipodoctipotransac;
cmd.Parameters.Add("@tipodocstatcostopromed", SqlDbType.Char, 1).Value = BE.tipodocstatcostopromed;
cmd.Parameters.Add("@ctacteaccionid", SqlDbType.Char, 2).Value = BE.ctacteaccionid;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void data_cbo_tipodocalt()
{
try
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.visiblealmac = true;
BE.status = string.Empty;
BE.tipodoctipotransac = "A";
cmbtipdocalt.DataSource = BL.GetAll_mov(EmpresaID, BE).Tables[0];
cmbtipdocalt.ValueMember = "tipodoc";
cmbtipdocalt.DisplayMember = "tipodocname";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataSet GetAll_mov(string empresaid, tb_modulo_local_tipodoc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbModuloLocalTipodoc_SEARCH_mov", 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.Char, 3).Value = BE.local;
cmd.Parameters.Add("@visiblealmac", SqlDbType.Bit).Value = BE.visiblealmac;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
cmd.Parameters.Add("@tipodoctipotransac", SqlDbType.Char,1).Value = BE.tipodoctipotransac;
cmd.Parameters.Add("@filtro", SqlDbType.Char, 1).Value = BE.filtro;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update(string empresaid, tb_modulo_local_tipodoc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbModuloLocalTipodoc_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.Char, 3).Value = BE.local;
cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc;
cmd.Parameters.Add("@tipodocname", SqlDbType.VarChar, 40).Value = BE.tipodocname;
cmd.Parameters.Add("@tipodocmanejaserie", SqlDbType.Bit).Value = BE.tipodocmanejaserie;
cmd.Parameters.Add("@tipodocnumero", SqlDbType.Decimal).Value = BE.tipodocnumero;
cmd.Parameters.Add("@tipodocautomatico", SqlDbType.Bit).Value = BE.tipodocautomatico;
cmd.Parameters.Add("@tipodocnumcopias", SqlDbType.Int).Value = BE.tipodocnumcopias;
cmd.Parameters.Add("@almacaccionid", SqlDbType.Char, 2).Value = BE.almacaccionid;
cmd.Parameters.Add("@tipodoccontratipo", SqlDbType.Char, 2).Value = BE.tipodoccontratipo;
cmd.Parameters.Add("@tipodoctipotransac", SqlDbType.Char, 1).Value = BE.tipodoctipotransac;
cmd.Parameters.Add("@tipodocstatcostopromed", SqlDbType.Char, 1).Value = BE.tipodocstatcostopromed;
cmd.Parameters.Add("@ctacteaccionid", SqlDbType.Char, 2).Value = BE.ctacteaccionid;
cmd.Parameters.Add("@visiblealmac", SqlDbType.Bit).Value = BE.visiblealmac;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_paginacion(string empresaid, tb_modulo_local_tipodoc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbModuloLocalTipodoc_SEARCH_paginacion", 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.Char, 3).Value = BE.local;
cmd.Parameters.Add("@tipodoc", SqlDbType.Char, 2).Value = BE.tipodoc;
cmd.Parameters.Add("@posicion", SqlDbType.VarChar, 10).Value = BE.posicion;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
void CargarComboTipodoc()
{
try
{
modulo_local_tipodocBL BL = new modulo_local_tipodocBL();
tb_modulo_local_tipodoc BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.visiblealmac = true;
BE.filtro = "1";
BE.status = "";
BE.tipodoctipotransac = "A";
// = BL.GetAll_mov(EmpresaID, BE).Tables[0];
//cmb_tipodoc.ValueMember = "tipodoc";
//cmb_tipodoc.DisplayMember = "tipodocname";
cbo_tipodoc.Properties.DataSource = BL.GetAll_mov(EmpresaID, BE).Tables[0];
cbo_tipodoc.Properties.ValueMember = "tipodoc";
cbo_tipodoc.Properties.DisplayMember = "tipodocname";
cbo_tipodoc.EditValue = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void data_cbo_tipodoc()
{
try
{
modulo_local_tipodocBL BL = new modulo_local_tipodocBL();
tb_modulo_local_tipodoc BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.visiblealmac = true;
BE.status = "";
tipodoc.DataSource = BL.GetAll_mov(EmpresaID, BE).Tables[0];
tipodoc.ValueMember = "tipodoc";
tipodoc.DisplayMember = "tipodocname";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Delete()
{
try
{
if (dominioid.Text.Trim().Length != 2 || moduloid.Text.Trim().Length != 4 || xlocal.Text.Trim().Length != 3)
{
MessageBox.Show("Falata datos en Dominio - Modulo - Local !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (tipodoc.Text.Trim().Length != 2)
{
MessageBox.Show("Falta Tipo de Documento !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominioid.Text.Trim();
BE.moduloid = moduloid.Text.Trim();
BE.local = xlocal.Text.Trim();
BE.tipodoc = tipodoc.Text.Trim().ToUpper();
BE.usuar = VariablesPublicas.Usuar.Trim();
if (BL.Delete(EmpresaID, BE))
{
SEGURIDAD_LOG("E");
MessageBox.Show("Datos Eliminado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
NIVEL_FORMS();
limpiar_documento();
form_bloqueado(false);
data_Tablatipodoc();
btn_nuevo.Enabled = true;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void form_cargar_datos(String posicion)
{
try
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
var dt = new DataTable();
BE.dominioid = dominioid.Text.Trim();
BE.moduloid = moduloid.Text.Trim();
BE.local = xlocal.Text.Trim();
BE.tipodoc = tipodoc.Text.Trim();
BE.posicion = posicion.Trim();
dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
ssModo = "EDIT";
limpiar_documento();
dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim();
dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim();
moduloid.Text = dt.Rows[0]["moduloid"].ToString().Trim();
moduloname.Text = dt.Rows[0]["moduloname"].ToString().Trim();
xlocal.Text = dt.Rows[0]["local"].ToString().Trim();
localname.Text = dt.Rows[0]["localname"].ToString().Trim();
tipodoc.Text = dt.Rows[0]["tipodoc"].ToString().Trim();
tipodocname.Text = dt.Rows[0]["tipodocname"].ToString().Trim();
if (dt.Rows[0]["tipodocmanejaserie"].ToString().Trim().Length > 0)
{
tipodocmanejaserie.Checked = Convert.ToBoolean(dt.Rows[0]["tipodocmanejaserie"]);
if (tipodocmanejaserie.Checked)
{
tabControl1.TabPages.Add(tabtipodocserie);
}
}
if (dt.Rows[0]["tipodocautomatico"].ToString().Trim().Length > 0)
{
tipodocautomatico.Checked = Convert.ToBoolean(dt.Rows[0]["tipodocautomatico"]);
}
if (dt.Rows[0]["visiblealmac"].ToString().Trim().Length > 0)
{
visiblealmac.Checked = Convert.ToBoolean(dt.Rows[0]["visiblealmac"]);
}
tipodocnumero.Text = dt.Rows[0]["tipodocnumero"].ToString().Trim();
tipodocnumcopias.Text = dt.Rows[0]["tipodocnumcopias"].ToString().Trim();
almacaccionid.Text = dt.Rows[0]["almacaccionid"].ToString().Trim();
tipodoccontratipo.Text = dt.Rows[0]["tipodoccontratipo"].ToString().Trim();
tipodoctipotransac.Text = dt.Rows[0]["tipodoctipotransac"].ToString().Trim();
tipodocstatcostopromed.Text = dt.Rows[0]["tipodocstatcostopromed"].ToString().Trim();
ctacteaccionid.Text = dt.Rows[0]["ctacteaccionid"].ToString().Trim();
manejaastocont.Text = dt.Rows[0]["manejaastocont"].ToString().Trim();
btn_editar.Enabled = true;
btn_eliminar.Enabled = true;
btn_imprimir.Enabled = true;
btn_primero.Enabled = true;
btn_anterior.Enabled = true;
btn_siguiente.Enabled = true;
btn_ultimo.Enabled = true;
btn_buscar.Enabled = true;
btn_log.Enabled = true;
btn_salir.Enabled = true;
}
else
{
limpiar_documento();
btn_editar.Enabled = false;
btn_eliminar.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_Tablatipodoc()
{
try
{
if (Tablatipodoc.Rows.Count > 0)
{
Tablatipodoc.Rows.Clear();
}
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominioid.Text.Trim();
BE.moduloid = moduloid.Text.Trim();
BE.local = xlocal.Text.Trim();
switch (cbo_buscar.SelectedValue.ToString())
{
case "01":
BE.tipodocname = txt_criterio.Text.Trim();
break;
case "02":
if (txt_criterio.Text.Trim().Length > 0)
{
BE.tipodoc = txt_criterio.Text.Trim().ToUpper();
}
break;
case "03":
BE.tipodocmanejaserie = true;
break;
case "04":
BE.tipodocautomatico = true;
break;
default:
break;
}
Tablatipodoc = BL.GetAll(EmpresaID, BE).Tables[0];
if (Tablatipodoc.Rows.Count > 0)
{
btn_imprimir.Enabled = true;
gridtipodoc.DataSource = Tablatipodoc;
gridtipodoc.Rows[0].Selected = false;
gridtipodoc.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ValidaTipodoc_nuevo()
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
var dt = new DataTable();
BE.dominioid = dominioid.Text.Trim();
BE.moduloid = moduloid.Text.Trim();
BE.local = xlocal.Text.Trim();
BE.tipodoc = tipodoc.Text.Trim();
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count == 0)
{
mensaje.Text = "VALIDO";
mensaje.ForeColor = Color.Green;
form_bloqueado(true);
tipodocname.Focus();
dominioid.Enabled = false;
moduloid.Enabled = false;
xlocal.Enabled = false;
btn_cancelar.Enabled = true;
btn_grabar.Enabled = true;
}
else
{
mensaje.Text = "YA EXISTE";
mensaje.ForeColor = Color.Red;
tipodoc.Text = string.Empty;
}
}
private void Update()
{
try
{
if (dominioid.Text.Trim().Length != 2 || moduloid.Text.Trim().Length != 4 || xlocal.Text.Trim().Length != 3)
{
MessageBox.Show("Falata datos en Dominio - Modulo - Local !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (tipodoc.Text.Trim().Length != 2)
{
MessageBox.Show("Falta Tipo de Documento !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (tipodocname.Text.Trim().Length == 0)
{
MessageBox.Show("Ingrese nombre de Documento", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominioid.Text.Trim();
BE.moduloid = moduloid.Text.Trim();
BE.local = xlocal.Text.Trim();
BE.tipodoc = tipodoc.Text.Trim().ToUpper();
BE.tipodocname = tipodocname.Text.Trim().ToUpper();
BE.tipodocmanejaserie = tipodocmanejaserie.Checked;
BE.tipodocautomatico = tipodocautomatico.Checked;
BE.visiblealmac = visiblealmac.Checked;
BE.tipodocnumero = Convert.ToDecimal(tipodocnumero.Text.Trim().PadLeft(1, '0'));
BE.tipodocnumcopias = Convert.ToInt16(tipodocnumcopias.Text.Trim().PadLeft(1, '0'));
BE.almacaccionid = almacaccionid.Text.Trim().ToUpper();
BE.tipodoccontratipo = tipodoccontratipo.Text.Trim().ToUpper();
BE.tipodoctipotransac = tipodoctipotransac.Text.Trim().ToUpper();
BE.tipodocstatcostopromed = tipodocstatcostopromed.Text.Trim().ToUpper();
BE.ctacteaccionid = ctacteaccionid.Text.Trim().ToUpper();
BE.manejaastocont = manejaastocont.Text.Trim().ToUpper();
BE.usuar = VariablesPublicas.Usuar.Trim();
BE.status = "0";
if (BL.Update(EmpresaID, BE))
{
SEGURIDAD_LOG("M");
MessageBox.Show("Datos modificado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_cbo_tiporeferencia(string accion)
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.almacaccionid = Convert.ToString(Convert.ToInt16(accion) + 1);
BE.visiblealmac = true;
try
{
tipref.DataSource = BL.GetAll(EmpresaID, BE).Tables[0];
tipref.ValueMember = "tipodoc";
tipref.DisplayMember = "tipodocname";
tipref.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void CargarTipoDoc()
{
try
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.visiblealmac = true;
BE.status = string.Empty;
BE.tipodoctipotransac = "M";
cmb_tipdoc.DataSource = BL.GetAll_mov(EmpresaID, BE).Tables[0];
cmb_tipdoc.ValueMember = "almacaccionid";
cmb_tipdoc.DisplayMember = "tipodoc";
cmb_tipdoc.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void select_tipodoc()
{
try
{
if (tipodoc.SelectedValue.ToString() != "00" && tipodoc.SelectedIndex != 0)
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
var dt = new DataTable();
BE.dominioid = dominio;
BE.moduloid = modulo;
BE.local = local;
BE.tipodoc = tipodoc.SelectedValue.ToString().Trim();
BE.visiblealmac = true;
dt = BL.GetAll(EmpresaID, BE).Tables[0];
almacaccionid = dt.Rows[0]["almacaccionid"].ToString().Trim();
tipodocautomatico = Convert.ToBoolean(dt.Rows[0]["tipodocautomatico"]);
tipodocmanejaserie = Convert.ToBoolean(dt.Rows[0]["tipodocmanejaserie"]);
if (almacaccionid.Trim().Length > 0)
{
if (tipodocautomatico)
{
if (tipodocmanejaserie)
{
get_autoCS_numMov();
}
else
{
MessageBox.Show("Documento debe manejar Serie", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
statusDoc = false;
}
}
else
{
if (tipodocmanejaserie)
{
get_autoCS_numMov();
numdoc.Enabled = true;
}
else
{
MessageBox.Show("Documento debe manejar Serie", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
statusDoc = false;
}
}
if (almacaccionid.Substring(0, 1) == "2")
{
tipoclieprov.Text = "Cliente:";
lbl_valor.Text = "Cost.Prom";
}
else
{
lbl_valor.Text = "Cost.Ultm";
tipoclieprov.Text = "Proveedor:";
}
data_cbo_tipooperacion(almacaccionid.Substring(0, 1));
data_cbo_tiporeferencia(almacaccionid);
}
else
{
MessageBox.Show("Asignar la Accion del Documento", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
statusDoc = false;
}
}
else
{
serdoc.Text = string.Empty;
numdoc.Text = string.Empty;
statusDoc = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
statusDoc = false;
}
}
private void data_cbo_tipodoc()
{
if (cbo_moduloides.SelectedValue.ToString().Length == 4)
{
if (cbo_moduloides.SelectedValue.ToString() != "0200" && cbo_moduloides.SelectedValue.ToString() != "0000")
{
var BL = new modulo_local_tipodocBL();
var BE = new tb_modulo_local_tipodoc();
BE.dominioid = "60";
BE.moduloid = cbo_moduloides.SelectedValue.ToString();
BE.local = localdes.SelectedValue.ToString();
BE.visiblealmac = true;
BE.status = string.Empty;
tipodoc.DataSource = BL.GetAll_mov(EmpresaID, BE).Tables[0];
tipodoc.ValueMember = "tipodoc";
tipodoc.DisplayMember = "tipodocname";
}
}
}
