public DataSet GetAll(string empresaid, tb_pp_variante BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPpVariante_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@variante", SqlDbType.Char, 6).Value = BE.variante; cmd.Parameters.Add("@codtizado", SqlDbType.Char, 8).Value = BE.codtizado; cmd.Parameters.Add("@variantename", SqlDbType.VarChar, 50).Value = BE.variantename; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public DataSet GeneraCod(string empresaid, tb_pp_variante BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPpVariante_GEN_Codigo", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@marcaid", SqlDbType.Char, 2).Value = BE.marcaid; } 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_pp_variante BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPpVariante_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@variante", SqlDbType.Char, 6).Value = BE.variante; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
private void CargarDatosVariantes(String _xcodvar) { var BL = new tb_pp_varianteBL(); var BE = new tb_pp_variante(); var dt = new DataTable(); BE.variante = _xcodvar.ToString(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { articname.Text = dt.Rows[0]["variantename"].ToString(); cmb_categoriaid.SelectedValue = dt.Rows[0]["categoriaid"].ToString(); marcaid.Text = dt.Rows[0]["marcaid"].ToString(); marcaname.Text = dt.Rows[0]["marcaname"].ToString(); _xmarcadescort = dt.Rows[0]["marcadescort"].ToString(); lineaid.Text = dt.Rows[0]["lineaid"].ToString(); lineaname.Text = dt.Rows[0]["lineaname"].ToString(); if (dt.Rows[0]["lineadescort"].ToString() == string.Empty) { _xlineadescort = dt.Rows[0]["lineaname"].ToString(); } else { _xlineadescort = dt.Rows[0]["lineadescort"].ToString(); } modeloid.Text = dt.Rows[0]["modeloid"].ToString(); modeloname.Text = dt.Rows[0]["modeloname"].ToString(); _xmodelodescort = dt.Rows[0]["modelodescort"].ToString(); familiatelaid.Text = dt.Rows[0]["familiatelaid"].ToString(); familiatelaname.Text = dt.Rows[0]["familianame"].ToString(); cmb_generoid.SelectedValue = dt.Rows[0]["generoid"].ToString(); cmb_categoriaid.SelectedValue = dt.Rows[0]["categoriaid"].ToString(); cmb_botapieid.SelectedValue = dt.Rows[0]["botapieid"].ToString(); cmb_entalleid.SelectedValue = dt.Rows[0]["entalleid"].ToString(); cmb_parteid.SelectedValue = dt.Rows[0]["parteid"].ToString(); } }
private void Insert() { try { if (variante.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo Variante !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (marcaid.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo de Marca", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (lineaid.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo de Linea", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (modeloid.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo de Modelo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (familiatelaid.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo de FamiliaTelas", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (codtizado.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo de Articulo-Generado", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (cmb_categoriaid.SelectedIndex == -1) { MessageBox.Show("Falta Seleccionar La Categoria", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (cmb_generoid.SelectedIndex == -1) { MessageBox.Show("Falta Seleccionar el Genero", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (cmb_parteid.SelectedIndex == -1) { MessageBox.Show("Falta Seleccionar Parte ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (cmb_entalleid.SelectedIndex == -1) { MessageBox.Show("Falta Seleccionar Entalle", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_pp_varianteBL(); var BE = new tb_pp_variante(); BE.variante = variante.Text.ToString(); BE.codtizado = codtizado.Text.ToString(); BE.variantename = variantename.Text.ToString(); BE.categoriaid = cmb_categoriaid.SelectedValue.ToString(); BE.marcaid = marcaid.Text.Trim(); BE.lineaid = lineaid.Text.Trim(); BE.generoid = cmb_generoid.SelectedValue.ToString(); BE.tejidoid = _tejidoid.ToString(); BE.familiatelaid = familiatelaid.Text.Trim(); BE.botapieid = cmb_botapieid.SelectedValue.ToString(); BE.entalleid = cmb_entalleid.SelectedValue.ToString(); BE.modeloid = modeloid.Text.Trim(); BE.parteid = cmb_parteid.SelectedValue.ToString(); BE.aprobado = chk_aprobado.Checked; BE.perianio = cboanio.SelectedValue.ToString(); BE.perimes = cboMesini.SelectedValue.ToString(); BE.diseñadorid = cmb_disenadorid.SelectedValue.ToString(); if (fech_prese.Checked) { BE.fechprese = Convert.ToDateTime(fech_prese.Text); } if (fech_aprob.Checked) { BE.fechaprob = Convert.ToDateTime(fech_aprob.Text); } BE.tippy = tip_py.Text.ToString(); BE.serppy = ser_py.Text.ToString(); BE.numppy = num_py.Text.ToString(); BE.status = "0"; BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Insert(EmpresaID, BE)) { MessageBox.Show("Datos Grabados Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); procesado = true; } } } } } } } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Delete() { try { if (variante.Text.Trim().Length != 6) { MessageBox.Show("Falta Codigo Variante !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_pp_varianteBL(); var BE = new tb_pp_variante(); BE.variante = variante.Text.ToString(); BE.codtizado = codtizado.Text.ToString(); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos Eliminados Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); form_bloqueado(false); data_TablaVariante(); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_TablaVariante() { try { if (TablaVariante.Rows.Count > 0) { TablaVariante.Rows.Clear(); } var BL = new tb_pp_varianteBL(); var BE = new tb_pp_variante(); BE.variantename = txt_criterio.Text.ToString(); TablaVariante = BL.GetAll(EmpresaID, BE).Tables[0]; if (TablaVariante.Rows.Count > 0) { btn_imprimir.Enabled = true; MDI_gridvariante.DataSource = TablaVariante; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void _GenerarCodigo() { var BE = new tb_pp_variante(); var BL = new tb_pp_varianteBL(); var dt = new DataTable(); BE.marcaid = marcaid.Text.Trim().ToString(); dt = BL.GeneraCod(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { variante.Text = dt.Rows[0]["Codigo"].ToString(); } else { variante.Text = "ERROR"; } }
public bool Update_foto(string empresaid, tb_pp_variante BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_UPDATE_foto", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@articidold", SqlDbType.Char, 8).Value = BE.articidold; //cmd.Parameters.Add("@docname", SqlDbType.VarChar, 100).Value = BE.docname; //cmd.Parameters.Add("@foto", SqlDbType.Image).Value = BE.Foto; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Update(string empresaid, tb_pp_variante BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPpVariante_UPDATE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@variante", SqlDbType.Char, 6).Value = BE.variante; cmd.Parameters.Add("@codtizado", SqlDbType.Char, 8).Value = BE.codtizado; cmd.Parameters.Add("@variantename", SqlDbType.VarChar, 50).Value = BE.variantename; cmd.Parameters.Add("@categoriaid", SqlDbType.Char, 2).Value = BE.categoriaid; cmd.Parameters.Add("@marcaid", SqlDbType.Char, 2).Value = BE.marcaid; cmd.Parameters.Add("@lineaid", SqlDbType.Char, 2).Value = BE.lineaid; cmd.Parameters.Add("@generoid", SqlDbType.Char, 1).Value = BE.generoid; cmd.Parameters.Add("@tejidoid", SqlDbType.Char, 2).Value = BE.tejidoid; cmd.Parameters.Add("@familiatelaid", SqlDbType.Char, 3).Value = BE.familiatelaid; cmd.Parameters.Add("@botapieid", SqlDbType.Char, 2).Value = BE.botapieid; cmd.Parameters.Add("@entalleid", SqlDbType.Char, 2).Value = BE.entalleid; cmd.Parameters.Add("@modeloid", SqlDbType.Char, 4).Value = BE.modeloid; cmd.Parameters.Add("@parteid", SqlDbType.Char, 1).Value = BE.parteid; cmd.Parameters.Add("@aprobado", SqlDbType.Bit).Value = BE.aprobado; cmd.Parameters.Add("@perianio", SqlDbType.Char, 4).Value = BE.perianio; cmd.Parameters.Add("@perimes", SqlDbType.Char, 2).Value = BE.perimes; cmd.Parameters.Add("@disenadorid", SqlDbType.Char, 4).Value = BE.diseñadorid; cmd.Parameters.Add("@fechprese", SqlDbType.DateTime).Value = BE.fechprese; cmd.Parameters.Add("@fechaprob", SqlDbType.DateTime).Value = BE.fechaprob; cmd.Parameters.Add("@tippy", SqlDbType.Char, 2).Value = BE.tippy; cmd.Parameters.Add("@serpy", SqlDbType.Char, 4).Value = BE.serppy; cmd.Parameters.Add("@numpy", SqlDbType.Char, 10).Value = BE.numppy; cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status; cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).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 GetAll_foto(string empresaid, tb_pp_variante BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtArticulo_SEARCH_foto", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@articidold", SqlDbType.Char, 8).Value = BE.articidold; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }