public bool Delete(string empresaid, tb_cp_comercialdet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialdet_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_comercialdet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialdet_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 DataSet GetAll_datosdetalle(string empresaid, tb_cp_comercialdet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercial_SEARCH_datosdetalle", 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;
}
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_comercialdet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialdet_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_comercialdet BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCpComercialdet_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);
}
}
}
}
private void data_TabladetallePedido2()
{
try
{
griddetallepedido2.AutoGenerateColumns = false;
var BL = new tb_cp_comercialdetBL();
var BE = new tb_cp_comercialdet();
var dt = new DataTable();
BE.moduloid = modulo;
BE.local = local;
BE.tipdoc = tipdoc.Text.ToString().Trim();
BE.serdoc = serdoc.Text.Trim().PadLeft(4, '0');
BE.numdoc = numdoc.Text.Trim().PadLeft(6, '0');
dt = BL.GetAll_datosdetalle(EmpresaID, BE).Tables[0];
if (TabladetallePedido2 != null)
{
TabladetallePedido2.Clear();
}
if (TabladetallePedido != null)
{
TabladetallePedido.Clear();
}
foreach (DataRow fila in dt.Rows)
{
row = TabladetallePedido2.NewRow();
row["colorid"] = fila["colorid"].ToString();
row["prop01"] = fila["prop01"].ToString();
row["prop02"] = fila["prop02"].ToString();
row["prop03"] = fila["prop03"].ToString();
row["prop04"] = fila["prop04"].ToString();
row["prop05"] = fila["prop05"].ToString();
row["prop06"] = fila["prop06"].ToString();
row["prop07"] = fila["prop07"].ToString();
row["prop08"] = fila["prop08"].ToString();
row["prop09"] = fila["prop09"].ToString();
row["prop10"] = fila["prop10"].ToString();
row["prop11"] = fila["prop11"].ToString();
row["prop12"] = fila["prop12"].ToString();
row["panios"] = fila["panios"].ToString();
row["cantot"] = fila["cantot"].ToString();
row["cpromxpda"] = fila["cpromxpda"].ToString();
row["observacion"] = fila["observacion"].ToString();
row["talla01"] = fila["talla01"].ToString();
row["talla02"] = fila["talla02"].ToString();
row["talla03"] = fila["talla03"].ToString();
row["talla04"] = fila["talla04"].ToString();
row["talla05"] = fila["talla05"].ToString();
row["talla06"] = fila["talla06"].ToString();
row["talla07"] = fila["talla07"].ToString();
row["talla08"] = fila["talla08"].ToString();
row["talla09"] = fila["talla09"].ToString();
row["talla10"] = fila["talla10"].ToString();
row["talla11"] = fila["talla11"].ToString();
row["talla12"] = fila["talla12"].ToString();
TabladetallePedido2.Rows.Add(row);
}
griddetallepedido2.DataSource = TabladetallePedido2;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}