public bool Delete(string empresaid, tb_co_tabla10_comprobantes BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla10Comprobantes_DELETE", cnx))
{
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 2).Value = BE.codigoid;
}
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_co_tabla10_comprobantes BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla10Comprobantes_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 2).Value = BE.codigoid;
cmd.Parameters.Add("@descripcion", SqlDbType.VarChar, 100).Value = BE.descripcion;
cmd.Parameters.Add("@sigla", SqlDbType.Char, 3).Value = BE.sigla;
cmd.Parameters.Add("@docref", SqlDbType.Bit).Value = BE.docref;
}
cnx.Open();
try
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
Sql_Error = ex.Message;
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll(string empresaid, tb_co_tabla10_comprobantes BE)
{
//return tablaDA.GetAll(empresaid, BE);
DataSet xreturn = null;
xreturn = tablaDA.GetAll(empresaid, BE);
Sql_Error = tablaDA.Sql_Error;
return xreturn;
}
private void validaTipoDocumento()
{
sw_novaluechange = true;
Int16 lc_cont = default(Int16);
bool zhallado = false;
string VMNROITEM = gridgastos.Rows[gridgastos.CurrentRow.Index].Cells["asientoitems"].Value.ToString();
string xcodartic = "..";
//me.gas
if ((!object.ReferenceEquals(gridgastos.Rows[gridgastos.CurrentRow.Index].Cells["gasto_tipdoc"].Value, DBNull.Value)))
{
xcodartic = gridgastos.Rows[gridgastos.CurrentRow.Index].Cells["gasto_tipdoc"].Value.ToString();
}
if (xcodartic.Trim().Length == 0)
{
TabCac3p00GastosAdic.Rows[gridgastos.CurrentRow.Index]["gasto_tipdoc"] = "";
zhallado = true;
}
else
{
xcodartic = VariablesPublicas.PADL(xcodartic, 2, "0");
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
BE.codigoid = xcodartic;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
//tmptabla = ocapa.cag3i00_consulta(GlobalVars.GetInstance.Company, xcodartic, "", 1, GlobalVars.GetInstance.TipoDocumentoContableTodos, "", "", "");
for (lc_cont = 0; lc_cont <= TabCac3p00GastosAdic.Rows.Count - 1; lc_cont++)
{
if (TabCac3p00GastosAdic.Rows[lc_cont]["asientoitems"].ToString() == VMNROITEM)
{
if (tmptabla.Rows.Count > 0)
{
TabCac3p00GastosAdic.Rows[lc_cont]["tipdoc"] = tmptabla.Rows[0]["codigoid"];
zhallado = true;
break;
}
break;
}
}
}
if (!zhallado & xcodartic.Length > 0)
{
gridgastos.Rows[gridgastos.CurrentRow.Index].Cells["gasto_tipdoc"].Value = j_TipDocGasAdic;
}
gridgastos.Refresh();
sw_novaluechange = false;
}
//GRID GASTOS ADICIONALES
private void gridgastos_SelectionChanged(object sender, EventArgs e)
{
string prvcod = "";
txtdescripcampo.Text = "";
if ((gridgastos.CurrentCell != null))
{
if (gridgastos.Columns[gridgastos.CurrentCell.ColumnIndex].Name.ToUpper() == "gasto_cuentaid".ToUpper())
{
txtdescripcampo.Text = gridgastos.Rows[gridgastos.CurrentCell.RowIndex].Cells["gasto_cuentaname"].Value.ToString();
}
if (gridgastos.Columns[gridgastos.CurrentCell.ColumnIndex].Name.ToUpper() == "gasto_moneda".ToUpper())
{
txtdescripcampo.Text = "[1] SOLES [2] DOLARES";
}
if (gridgastos.Columns[gridgastos.CurrentCell.ColumnIndex].Name.ToUpper() == "gasto_tipdoc".ToUpper())
{
if ((!object.ReferenceEquals(gridgastos.Rows[gridgastos.CurrentCell.RowIndex].Cells["gasto_tipdoc"].Value, DBNull.Value)))
{
prvcod = gridgastos.Rows[gridgastos.CurrentCell.RowIndex].Cells["gasto_tipdoc"].Value.ToString();
}
if (prvcod.Trim().Length == 0)
{
prvcod = "...";
}
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
BE.codigoid = prvcod;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
//tmptabla = ocapa.cag3i00_consulta(GlobalVars.GetInstance.Company, prvcod, "", 1, GlobalVars.GetInstance.TipDocusTodos, "", "", "");
//if (ocapa.sql_error.Length == 0)
//{
if (tmptabla.Rows.Count > 0)
{
txtdescripcampo.Text = tmptabla.Rows[0]["descripcion"].ToString();
}
//}
}
//Centro de Costo
if (gridgastos.Columns[gridgastos.CurrentCell.ColumnIndex].Name.ToUpper() == "gasto_cencosid".ToUpper())
{
if ((!object.ReferenceEquals(gridgastos.Rows[gridgastos.CurrentCell.RowIndex].Cells["gasto_cencosid"].Value, DBNull.Value)))
{
prvcod = gridgastos.Rows[gridgastos.CurrentCell.RowIndex].Cells["gasto_cencosid"].Value.ToString();
}
if (prvcod.Trim().Length == 0)
{
prvcod = "...";
}
centrocostoBL BL = new centrocostoBL();
tb_centrocosto BE = new tb_centrocosto();
BE.cencosid = prvcod;
//BE.cencosdivi = xclasecuenta;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
//tmptabla = ocapa.pag0101_consulta(GlobalVars.GetInstance.Company, prvcod, "", 2, 1, "", "", "", "");
//if (ocapa.sql_error.Length == 0)
//{
if (tmptabla.Rows.Count > 0)
{
txtdescripcampo.Text = tmptabla.Rows[0]["cencosname"].ToString();
}
//}
}
}
u_RefrescaControles();
}
public bool Update(string empresaid, tb_co_tabla10_comprobantes BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla10Comprobantes_UPDATE", cnx))
{
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 2).Value = BE.codigoid;
cmd.Parameters.Add("@descripcion", SqlDbType.VarChar, 100).Value = BE.descripcion;
cmd.Parameters.Add("@sigla", SqlDbType.Char, 3).Value = BE.sigla;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
cmd.Parameters.Add("@docref", SqlDbType.Bit).Value = BE.docref;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void validaTipoDocumento()
{
sw_novaluechange = true;
string vmxtipdoc = "";
if (!(GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["tipguia"].Value == DBNull.Value))
{
vmxtipdoc = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["tipguia"].Value.ToString();
}
if ((vmxtipdoc.Trim().Length == 0))
{
return;
}
if ((VariablesPublicas.StringtoDecimal(vmxtipdoc) > 0))
{
vmxtipdoc = VariablesPublicas.PADL(vmxtipdoc, 2, "0");
}
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
BE.codigoid = vmxtipdoc;
DataTable tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if ((tmptabla.Rows.Count > 0))
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["tipguia"].Value = tmptabla.Rows[0]["codigoid"].ToString();
txtDescripcampo.Text = tmptabla.Rows[0]["descripcion"].ToString();
}
else
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["tipguia"].Value = j_ctipdoc_3a;
}
sw_novaluechange = false;
}
private BindingSource NewMethodDoc()
{
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
DataTable table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
DataRowCollection rows = table.Rows;
object[] cell;
Dictionary<string, string> dic = new Dictionary<string, string>();
BindingSource 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;
}
void Docref()
{
if (u_n_opsel > 0)
{
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
try
{
string xTipodoc = "";
if (Equivalencias.Left(cboTipdoc.Text, 2) == "07" | Equivalencias.Left(cboTipdoc.Text, 2) == "08" |
Equivalencias.Left(cboTipdoc.Text, 2) == "87" | Equivalencias.Left(cboTipdoc.Text, 2) == "88")
{
xTipodoc = cboTipdoc.SelectedValue.ToString();
}
BE.codigoid = xTipodoc;
DataTable table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (Convert.ToBoolean(table.Rows[0]["docref"].ToString()) == true)
{
gpoReferencia.Enabled = (u_n_opsel) > 0;
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
gpoReferencia.Enabled = false;
}
if (u_n_opsel > 0)
{
if (Equivalencias.Left(cboTipdoc.Text, 2) == "03" | Equivalencias.Left(cboTipdoc.Text, 2) == "12") // |
//Equivalencias.Left(cboTipdoc.Text, 2) == "87" | Equivalencias.Left(cboTipdoc.Text, 2) == "88")
{
txtNumFin.Enabled = true;
}
}
}
//Para activar Doc.Referencia
private void cboTipdoc_SelectedValueChanged(object sender, EventArgs e)
{
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
if (u_n_opsel > 0)
{
try
{
BE.codigoid = cboTipdoc.Text.Substring(0, 2);
DataTable table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
// gpoReferencia.Enabled = Convert.ToBoolean(table.Rows[0]["docref"].ToString())
if (Convert.ToBoolean(table.Rows[0]["docref"].ToString()) == true)
{
gpoReferencia.Enabled = true;
cboTipdocref.SelectedIndex = 1;
cboTipdocref.Focus();
}
else
{
gpoReferencia.Enabled = false;
cboTipdocref.SelectedIndex = -1;
txtSerieref.Clear();
txtNumeroref.Clear();
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void validaTipoDocumento()
{
txtTipdoc.Text = VariablesPublicas.PADL(txtTipdoc.Text.Trim(), 2, "0");
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
BE.codigoid = (txtTipdoc.Text.Trim().Length == 0 ? ".." : txtTipdoc.Text.Trim());
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (BL.Sql_Error.Length == 0)
{
if (tmptabla.Rows.Count > 0)
{
txtTipdoc.Text = tmptabla.Rows[0]["codigoid"].ToString();
txtdtipdoc.Text = tmptabla.Rows[0]["descripcion"].ToString();
}
else
{
txtTipdoc.Text = j_String;
}
}
}
private void Frm_AyudaParteingresoalmacen_Activated(object sender, EventArgs e)
{
if (sw_load)
{
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
BE.codigoid = "09";
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (BL.Sql_Error.Length == 0)
{
if (tmptabla.Rows.Count > 0)
{
txtTipdoc.Text = tmptabla.Rows[0]["codigoid"].ToString();
txtdtipdoc.Text = tmptabla.Rows[0]["descripcion"].ToString();
}
}
LlenarGridMovimientoAlmacen();
sw_load = false;
GridMovimientoAlmacen.Focus();
if (GridMovimientoAlmacen.RowCount > 0)
{
GridMovimientoAlmacen.BeginEdit(true);
}
}
}
private void POnerDatos()
{
SortOrder sorted = default(SortOrder);
string xnomcolumna = "";
if (!(dgAyuda.SortedColumn == null))
{
xnomcolumna = dgAyuda.Columns[dgAyuda.SortedColumn.Index].Name;
sorted = dgAyuda.SortOrder;
}
tb_co_tabla10_comprobantesBL BL = new tb_co_tabla10_comprobantesBL();
tb_co_tabla10_comprobantes BE = new tb_co_tabla10_comprobantes();
switch (cboCriterioBusqueda.SelectedItem.ToString())
{
case "Código":
BE.codigoid = txtBuscar.Text.Trim().ToUpper();
break;
case "Descripción":
BE.descripcion = txtBuscar.Text.Trim().ToUpper();
break;
default:
BE.codigoid = txtBuscar.Text.Trim().ToUpper();
break;
}
PCGCURSOR = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
dgAyuda.AutoGenerateColumns = false;
dgAyuda.DataSource = PCGCURSOR;
if ((xnomcolumna.Trim().Length > 0))
{
if ((sorted == SortOrder.Ascending))
{
dgAyuda.Sort(dgAyuda.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending);
}
else
{
dgAyuda.Sort(dgAyuda.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending);
}
}
else
{
dgAyuda.Sort(dgAyuda.Columns["codigoid"], System.ComponentModel.ListSortDirection.Ascending);
}
}
public bool Update(string empresaid, tb_co_tabla10_comprobantes BE)
{
return tablaDA.Update(empresaid, BE);
}
public bool Insert(string empresaid, tb_co_tabla10_comprobantes BE)
{
return tablaDA.Insert(empresaid, BE);
}