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); } }