public void ValidaDetalle()
{
if (txtRuc.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtRuc.Text;
DataTable tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count == 0)
{
txtRuc.Text = j_String;
}
else
{
//txtRuc.Text = tmptabla.Rows[0]["nmruc"].ToString();
txtCtactename.Text = tmptabla.Rows[0]["ctactename"].ToString();
U_CargaDatos();
}
}
else
{
txtRuc.Text = j_String;
}
}
private void ValidaInsert_Update()
{
var BL = new clienteBL();
var BE = new tb_cliente();
var dt = new DataTable();
BE.ctacte = Equivalencias.Right(txtcodigo.Text.Trim(),4);
dt = BL.GetAll_CODdbf(VariablesPublicas.EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
var n = Convert.ToInt32(dt.Rows[0]["cant"].ToString());
if (n > 0)
{
Update_DBF();
}
else
{
Insert_DBF();
}
}
}
private void ValidaCliente()
{
if (nmruc.Text.Trim().Length > 0 || ctacte.Text.Trim().Length > 0)
{
var BL = new clienteBL();
var BE = new tb_cliente();
var dt = new DataTable();
BE.ctacte = ctacte.Text.Trim().PadLeft(7, '0');
if (nmruc.Text.Trim().Length > 0)
{
BE.nmruc = nmruc.Text.Trim();
}
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
nmruc.Text = dt.Rows[0]["nmruc"].ToString().Trim();
ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
direc.Text = dt.Rows[0]["direc"].ToString().Trim();
}
else
{
ctacte.Text = string.Empty;
nmruc.Text = string.Empty;
ctactename.Text = string.Empty;
direc.Text = string.Empty;
direcnume = string.Empty;
direcname.Text = string.Empty;
direcdeta.Text = string.Empty;
nmruc.Focus();
}
}
}
private void ValidaCliente()
{
if (dominioid.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
DataTable dt = new DataTable();
String cta = ctacte.Text.Trim().PadLeft(7, '0');
BE.ctacte = cta.ToString();
ctacte.Text = cta.ToString();
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
xNmruc = dt.Rows[0]["nmruc"].ToString().Trim();
xLocalDirec = dt.Rows[0]["localdirec"].ToString().Trim();
ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
direcnume.Text = dt.Rows[0]["direcnume"].ToString().Trim();
}
else
{
ctacte.Text = "";
xNmruc = "";
xLocalDirec = "";
ctactename.Text = "";
direcnume.Text = "";
}
}
else
{
ctacte.Text = "";
xNmruc = "";
xLocalDirec = "";
ctactename.Text = "";
direcnume.Text = "";
}
}
private void ValidamosProcedencia()
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
DataTable dt = new DataTable();
BE.ctacte = _ctacte.ToString();
BE.filtro = "2";
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
if (modulo.ToString() != "0500") // Diferente Porque No Diferenciamos su Proveedor
{
String set_ctacte = dt.Rows[0]["ctacte"].ToString().Trim();
String set_ctactename = dt.Rows[0]["ctactename"].ToString().Trim();
String set_paisname = dt.Rows[0]["paisname"].ToString().Trim();
String set_paisid = dt.Rows[0]["paisid"].ToString().Trim();
if (set_paisid == "9589") // Codigo de Peru
{
this.procedenciaid.SelectedIndex = 0;
txt_paisname.Text = set_paisname.ToString();
}
else
{
this.procedenciaid.SelectedIndex = 1;
txt_paisname.Text = set_paisname.ToString();
}
}
else
{
this.procedenciaid.SelectedIndex = 0;
txt_paisname.Text = "PERÚ";
}
}
else
{
}
}
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;
}
}
public void ValidaDetalle()
{
if (txtdetalle.Text.Trim().Length > 0)
{
var BL = new clienteBL();
var BE = new tb_cliente();
BE.nmruc = txtdetalle.Text.Trim();
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (BL.Sql_Error.Length == 0)
{
if (tmptabla.Rows.Count > 0)
{
txtdcuentamayor.Text = tmptabla.Rows[0]["ctactename"].ToString();
U_CargaDatos();
}
}
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
switch (filtro)
{
case "PS":
tb_cxc_vendorBL PSBL = new tb_cxc_vendorBL();
tb_cxc_vendor PSBE = new tb_cxc_vendor();
DataTable PSDT = new DataTable();
PSBE.ddnni = GridView1.SelectedRow.Cells[2].Text;
PSDT = PSBL.GetAll(Session["ssEmpresaID"].ToString(), PSBE).Tables[0];
txt_vendorid.Text = PSDT.Rows[0]["vendorid"].ToString();
txt_vendorname.Text = PSDT.Rows[0]["vendorname"].ToString();
break;
case "PR":
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
DataTable dt = new DataTable();
BE.ctacte = GridView1.SelectedRow.Cells[1].Text;
dt = BL.GetAll(Session["ssEmpresaID"].ToString(), BE).Tables[0];
txt_ctacte.Text = dt.Rows[0]["ctacte"].ToString();
txt_ctactename.Text = dt.Rows[0]["ctactename"].ToString();
txt_ruc.Text = dt.Rows[0]["nmruc"].ToString();
direc_entrega.Text = dt.Rows[0]["direc"].ToString();
break;
case "PA":
txt_articidold.Text = GridView1.SelectedRow.Cells[1].Text;
MetodoCargarLineal();
break;
}
UpdatePanel2.Update();
ModalPopupExtender2.Hide();
}
catch (Exception ex)
{
ClientMessage(ex.Message);
}
}
private void ObtenemosCab()
{
if (tipguia.Text.Trim().Length > 0)
{
var BL = new tb_ad_movimientosBL();
var BE = new tb_ad_movimientos();
var dt = new DataTable();
BE.moduloid = modulo;
BE.local = local;
BE.tipodoc = tipguia.Text.ToString();
BE.serdoc = serguia.Text.Trim();
BE.numdoc = numguia.Text;
dt = BL.GetOne(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
dt.Rows[0]["numdoc"].ToString().Trim();
fechguia.Value = Convert.ToDateTime(dt.Rows[0]["fechdoc"]);
ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
nmruc.Text = dt.Rows[0]["nmruc"].ToString().Trim();
ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
var BL2 = new clienteBL();
var BE2 = new tb_cliente();
var dt2 = new DataTable();
BE2.ctacte = ctacte.Text;
dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0];
direc.Text = dt2.Rows[0]["direc"].ToString().Trim();
moneda.SelectedValue = dt.Rows[0]["moneda"].ToString().Trim();
}
}
}
private void CargaDatos()
{
var lc_cont = 0;
var nposcolumnasortear = string.Empty;
var PrvSotOrder = default(SortOrder);
var zordenado = false;
var xcodcliente = string.Empty;
var xBuscar = string.Empty;
if (GridExaminar.CurrentRow != null)
{
xcodcliente = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["ctacte"].Value.ToString();
}
if ( GridExaminar.SortedColumn != null )
{
nposcolumnasortear = GridExaminar.Columns[GridExaminar.SortedColumn.Index].Name;
PrvSotOrder = GridExaminar.SortOrder;
zordenado = true;
}
if (txtCadenaBuscar.Text.Trim().Length > 0)
{
xBuscar = txtCadenaBuscar.Text.Trim().ToUpper();
}
else
{
xBuscar = string.Empty;
}
try
{
var BL = new clienteBL();
var BE = new tb_cliente();
switch (cboCriterioBusqueda.SelectedItem.ToString())
{
case "Razón Social":
BE.ctactename = xBuscar;
break;
case "Ruc":
BE.nmruc = xBuscar;
break;
case "Código":
BE.ctacte = xBuscar;
break;
default:
BE.ctactename = xBuscar;
break;
}
tablaclientes = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
GridExaminar.AutoGenerateColumns = false;
GridExaminar.DataSource = tablaclientes;
VariablesPublicas.PintaEncabezados(GridExaminar);
if (zordenado)
{
if ( PrvSotOrder == SortOrder.Ascending )
{
GridExaminar.Sort(GridExaminar.Columns[nposcolumnasortear], System.ComponentModel.ListSortDirection.Ascending);
}
else
{
GridExaminar.Sort(GridExaminar.Columns[nposcolumnasortear], System.ComponentModel.ListSortDirection.Descending);
}
}
else
{
GridExaminar.Sort(GridExaminar.Columns["ctacte"], System.ComponentModel.ListSortDirection.Ascending);
}
if ( GridExaminar.CurrentRow == null )
{
if ( GridExaminar.RowCount > 0 )
{
GridExaminar.CurrentCell = GridExaminar.Rows[0].Cells["ctacte"];
}
}
for (lc_cont = 0; lc_cont < GridExaminar.Rows.Count; lc_cont++)
{
if (GridExaminar.Rows[lc_cont].Cells["ctacte"].ToString() == xcodcliente)
{
GridExaminar.CurrentCell = GridExaminar.Rows[lc_cont].Cells["ctacte"];
break;
}
}
}
private void ValidaCliente()
{
if (ctacte.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
DataTable dt = new DataTable();
BE.ctacte = ctacte.Text.Trim().PadLeft(7, '0');
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
}
else
{
ctacte.Text = "";
ctactename.Text = "";
}
}
}
private void btnsave_Click(object sender, EventArgs e)
{
if (U_Validacion())
{
try
{
if (txtcanalvtaid.Text.Length == 0)
{
MessageBox.Show("Ingrese el Canal de Venta !!!");
return;
}
var BL = new clienteBL();
var BE = new tb_cliente();
BE.ctacte = txtcodigo.Text.Trim().ToUpper();
BE.ctactename = txtrazonsocial.Text.Trim().ToUpper();
BE.docuidentid = cboTipdoc.SelectedValue.ToString();
BE.nmruc = txtmnruc.Text.Trim().ToUpper();
if (rbnatural.Checked == true)
{
BE.tpperson = "01";
}
if (rbjuridica.Checked == true)
{
BE.tpperson = "02";
}
if (rbnodom.Checked == true)
{
BE.tpperson = "03";
}
BE.agerent = chkretencion.Checked;
BE.appat = txtapepat.Text.Trim().ToUpper();
BE.apmat = txtapemat.Text.Trim().ToUpper();
BE.nombr = txtnombres.Text.Trim().ToUpper();
BE.direc = txtdireccion.Text.Trim().ToUpper();
BE.paisid = txtpaisid.Text.Trim().ToUpper();
if (txtpaisid.Text.Trim() != "9589")
{
BE.ubige = "000000";
}
else
{
BE.ubige = cboDistr.SelectedValue.ToString();
}
BE.telef1 = txttelefono1.Text.Trim().ToUpper();
BE.email = txtemail.Text.Trim().ToUpper();
BE.urweb = txtweb.Text.Trim().ToUpper();
BE.telef2 = txttelefono2.Text.Trim().ToUpper();
BE.telef3 = txttelefono3.Text.Trim().ToUpper();
BE.contacto = txtContacto.Text.Trim().ToUpper();
BE.nctactedetraccion = txtctadetrac.Text.Trim().ToUpper();
BE.canalventaid = txtcanalvtaid.Text;
BE.replegaldni = txtreplegaldni.Text;
BE.replegalname = txtreplegalname.Text;
if (rbactivo.Checked == true)
{
BE.status = "0";
}
if (rbbaja.Checked == true)
{
BE.status = "1";
}
if (rbanulado.Checked == true)
{
BE.status = "9";
}
BE.usuar = VariablesPublicas.Usuar.Trim();
if (u_n_opsel == 1)
{
if (BL.Insert(VariablesPublicas.EmpresaID.ToString(), BE))
{
}
else
{
MessageBox.Show("Contacte con sistemas", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
ValidaInsert_Update();
}
else
{
if (BL.Update(VariablesPublicas.EmpresaID.ToString(), BE))
{
}
else
{
MessageBox.Show("Contacte con sistemas", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
ValidaInsert_Update();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#region Direcciones
//if (gridAnexos.RowCount > 0)
//{
// try
// {
// var BL = new cliente_direcBL();
// var BE = new tb_cliente_direc();
// var Detalle = new tb_cliente_direc.Item();
// var ListaItems = new List<tb_cliente_direc.Item>();
// BE.ctacte = txtcodigo.Text.Trim().ToUpper();
// var item = 0;
// foreach (DataRow fila in TablaAnexos.Rows)
// {
// Detalle = new tb_cliente_direc.Item();
// item++;
// Detalle.direcnume = fila["direcnume"].ToString();
// Detalle.direcname = fila["direcname"].ToString();
// Detalle.direcdeta = fila["direcdeta"].ToString();
// Detalle.telef = fila["telef"].ToString();
// Detalle.ubige = fila["ubige"].ToString();
// Detalle.usuar = VariablesPublicas.Usuar.ToString();
// Detalle.status = "0";
// ListaItems.Add(Detalle);
// }
// BE.ListaItems = ListaItems;
// if (BL.Insert_XML(VariablesPublicas.EmpresaID.ToString(), BE))
// {
// }
// else
// {
// MessageBox.Show("Contacte con sistemas", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// }
// InsertDirecc_DBF();
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
//}
#endregion
#region Cuentas Bancarias
if (gridBancos.RowCount > 0)
{
try
{
var BL = new cliente_bancoBL();
var BE = new tb_cliente_banco();
var Detalle = new tb_cliente_banco.Item();
var ListaItems = new List<tb_cliente_banco.Item>();
BE.ctacte = txtcodigo.Text.Trim().ToUpper();
var item = 0;
foreach (DataRow fila in TablaBancos.Rows)
{
Detalle = new tb_cliente_banco.Item();
item++;
Detalle.bancoid = fila["bancoid"].ToString();
Detalle.ctactemn = fila["ctactemn"].ToString();
Detalle.ctacteme = fila["ctacteme"].ToString();
Detalle.usuar = VariablesPublicas.Usuar.ToString();
ListaItems.Add(Detalle);
}
BE.ListaItems = ListaItems;
if (BL.Insert_XML(VariablesPublicas.EmpresaID.ToString(), BE))
{
MessageBox.Show("Se grabó con éxito", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Contacte con sistemas", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
#endregion
U_CancelarEdicion(0);
}
}
private void btndelete_Click(object sender, EventArgs e)
{
if (!(GridExaminar.CurrentRow == null))
{
if (MessageBox.Show("Desea eliminar datos de cliente ...?"
+ txtmnruc.Text.Trim() + "-" + txtnomdetalle.Text.Trim(), "Mensaje del Sistema", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
try
{
var BL = new clienteBL();
var BE = new tb_cliente();
BE.ctacte = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["ctacte"].Value.ToString();
if (BL.Delete(VariablesPublicas.EmpresaID.ToString(), BE))
{
GridExaminar.Rows.Remove(GridExaminar.CurrentRow);
GridExaminar.Refresh();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
U_RefrescaControles();
}
private void blanquear()
{
var BL = new clienteBL();
var BE = new tb_cliente();
try
{
txtcodigo.Text = BL.GetNextCod(VariablesPublicas.EmpresaID.ToString(), BE);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtmnruc.Text = string.Empty;
rbjuridica.Checked = true;
chkretencion.Checked = false;
txtrazonsocial.Text = string.Empty;
txtapepat.Text = string.Empty;
txtapemat.Text = string.Empty;
txtnombres.Text = string.Empty;
txtdireccion.Text = string.Empty;
txtContacto.Text = string.Empty;
txtemail.Text = string.Empty;
txtweb.Text = string.Empty;
txttelefono1.Text = string.Empty;
txttelefono2.Text = string.Empty;
txttelefono3.Text = string.Empty;
txtctadetrac.Text = string.Empty;
txtpaisid.Text = string.Empty;
txtpaisname.Text = string.Empty;
lblDireccion.Text = string.Empty;
rbactivo.Checked = false;
rbbaja.Checked = false;
rbanulado.Checked = false;
txtCondicion.Text = string.Empty;
txtcoddetalle.Text = string.Empty;
txtRucAnexo.Text = string.Empty;
txtnomdetalle.Text = string.Empty;
txtcanalvtaid.Text = string.Empty;
txtcanalvtaname.Text = string.Empty;
txtreplegaldni.Text = string.Empty;
txtreplegalname.Text = string.Empty;
if (TablaAnexos != null)
{
TablaAnexos.AcceptChanges();
if (TablaAnexos.Rows.Count > 0)
{
for (vmncont = 0; vmncont < TablaAnexos.Rows.Count; vmncont++)
{
TablaAnexos.Rows[vmncont].Delete();
}
TablaAnexos.AcceptChanges();
}
}
txtCodigob.Text = string.Empty;
txtRucb.Text = string.Empty;
txtCtactenameb.Text = string.Empty;
if (TablaBancos != null)
{
TablaBancos.AcceptChanges();
if (TablaBancos.Rows.Count > 0)
{
for (vmncont = 0; vmncont < TablaBancos.Rows.Count; vmncont++)
{
TablaBancos.Rows[vmncont].Delete();
}
TablaBancos.AcceptChanges();
}
}
}
private void ValidaProveedor()
{
if (txtRuc.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtRuc.Text;
DataTable tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count == 0)
{
xctacte = j_Ctacte;
txtRuc.Text = j_String;
}
else
{
xtipopersona = tmptabla.Rows[0]["tpperson"].ToString();
xtipodocidentidad = tmptabla.Rows[0]["docuidentid"].ToString();
xctacte = tmptabla.Rows[0]["ctacte"].ToString();
txtRuc.Text = tmptabla.Rows[0]["nmruc"].ToString();
txtCtactename.Text = tmptabla.Rows[0]["ctactename"].ToString().Trim();
//txtDireccion.Text = tmptabla.Rows[0]["direc"].ToString().Trim();
xdirec = tmptabla.Rows[0]["direc"].ToString().Trim();
xubige = tmptabla.Rows[0]["ubige"].ToString().Trim();
//cboDpto.SelectedValue = Equivalencias.Left(xubige, 2);
//LlenarProvi(cboProv, cboDistr, cboDpto.SelectedValue.ToString());
//LlenarDistr(cboDistr, cboProv.SelectedValue.ToString());
//cboProv.SelectedValue = Equivalencias.Left(xubige, 4);
//cboDistr.SelectedValue = xubige;
if (object.ReferenceEquals(tmptabla.Rows[0]["agerent"], DBNull.Value))
{
rbagenteretencionsi.Checked = false;
rbagenteretencionno.Checked = true;
}
else
{
rbagenteretencionsi.Checked = Convert.ToBoolean(tmptabla.Rows[0]["agerent"]) == true;
rbagenteretencionno.Checked = Convert.ToBoolean(tmptabla.Rows[0]["agerent"]) == false;
}
if (object.ReferenceEquals(tmptabla.Rows[0]["buencontr"], DBNull.Value))
{
rbbuencontribuyentesi.Checked = false;
rbbuencontribuyenteno.Checked = true;
}
else
{
rbbuencontribuyentesi.Checked = Convert.ToBoolean(tmptabla.Rows[0]["buencontr"]) == true;
rbbuencontribuyenteno.Checked = Convert.ToBoolean(tmptabla.Rows[0]["buencontr"]) == false;
}
if (object.ReferenceEquals(tmptabla.Rows[0]["buencontr"], DBNull.Value))
{
rbpercepcionsi.Checked = false;
rbpercepcionno.Checked = true;
}
else
{
rbpercepcionsi.Checked = Convert.ToBoolean(tmptabla.Rows[0]["agenperc"]) == true;
rbpercepcionno.Checked = Convert.ToBoolean(tmptabla.Rows[0]["agenperc"]) == false;
}
}
}
else
{
xctacte = j_Ctacte;
txtRuc.Text = j_String;
}
}
private void ValControls()
{
var BL = new clienteBL();
var BE = new tb_cliente();
var dt = new DataTable();
BE.defacliepub = true;
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (tipodoc.SelectedValue.ToString() == "FA" ||
tipodoc.SelectedValue.ToString() == "TK")
{
btnextraersunat.Image = global::BapFormulariosNet.Properties.Resources.go_sunat1;
lblruc.Text = "RUC:";
lbltitulo.Text = "FACTURA";
nmruc.MaxLength = 11;
lbltitulo.Location = new Point(422, 9);
tip_operacion = "01";
if (dt.Rows.Count > 0)
{
ctacte.Text = dt.Rows[0]["ctacte"].ToString();
ctactename.Text = dt.Rows[0]["ctactename"].ToString();
}
else
{
ctacte.Text = string.Empty;
ctactename.Text = string.Empty;
}
if (tipodoc.SelectedValue.ToString() == "TK")
{
lblruc.Text = "DNI/RUC:";
lbltitulo.Text = "TICKET";
lbltitulo.Location = new Point(422, 9);
}
}
else
{
if (tipodoc.SelectedValue.ToString() == "BV")
{
btnextraersunat.Image = global::BapFormulariosNet.Properties.Resources.go_reniec;
lblruc.Text = "DNI:";
lbltitulo.Text = "BOLETA";
nmruc.MaxLength = 8;
lbltitulo.Location = new Point(422, 9);
tip_operacion = "01";
if (dt.Rows.Count > 0)
{
ctacte.Text = dt.Rows[0]["ctacte"].ToString();
ctactename.Text = dt.Rows[0]["ctactename"].ToString();
}
else
{
ctacte.Text = string.Empty;
ctactename.Text = string.Empty;
}
}
else
{
if (tipodoc.SelectedValue.ToString() == "NC")
{
lblruc.Text = "DNI/RUC:";
lbltitulo.Text = "NOTA DE CREDITO";
lbltitulo.Location = new Point(350, 9);
tip_operacion = "05";
}
}
}
}
private void ValidaProveedorAval()
{
if (txtRucAval.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtRucAval.Text;
DataTable tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count == 0)
{
txtRucAval.Text = j_String;
}
else
{
xctacteaval = tmptabla.Rows[0]["ctacte"].ToString();
txtRucAval.Text = tmptabla.Rows[0]["nmruc"].ToString().Trim();
txtCtactenameAval.Text = tmptabla.Rows[0]["ctactename"].ToString().Trim();
txtDireccionAval.Text = tmptabla.Rows[0]["direc"].ToString().Trim();
txtTelefAval.Text = tmptabla.Rows[0]["telef1"].ToString().Trim();
}
}
else
{
txtRuc.Text = j_String;
}
}
private void Update()
{
var BL = new clienteBL();
var BE = new tb_cliente();
if (BL.Update2(EmpresaID, BE))
{
MessageBox.Show("Datos Modificados Correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
form_bloqueado(false);
btn_nuevo.Enabled = true;
btn_imprimir.Enabled = true;
btn_salir.Enabled = true;
btn_grabar.Enabled = false;
}
}
private void data_gridRazonSocial()
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
switch (cbo_filtro.SelectedValue)
{
case "01":
BE.ctacte = txt_filter.Text.Trim().ToUpper();
break;
case "02":
BE.ctactename = txt_filter.Text.Trim().ToUpper();
break;
default:
//**
break;
}
try
{
//Eliminar Columnas Actuales(Opcional):
GridView1.Columns.Clear();
GridView1.Width = 550;
//Objeto Columna:
CommandField image;
//Crear Columna:
image = new CommandField();
image.ButtonType = ButtonType.Image;
image.SelectImageUrl = "~/Images/go-search.png";
image.ShowSelectButton = true;
image.ItemStyle.Width = 10;
image.ItemStyle.Wrap = true;
GridView1.Columns.Add(image);
BoundField DDNNI;
DDNNI = new BoundField();
DDNNI.DataField = "ctacte";
DDNNI.HeaderText = "CODIGO";
DDNNI.ItemStyle.Width = 80;
GridView1.Columns.Add(DDNNI);
BoundField NOMBR;
NOMBR = new BoundField();
NOMBR.DataField = "ctactename";
NOMBR.HeaderText = "NOMBRES";
NOMBR.ItemStyle.Width = 250;
GridView1.Columns.Add(NOMBR);
GridView1.DataSource = BL.GetAll(Session["ssEmpresaID"].ToString(), BE);
GridView1.DataBind();
GridView1.Visible = true;
}
catch (Exception ex)
{
ClientMessage(ex.Message);
}
}
private void ValidaProveedor()
{
sw_novaluechange = true;
Int16 lc_cont = default(Int16);
bool zhallado = false;
string VMNROITEM = Examinar.Rows[Examinar.CurrentRow.Index].Cells["asientoitems"].Value.ToString();
string xcodartic = "..";
if ((!object.ReferenceEquals(Examinar.Rows[Examinar.CurrentRow.Index].Cells["nmruc"].Value, DBNull.Value)))
{
xcodartic = Examinar.Rows[Examinar.CurrentRow.Index].Cells["nmruc"].Value.ToString();
}
if (xcodartic.Trim().Length == 0)
{
tmpTablaContable.Rows[lc_cont]["nmruc"] = "";
tmpTablaContable.Rows[lc_cont]["ctactename"] = "";
zhallado = true;
}
else
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = xcodartic;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
for (lc_cont = 0; lc_cont <= tmpTablaContable.Rows.Count - 1; lc_cont++)
{
if (tmpTablaContable.Rows[lc_cont]["asientoitems"].ToString() == VMNROITEM)
{
if (tmptabla.Rows.Count > 0)
{
tmpTablaContable.Rows[lc_cont]["nmruc"] = tmptabla.Rows[0]["nmruc"];
tmpTablaContable.Rows[lc_cont]["ctactename"] = tmptabla.Rows[0]["ctactename"];
zhallado = true;
break;
}
}
}
}
if (!zhallado)
{
Examinar.Rows[Examinar.CurrentRow.Index].Cells["nmruc"].Value = j_detalle;
}
Examinar.Refresh();
sw_novaluechange = false;
}
private void ValidaProveedor()
{
DataTable tmtabla = null;
string xcodmotivo = "..";
if (txtRuc.Text.Trim().Length > 0)
{
xcodmotivo = txtRuc.Text.Trim();
}
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = xcodmotivo;
tmtabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmtabla.Rows.Count == 0)
{
txtRuc.Text = j_String;
}
else
{
txtCtacte.Text = tmtabla.Rows[0]["ctacte"].ToString().Trim();
txtRuc.Text = tmtabla.Rows[0]["nmruc"].ToString();
lblnomprov.Text = tmtabla.Rows[0]["ctactename"].ToString();
}
}
public void ValidaDetalle()
{
if (txtDetalle.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtDetalle.Text.Trim();
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
//tmptabla = ocapa.cag1000_CONSULTA(GlobalVars.GetInstance.CompanyGeneral, txtdetalle.Text, "", "", "", "", "", "", 1, "", 0, "", "");
if (BL.Sql_Error.Length == 0)
{
if (tmptabla.Rows.Count > 0)
{
txtNomdetalle.Text = tmptabla.Rows[0]["ctactename"].ToString().Trim();
U_CargaDatos();
}
}
}
}
private void ValidaProveedor()
{
if (txtRuc.Text.Trim().Length > 0)
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtRuc.Text;
DataTable tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count == 0)
{
txtRuc.Text = j_String;
}
else
{
xtipopersona = tmptabla.Rows[0]["tpperson"].ToString();
xtipodocidentidad = tmptabla.Rows[0]["docuidentid"].ToString();
xctacte = tmptabla.Rows[0]["ctacte"].ToString();
txtRuc.Text = tmptabla.Rows[0]["nmruc"].ToString();
txtCtactename.Text = tmptabla.Rows[0]["ctactename"].ToString();
xdirec = tmptabla.Rows[0]["direc"].ToString();
xubige = tmptabla.Rows[0]["ubige"].ToString();
}
}
else
{
txtRuc.Text = j_String;
}
}
void llenar_GridExaminar()
{
try
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
switch (cboCriterioBusqueda.SelectedItem.ToString())
{
case "Razón Social":
BE.ctactename = txtCadenaBuscar.Text.Trim().ToUpper();
break;
case "Ruc":
BE.nmruc = txtCadenaBuscar.Text.Trim().ToUpper();
break;
case "Código":
BE.ctacte = txtCadenaBuscar.Text.Trim().ToUpper();
break;
default:
BE.ctactename = txtCadenaBuscar.Text.Trim().ToUpper();
break;
}
//Sw_LOad = false;
if (GridExaminar.RowCount > 0)
{
GridExaminar.Focus();
GridExaminar.BeginEdit(true);
}
GridExaminar.AutoGenerateColumns = false;
GridExaminar.DataSource = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
U_pINTAR();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ValidaDetalle()
{
sw_novaluechange = true;
Int16 lc_cont = default(Int16);
bool zhallado = false;
string xcodartic = "..";
if (txtRuc.Text.Trim().Length > 0)
{
xcodartic = txtRuc.Text;
}
if (xcodartic.Trim().Length == 0)
{
}
else
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = xcodartic;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
//tmptabla = ocapa.cag1000_CONSULTA(GlobalVars.GetInstance.Company, xcodartic, "", "", "", "", "", "", 1, "", 0, "", "");
if (BL.Sql_Error.Length == 0)
{
if (tmptabla.Rows.Count > 0)
{
txtRuc.Text = tmptabla.Rows[lc_cont]["nmruc"].ToString();
txtCtactename.Text = tmptabla.Rows[lc_cont]["ctactename"].ToString();
zhallado = true;
}
}
}
if (!zhallado)
{
txtRuc.Text = j_ruc;
}
else
{
AnexaDetalle();
}
sw_novaluechange = false;
txtRuc.Focus();
}
private void ValidamosProcedencia()
{
var BL = new clienteBL();
var BE = new tb_cliente();
var dt = new DataTable();
BE.ctacte = _ctacte.ToString();
BE.filtro = "2";
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
if (moduloiddes.SelectedValue.ToString() != "0500")
{
dt.Rows[0]["ctacte"].ToString().Trim();
dt.Rows[0]["ctactename"].ToString().Trim();
var set_paisname = dt.Rows[0]["paisname"].ToString().Trim();
var set_paisid = dt.Rows[0]["paisid"].ToString().Trim();
if (set_paisid == "9589")
{
procedenciaid.SelectedIndex = 0;
txt_paisname.Text = set_paisname.ToString();
}
else
{
procedenciaid.SelectedIndex = 1;
txt_paisname.Text = set_paisname.ToString();
}
}
else
{
procedenciaid.SelectedIndex = 0;
txt_paisname.Text = "PERÚ";
}
}
}
public void ValidaDetalle()
{
sw_novaluechange = true;
Int16 lc_cont = default(Int16);
bool zhallado = false;
string xcodartic = "..";
if (txtRuc.Text.Trim().Length > 0)
{
xcodartic = txtRuc.Text;
}
if (xcodartic.Trim().Length == 0)
{
txtCtactename.Text = "";
zhallado = true;
}
else
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = xcodartic;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (tmptabla.Rows.Count > 0)
{
xctacte = tmptabla.Rows[lc_cont]["ctacte"].ToString();
txtRuc.Text = tmptabla.Rows[lc_cont]["nmruc"].ToString();
txtCtactename.Text = tmptabla.Rows[lc_cont]["ctactename"].ToString().Trim();
zhallado = true;
}
}
if (!zhallado)
{
txtRuc.Text = j_ruc;
}
sw_novaluechange = false;
}
private bool Validacion_Grabar()
{
object xobjeto = null;
int lc_cont = 0;
string xmsgstring = "";
DataTable tmptabla = new DataTable();
dynamic xfill = "###...";
if (txtCuentaid.Text.Trim().Length == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Configure Cuenta para retención del IGV !!!"));
xobjeto = txtCuentaid;
}
//if (txtCuentaidP.Text.Trim().Length == 0)
//{
// if (rbnPagos.Checked == true | rbnLetras.Checked == true)
// {
// xmsgstring = (xmsgstring + ("\r\n" + "Configure Cuenta para el pago o canje en letras !!!"));
// xobjeto = txtCuentaidP;
// }
//}
if (txtRuc.Text.Trim().Length == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Ingrese Proveedor !!!"));
xobjeto = txtRuc;
}
else
{
try
{
clienteBL BL = new clienteBL();
tb_cliente BE = new tb_cliente();
BE.nmruc = txtRuc.Text.Trim();
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0];
if ((BL.Sql_Error.Length > 0))
{
Frm_Class.ShowError(("Error al validar datos de proveedor" + ("\r\n" + BL.Sql_Error)), this);
return false;
}
if ((tmptabla.Rows.Count == 0))
{
xmsgstring = (xmsgstring + ("\r\n" + "Proveedor no existe"));
xobjeto = txtRuc;
}
//if ((BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]).Rows.Count == 0)
//{
// xmsgstring = (xmsgstring + ('\r' + "Proveedor no existe !!!"));
// xobjeto = txtRuc;
//}
else
{
if ((!object.ReferenceEquals(tmptabla.Rows[0]["agerent"], DBNull.Value)))
{
if (Convert.ToBoolean(tmptabla.Rows[0]["agerent"]))
{
xmsgstring = (xmsgstring + ("\r\n" + "No se puede aplicar retención sobre un Agente de Retención"));
xobjeto = txtRuc;
}
}
if ((!object.ReferenceEquals(tmptabla.Rows[0]["buencontr"], DBNull.Value)))
{
if (Convert.ToBoolean(tmptabla.Rows[0]["buencontr"]))
{
xmsgstring = (xmsgstring + ("\r\n" + "No se puede aplicar retención sobre un buen contribuyente"));
xobjeto = txtRuc;
}
}
if ((!object.ReferenceEquals(tmptabla.Rows[0]["agenperc"], DBNull.Value)))
{
if (Convert.ToBoolean(tmptabla.Rows[0]["agenperc"]))
{
xmsgstring = (xmsgstring + ("\r\n" + "No se puede aplicar retención sobre un Agente de Percepción"));
xobjeto = txtRuc;
}
}
}
}
catch (Exception ex)
{
DevExpress.XtraEditors.XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
decimal vmncambio = VariablesPublicas.StringtoDecimal(txtTipocambio.Text);
if (vmncambio == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Ingrese Tipo de Cambio !!!"));
xobjeto = fRegistro;
}
if ((txtGlosa.Text.Trim()).Trim().Length == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Ingrese glosa !!!"));
xobjeto = txtGlosa;
}
//if ((txtNumOpe.Text.Trim()).Trim().Length == 0)
//{
// xmsgstring = (xmsgstring + ("\r\n" + "Ingrese Número Cheque u Operación !!!"));
// xobjeto = txtNumOpe;
//}
decimal montoretencion = VariablesPublicas.StringtoDecimal(txtImpRetencion.Text);
if (montoretencion == 0)
{
xmsgstring = (xmsgstring + ("\r\n" + "Click en Botón Cálcular Retención !!!"));
xobjeto = btnCalcular;
}
if ((xmsgstring.Trim().Length == 0))
{
for (lc_cont = 0; (lc_cont <= (DetFacturacion.Rows.Count - 1)); lc_cont++)
{
if (((Convert.ToDecimal(DetFacturacion.Rows[lc_cont]["importeretencionsoles"]) == 0))) //&& (Convert.ToDecimal(DetFacturacion.Rows[lc_cont]["impretencion1"]) == 0)))
{
xmsgstring = (xmsgstring + ("\r\n" + "Ingrese Retención del documento"));
}
if (((DetFacturacion.Rows[lc_cont]["tipdoc"].ToString().Trim().Length > 0) && (DetFacturacion.Rows[lc_cont]["numdoc"].ToString().Trim().Length > 0)))
{
tb_co_ComprascabBL BLCO = new tb_co_ComprascabBL();
tb_co_Comprascab BECO = new tb_co_Comprascab();
BECO.nmruc = txtRuc.Text.Trim();
BECO.tipodoc = DetFacturacion.Rows[lc_cont]["tipdoc"].ToString();
BECO.serdoc = DetFacturacion.Rows[lc_cont]["serdoc"].ToString();
BECO.numdoc = DetFacturacion.Rows[lc_cont]["numdoc"].ToString();
tmptabla = BLCO.GetAll(VariablesPublicas.EmpresaID.ToString(), BECO).Tables[0];
//tmptabla = ocapa.KAG0300_consulta(GlobalVars.GetInstance.Company, "", "", "", "", "", TXTCODCLIENTE.Text, DetFacturacion.Rows[lc_cont]["tipdoc_3a"], DetFacturacion.Rows[lc_cont]["numdoc"].Substring(0, 4), DetFacturacion.Rows[lc_cont]["numdoc"].Substring(5, 8));
if ((BLCO.Sql_Error.Length > 0))
{
Frm_Class.ShowError(("Error al validar documento de Compra " + ("\r\n" + BLCO.Sql_Error)), this);
return false;
}
if ((tmptabla.Rows.Count > 0))
{
if ((Convert.ToBoolean(tmptabla.Rows[0]["afecdetraccion"]) == true))
{
xmsgstring = (xmsgstring + "\r\n"
+ "Asiento R/C N°: " + tmptabla.Rows[0]["diarioid"].ToString() + "/" + tmptabla.Rows[0]["perimes"].ToString() + "-" + tmptabla.Rows[0]["asiento"].ToString() + "\r\n"
+ "Comprobante N°: "
+ DetFacturacion.Rows[lc_cont]["tipdoc"].ToString() + "/" + DetFacturacion.Rows[lc_cont]["serdoc"].ToString() + "-" + DetFacturacion.Rows[lc_cont]["numdoc"].ToString() + "\r\n"
+ "Tiene Detracción ... Imposible Aplicar Retención");
}
}
}
}
}
if (xmsgstring.Trim().Length == 0)
{
//if (u_n_opsel == 1 | (W_KEY0001 != cboTipdoc.SelectedValue.ToString().Trim() + txtSerie.Text.Trim() + txtNumero.Text.Trim()))
//{
// tmptabla = null;
// try
// {
// tb_co_retencionescabBL BL = new tb_co_retencionescabBL();
// tb_co_retencionescab BE = new tb_co_retencionescab();
// //BE.nmruc = txtRuc.Text;
// BE.tipdoc = cboTipdoc.SelectedValue.ToString().Trim();
// BE.serdoc = txtSerie.Text.Trim();
// BE.numdoc = txtNumero.Text.Trim();
// 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]["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 ValidaCliente()
{
if (txt_ctacte.Text.Trim().Length > 0)
{
var BL = new clienteBL();
var BE = new tb_cliente();
var dt = new DataTable();
BE.ctacte = txt_ctacte.Text.Trim().PadLeft(7, '0');
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
txt_ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
txt_ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
}
else
{
txt_ctacte.Text = string.Empty;
txt_ctactename.Text = string.Empty;
}
}
}
private bool U_Validacion()
{
var xmsg = string.Empty;
var objeto = new object();
var tmptabla = new DataTable();
if ((txtrazonsocial.Text.Trim().Length == 0))
{
xmsg = "Ingrese Razón Social / Nombres de cliente";
objeto = txtrazonsocial;
}
else
{
if ((txtmnruc.Text.Length > 0))
{
if (((u_n_opsel == 1) || !(j_Ruc == txtmnruc.Text)))
{
var BL = new clienteBL();
var BE = new tb_cliente();
BE.nmruc = txtmnruc.Text;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if ((tmptabla.Rows.Count > 0))
{
xmsg = "RUC ya registrado";
objeto = txtmnruc;
}
}
}
if ((u_n_opsel == 1))
{
if ((txtcodigo.Text.Trim().Length == 0))
{
xmsg = "Ingrese Código";
objeto = txtcodigo;
}
else
{
var BL = new clienteBL();
var BE = new tb_cliente();
BE.ctacte = txtcodigo.Text;
tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if ((tmptabla.Rows.Count > 0))
{
xmsg = "Código ya registrado";
objeto = txtcodigo;
}
}
}
}
if ((xmsg.Trim().Length > 0))
{
MessageBox.Show(xmsg, "Error en Ingreso de Datos", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (!(objeto == null))
{
objeto = Focus();
}
}
return xmsg.Trim().Length == 0;
}
