public DataSet GetAll(string empresaid, tb_co_rubroventas BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoRubroventas_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid;
cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 100).Value = BE.rubroname;
cmd.Parameters.Add("@cuentaid", SqlDbType.Char, 10).Value = BE.cuentaid;
cmd.Parameters.Add("@cuentaname", SqlDbType.VarChar, 100).Value = BE.cuentaname;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
}
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_co_rubroventas BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoRubroventas_DELETE", cnx))
{
{
cmd.CommandTimeout = 0;
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)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_IR(string empresaid, tb_co_rubroventas BE)
{
//return tablaDA.GetAll_IR(empresaid, BE);
DataSet xreturn = null;
xreturn = tablaDA.GetAll_IR(empresaid, BE);
Sql_Error = tablaDA.Sql_Error;
return xreturn;
}
public void ValidarubroVenta()
{
string xcodigo = "";
sw_novaluechange = true;
if (object.ReferenceEquals(GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value, DBNull.Value))
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value = "";
}
xcodigo = Equivalencias.Mid(GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value.ToString(), 1, 4);
if (xcodigo.Trim().Length > 0)
{
xcodigo = VariablesPublicas.PADL(xcodigo.Trim(), 4, "0");
try
{
tb_co_rubroventasBL BL = new tb_co_rubroventasBL();
tb_co_rubroventas BE = new tb_co_rubroventas();
BE.rubroid = xcodigo;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (tmptabla.Rows.Count > 0)
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value = tmptabla.Rows[0]["rubroid"];
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["drubro"].Value = tmptabla.Rows[0]["rubroname"];
txtDescripcampo.Text = tmptabla.Rows[0]["cuentaid"].ToString().Trim() + " - " + tmptabla.Rows[0]["cuentaname"].ToString().Trim();
}
else
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value = j_RUBRO;
}
}
else
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value = j_RUBRO;
}
sw_novaluechange = false;
}
private bool Validacion()
{
object xobjeto = null;
int lc_cont = 0;
string xmsgstring = "";
DataTable tmptabla = new DataTable();
dynamic xfill = "...";
if (txtNumero.Text.Trim().Length == 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese Número de Comprobante...?";
xobjeto = txtNumero;
}
//if (txtNumFin.Text.Trim().Length == 0)
//{
// xmsgstring = xmsgstring + "\r\n" + "Ingrese Número de Comprobante Final...?";
// xobjeto = txtNumFin;
//}
if (txtRuc.Text.Trim().Length == 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese Cliente...?";
xobjeto = txtRuc;
}
else
{
try
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtRuc.Text;
if ((BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]).Rows.Count == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Cliente no existe...?"));
xobjeto = txtRuc;
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (txtTipoventa.Text.Trim().Length == 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese Tipo Venta...?";
xobjeto = txtTipoventa;
}
else
{
}
Decimal vmntipocambio = VariablesPublicas.StringtoDecimal(txtTipocambio.Text);
if (vmntipocambio == 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese Tipo de Cambio...?";
xobjeto = fRegistro;
}
if (validaduplicidad())
{
xmsgstring = xmsgstring + xfill;
}
if ((txtGlosa.Text.Trim()).Trim().Length == 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese glosa...?";
xobjeto = txtGlosa;
}
string xcodtmp = "";
string xcodtmpr = "";
double canttmp = 0;
DataTable otabla = new DataTable();
if (DetFacturacion.Rows.Count == 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese detalles al movimiento...?";
xobjeto = GridExaminar;
}
if (xmsgstring.Trim().Length == 0)
{
for (lc_cont = 0; lc_cont <= DetFacturacion.Rows.Count - 1; lc_cont++)
{
// Validando Rubro
xcodtmp = "";
if (!object.ReferenceEquals(DetFacturacion.Rows[lc_cont]["rubroid"], DBNull.Value))
{
xcodtmpr = DetFacturacion.Rows[lc_cont]["rubroid"].ToString();
}
if (xcodtmpr.Trim().Length == 0)
{
xcodtmpr = "...";
}
if (xcodtmpr.Trim().Length > 0)
{
try
{
tb_co_rubroventasBL BL = new tb_co_rubroventasBL();
tb_co_rubroventas BE = new tb_co_rubroventas();
BE.rubroid = xcodtmpr;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Rubro de Ventas no Existe...?"));
xobjeto = GridExaminar;
}
if (tmptabla.Rows.Count > 0)
{
if (tmptabla.Rows[0]["cuentaid"].ToString().Trim().Length != 7)
{
xmsgstring = (xmsgstring + ("\r\n" + "Rubro no Asociado a una Cuenta Contable Válida...?"));
xobjeto = GridExaminar;
}
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Validando Item
if (!object.ReferenceEquals(DetFacturacion.Rows[lc_cont]["productid"], DBNull.Value))
{
xcodtmp = DetFacturacion.Rows[lc_cont]["productid"].ToString();
}
else
{
xcodtmp = "";
}
if (xcodtmp.Trim().Length > 0)
{
try
{
tb_pt_productoBL BL = new tb_pt_productoBL();
tb_pt_producto BE = new tb_pt_producto();
BE.productid = xcodtmp;
otabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (otabla.Rows.Count == 0)
{
xmsgstring = "Código de Artículo no existe...?";
xobjeto = GridExaminar;
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Validando Precios
if (!object.ReferenceEquals(DetFacturacion.Rows[lc_cont]["precunit"], DBNull.Value))
{
canttmp = Convert.ToDouble(DetFacturacion.Rows[lc_cont]["precunit"]);
}
else
{
canttmp = 0;
}
if (canttmp <= 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese precio...?";
xobjeto = GridExaminar;
}
if (!object.ReferenceEquals(DetFacturacion.Rows[lc_cont]["cantidad"], DBNull.Value))
{
canttmp = Convert.ToDouble(DetFacturacion.Rows[lc_cont]["cantidad"]);
}
else
{
canttmp = 0;
}
if (canttmp <= 0)
{
xmsgstring = xmsgstring + "\r\n" + "Ingrese Cantidades...?";
xobjeto = GridExaminar;
}
// Validando Centro de Costo
DataTable tmptablarelacionccosto = new DataTable();
string vmccosto;
vmccosto = "...";
if (!(DetFacturacion.Rows[lc_cont]["cencosid"] == DBNull.Value))
{
if (DetFacturacion.Rows[lc_cont]["cencosid"].ToString().Trim().Length > 0)
{
vmccosto = DetFacturacion.Rows[lc_cont]["cencosid"].ToString();
}
}
try
{
centrocostoBL BL = new centrocostoBL();
tb_centrocosto BE = new tb_centrocosto();
if (xcodtmpr != "...")
{
BE.cencosdivi = Equivalencias.Mid(tmptabla.Rows[0]["cuentaid"].ToString(), 1, 1);
tmptablarelacionccosto = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
if (tmptablarelacionccosto.Rows.Count > 0)
{
int qqqcont;
bool zhalladoccosto = false;
for (qqqcont = 0; (qqqcont <= (tmptablarelacionccosto.Rows.Count - 1)); qqqcont++)
{
if (tmptablarelacionccosto.Rows[qqqcont]["cencosid"].ToString() == vmccosto)
{
zhalladoccosto = true;
break;
}
}
if (!zhalladoccosto)
{
xmsgstring = (xmsgstring + ("\r\n" + "Centro de Costo no asociado al Rubro...?"));
}
else
{
for (qqqcont = 0; (qqqcont <= (GridExaminar.Rows.Count - 1)); qqqcont++)
{
if (GridExaminar.Rows[qqqcont].Cells["asientoitems"].Value == DetFacturacion.Rows[lc_cont]["asientoitems"])
{
if (GridExaminar.CurrentCell == null)
{
GridExaminar.CurrentCell = GridExaminar.Rows[qqqcont].Cells["rubroid"];
}
GridExaminar.CurrentCell.ReadOnly = true;
GridExaminar.CurrentCell = GridExaminar.Rows[qqqcont].Cells["cencosid"];
GridExaminar.BeginEdit(true);
GridExaminar.CurrentCell.ReadOnly = false;
break;
}
}
}
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if ((xmsgstring.Trim().Length > 0))
{
break;
}
}
}
if (xmsgstring.Trim().Length == 0)
{
if (u_n_opsel == 1 | (W_KEY0001 != txtRuc.Text + cboTipdoc.SelectedValue + txtSerie.Text + txtNumero.Text))
{
tmptabla = null;
try
{
tb_co_VentascabBL BL = new tb_co_VentascabBL();
tb_co_Ventascab BE = new tb_co_Ventascab();
BE.nmruc = txtRuc.Text;
BE.tipdoc = cboTipdoc.SelectedValue.ToString();
BE.serdoc = txtSerie.Text;
BE.numdoc = txtNumero.Text;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (!(tmptabla == null))
{
if (tmptabla.Rows.Count > 0)
{
xmsgstring = ("Documento Ya registrado en Periodo : " + tmptabla.Rows[0]["perianio"] + " Registro Nº " +
tmptabla.Rows[0]["diarioid"] + "/" +
tmptabla.Rows[0]["perimes"] + "-" + tmptabla.Rows[0]["asiento"]);
xobjeto = txtNumero;
}
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
if (xobjeto != null)
{
try
{
xobjeto = Focus();
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (xmsgstring.Trim().Length > 0 & xmsgstring.Trim() != xfill)
{
DevExpress.XtraEditors.XtraMessageBox.Show(xmsgstring, "Validación de Datos", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (xmsgstring.Trim().Length == 0)
{
if (!PuedeEditarEliminar("Grabar Nuevo Registro", VariablesPublicas.PADL(fRegistro.Value.Month.ToString(), 2, "0")))
{
xmsgstring = "...";
}
}
if (xmsgstring.Trim().Length == 0)
{
return VariablesPublicas.U_ValidaFechaRegistroProvision(VariablesPublicas.perianio, txtMes.Text, fRegistro.Value);
}
else
{
return xmsgstring.Trim().Length == 0;
}
}
private void validaCentroCosto()
{
DataTable tmpccosto = new DataTable();
sw_novaluechange = true;
Int16 lc_cont;
bool zhallado = false;
string VMNROITEM = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["asientoitems"].Value.ToString();
string xcodartic = "..";
string xcodrubro = "....";
if (!(GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value == DBNull.Value))
{
xcodrubro = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value.ToString();
tb_co_rubroventasBL BL = new tb_co_rubroventasBL();
tb_co_rubroventas BE = new tb_co_rubroventas();
BE.rubroid = xcodrubro;
tmpccosto = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
string xcodcuenta = "..";
xcodcuenta = "";
if (tmpccosto.Rows.Count > 0)
{
xcodcuenta = Equivalencias.Mid(tmpccosto.Rows[0]["cuentaid"].ToString(), 1, 2);
}
if (!(GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["cencosid"].Value == DBNull.Value))
{
xcodartic = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["cencosid"].Value.ToString();
}
if (xcodartic.Trim().Length == 0)
{
// DetFacturacion.Rows[lc_cont]["cencosid"] = "";
// DetFacturacion.Rows[lc_cont]["dccosto"] = "";
zhallado = true;
}
else
{
centrocostoBL BL = new centrocostoBL();
tb_centrocosto BE = new tb_centrocosto();
BE.cencosid = xcodartic;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
for (lc_cont = 0; lc_cont < DetFacturacion.Rows.Count; lc_cont++)
{
if (DetFacturacion.Rows[lc_cont]["asientoitems"].ToString() == VMNROITEM)
{
if (tmptabla.Rows.Count > 0)
{
DetFacturacion.Rows[lc_cont]["cencosid"] = tmptabla.Rows[0]["cencosid"];
// DetFacturacion.Rows[lc_cont]["dccosto"] = Equivalencias.Mid(tmptabla.Rows[0]["descrip_a"], 1, DetFacturacion.Columns["dccosto"].MaxLength);
txtDescripcampo.Text = tmptabla.Rows[0]["cencosname"].ToString();
zhallado = true;
break;
}
}
}
}
if (!zhallado)
{
GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["cencosid"].Value = j_Ccosto;
}
GridExaminar.Refresh();
sw_novaluechange = false;
}
private void AyudaCentroCosto()
{
string xcodrubro = "";
string xcodcuenta = "";
if (GridExaminar.CurrentRow != null)
{
if (!(GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value == DBNull.Value))
{
xcodrubro = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["rubroid"].Value.ToString();
tb_co_rubroventasBL BL = new tb_co_rubroventasBL();
tb_co_rubroventas BE = new tb_co_rubroventas();
BE.rubroid = xcodrubro;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count > 0)
{
xcodcuenta = Equivalencias.Mid(tmptabla.Rows[0]["cuentaid"].ToString(), 1, 2);
}
else
{
xcodcuenta = "...";
}
}
}
Ayudas.Frm_AyudaCentrocosto frmayuda = new Ayudas.Frm_AyudaCentrocosto();
frmayuda.Owner = this;
frmayuda.Owner = this;
frmayuda._ClaseCuenta = xcodcuenta;
frmayuda.PasaCentroCosto = RecibeCcosto;
frmayuda.ShowDialog();
}
private void POnerDatos()
{
var xCuenta = string.Empty;
if (txtCuenta.Enabled)
{
xCuenta = txtCuenta.Text;
}
var xRubro = string.Empty;
if (txtRubro.Enabled)
{
xRubro = txtRubro.Text;
}
var xDescripcion = string.Empty;
if (txtDescripcion.Enabled)
{
xDescripcion = txtDescripcion.Text;
}
try
{
var BL = new tb_co_rubroventasBL();
var BE = new tb_co_rubroventas();
BE.rubroid = xRubro;
BE.rubroname = xDescripcion;
BE.cuentaid = xCuenta;
PCGCURSOR = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if ((PCGCURSOR.Rows.Count > 0))
{
GridExaminar.AutoGenerateColumns = false;
GridExaminar.DataSource = PCGCURSOR;
CargaDatos();
Ponedatos();
}
else
{
sw_load = false;
}
}
public bool Update(string empresaid, tb_co_rubroventas BE)
{
return tablaDA.Update(empresaid, BE);
}
public bool Insert(string empresaid, tb_co_rubroventas BE)
{
return tablaDA.Insert(empresaid, BE);
}
public DataSet GetAll(string empresaid, tb_co_rubroventas BE)
{
return tablaDA.GetAll(empresaid, BE);
}
public DataSet GetAll_IR(string empresaid, tb_co_rubroventas BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoRubroventas_SEARCH_IR", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid;
}
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 Insert(string empresaid, tb_co_rubroventas BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoRubroventas_INSERT", cnx))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rubroid", SqlDbType.Char, 4).Value = BE.rubroid;
cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 100).Value = BE.rubroname;
cmd.Parameters.Add("@cuentaid", SqlDbType.Char, 10).Value = BE.cuentaid;
cmd.Parameters.Add("@cuentaname", SqlDbType.VarChar, 100).Value = BE.cuentaname;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private String UbicarRubroId(string cuentaid)
{
tb_co_rubroventasBL BL = new tb_co_rubroventasBL();
tb_co_rubroventas BE = new tb_co_rubroventas();
DataTable table = new DataTable();
BE.cuentaid = cuentaid;
try
{
table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return table.Rows[0]["rubroid"].ToString();
}