public bool Delete(string empresaid, tb_cp_comercialcab BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialcab_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@empresa", SqlDbType.Char, 2).Value = BE.empresa;
cmd.Parameters.Add("@asiento", SqlDbType.Char, 10).Value = BE.asiento;
}
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_cp_comercialcab BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialcab_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@empresa", SqlDbType.Char, 2).Value = BE.empresa;
cmd.Parameters.Add("@asiento", SqlDbType.Char, 10).Value = BE.asiento;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
cmd.Parameters.Add("@fechemision", SqlDbType.DateTime).Value = BE.fechemision;
cmd.Parameters.Add("@fechtermino", SqlDbType.DateTime).Value = BE.fechtermino;
cmd.Parameters.Add("@mnruc", SqlDbType.Char, 11).Value = BE.mnruc;
cmd.Parameters.Add("@ctactename", SqlDbType.VarChar, 80).Value = BE.ctactename;
cmd.Parameters.Add("@vendedorid", SqlDbType.Char, 4).Value = BE.vendedorid;
cmd.Parameters.Add("@brokerid", SqlDbType.Char, 4).Value = BE.brokerid;
cmd.Parameters.Add("@paisid", SqlDbType.Char, 4).Value = BE.paisid;
cmd.Parameters.Add("@mercadoid", SqlDbType.Char, 1).Value = BE.mercadoid;
cmd.Parameters.Add("@marcaid", SqlDbType.Char, 4).Value = BE.marcaid;
cmd.Parameters.Add("@proforma", SqlDbType.Text).Value = BE.proforma;
cmd.Parameters.Add("@usuar", SqlDbType.VarChar, 200).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);
}
}
}
}
public bool Update(string empresaid, tb_cp_comercialcab BE)
{
return tablaDA.Update(empresaid, BE);
}
public bool Insert(string empresaid, tb_cp_comercialcab BE)
{
return tablaDA.Insert(empresaid, BE);
}
public DataSet GetOne(string empresaid, tb_cp_comercialcab BE)
{
return tablaDA.GetOne(empresaid, BE);
}
public DataSet GetAsientoRoleo(string empresaid, tb_cp_comercialcab BE)
{
return tablaDA.GetAsientoRoleo(empresaid, BE);
}
public DataSet GetAll_paginacion(string empresaid, tb_cp_comercialcab BE)
{
return tablaDA.GetAll_paginacion(empresaid, BE);
}
public DataSet GetAllNuevoNumero(string empresaid, tb_cp_comercialcab BE)
{
return tablaDA.GetAll_NuevoNumero(empresaid, BE);
}
private void LlenarGrilla()
{
try
{
var BL = new tb_cp_comercialcabBL();
var BE = new tb_cp_comercialcab();
if (cboVendedor.Enabled)
{
if ((cboVendedor.SelectedValue != null))
{
BE.vendedorid = cboVendedor.SelectedValue.ToString();
}
}
if (Fechaini.Enabled)
{
}
if (txtEstilo.Enabled)
{
}
pTabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataSet GetAll_NuevoNumero(string empresaid, tb_cp_comercialcab BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCmOrdenseries_Nuevonumero", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@ser_op", SqlDbType.Char, 4).Value = BE.serop;
}
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_cp_comercialcab BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialcab_UPDATE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@empresa", SqlDbType.Char, 2).Value = BE.empresa;
cmd.Parameters.Add("@asiento", SqlDbType.Char, 10).Value = BE.asiento;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
cmd.Parameters.Add("@fechemision", SqlDbType.DateTime).Value = BE.fechemision;
cmd.Parameters.Add("@fechtermino", SqlDbType.DateTime).Value = BE.fechtermino;
cmd.Parameters.Add("@mnruc", SqlDbType.Char, 11).Value = BE.mnruc;
cmd.Parameters.Add("@ctactename", SqlDbType.VarChar, 80).Value = BE.ctactename;
cmd.Parameters.Add("@vendedorid", SqlDbType.Char, 4).Value = BE.vendedorid;
cmd.Parameters.Add("@brokerid", SqlDbType.Char, 4).Value = BE.brokerid;
cmd.Parameters.Add("@paisid", SqlDbType.Char, 4).Value = BE.paisid;
cmd.Parameters.Add("@mercadoid", SqlDbType.Char, 1).Value = BE.mercadoid;
cmd.Parameters.Add("@marcaid", SqlDbType.Char, 4).Value = BE.marcaid;
cmd.Parameters.Add("@proforma", SqlDbType.Text).Value = BE.proforma;
cmd.Parameters.Add("@status", SqlDbType.Bit).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.VarChar, 200).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 GetOne(string empresaid, tb_cp_comercialcab BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialcab_SELECT", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio;
cmd.Parameters.Add("@asiento", SqlDbType.Char, 10).Value = BE.asiento;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_paginacion(string empresaid, tb_cp_comercialcab BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbComercial_SEARCH_paginacion", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
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.tipdoc;
cmd.Parameters.Add("@serdoc", SqlDbType.Char, 4).Value = BE.serdoc;
cmd.Parameters.Add("@numdoc", SqlDbType.Char, 10).Value = BE.numdoc;
cmd.Parameters.Add("@posicion", SqlDbType.Char, 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);
}
}
}
}
private void get_autoCS_numPedido()
{
try
{
var BL = new tb_cp_comercialcabBL();
var BE = new tb_cp_comercialcab();
var dt = new DataTable();
BE.moduloid = modulo;
BE.perianio = VariablesPublicas.perianio;
BE.serop = ser_op.Text;
dt = BL.GetAllNuevoNumero(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
serdoc.Text = dt.Rows[0]["perianio"].ToString();
numdoc.Text = dt.Rows[0]["Cnum_cp"].ToString();
ser_op.Text = dt.Rows[0]["ser_op"].ToString();
num_op.Text = dt.Rows[0]["Cnum_op"].ToString();
}
else
{
serdoc.Text = string.Empty;
numdoc.Text = string.Empty;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void form_cargar_datos(String posicion)
{
try
{
limpiar_documento();
var BL = new tb_cp_comercialcabBL();
var BE = new tb_cp_comercialcab();
var dt = new DataTable();
BE.moduloid = modulo;
BE.local = local;
BE.tipdoc = tipdoc.Text;
BE.serdoc = serdoc.Text.Trim().PadLeft(4, '0');
if (numdoc.Text.Trim().Length > 0)
{
BE.numdoc = numdoc.Text.Trim().PadLeft(10, '0');
}
BE.posicion = posicion.Trim();
dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
ssModo = "EDIT";
serdoc.Text = dt.Rows[0]["serdoc"].ToString().Trim();
numdoc.Text = dt.Rows[0]["numdoc"].ToString().Trim();
fechdoc.Text = dt.Rows[0]["fechdoc"].ToString().Trim();
ctacte.Text = dt.Rows[0]["ctacte"].ToString().Trim();
ctactename.Text = dt.Rows[0]["ctactename"].ToString().Trim();
cboCanalventa.SelectedValue = dt.Rows[0]["canalventaid"].ToString().Trim();
if (dt.Rows[0]["fechentrega"].ToString().Trim().Substring(0, 10) != "01/01/1900")
{
fechentrega.Format = DateTimePickerFormat.Short;
fechentrega.Text = dt.Rows[0]["fechentrega"].ToString().Trim();
}
glosa.Text = dt.Rows[0]["observacion"].ToString().Trim();
data_TabladetallePedido();
if (dt.Rows[0]["status"].ToString().Trim() != "9")
{
btn_editar.Enabled = true;
btn_eliminar.Enabled = true;
btn_imprimir.Enabled = true;
btn_attachedfile.Enabled = true;
btn_salir.Enabled = true;
griddetallepedido.Focus();
griddetallepedido.Rows[0].Selected = false;
;
}
else
{
ssModo = "ANULADO";
btn_editar.Enabled = false;
btn_eliminar.Enabled = false;
btn_imprimir.Enabled = true;
btn_salir.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
