public bool Delete(string empresaid, tb_pt_articulocolor BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtArticulocolor_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@articid", SqlDbType.Char, 4).Value = BE.articid; cmd.Parameters.Add("@colorid", SqlDbType.Char, 3).Value = BE.colorid; } 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_pt_articulocolor BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbPtArticulocolor_SEARCH", cnx)) { DataSet ds = new DataSet(); { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@articid", SqlDbType.Char, 4).Value = BE.articid; cmd.Parameters.Add("@colorid", SqlDbType.Char, 3).Value = BE.colorid; cmd.Parameters.Add("@colorname", SqlDbType.VarChar, 30).Value = BE.colorname; cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status; cmd.Parameters.Add("@filtro", SqlDbType.Char, 1).Value = BE.filtro; } try { cnx.Open(); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } return ds; } catch (Exception ex) { throw new Exception(ex.Message); } } } }
void ValidaArticuloColor() { if (xarticid.Length == 0) { MessageBox.Show("Seleccione Primero Un Articulo !!!", "Información"); return; } else { tb_pt_articulocolorBL BL = new tb_pt_articulocolorBL(); tb_pt_articulocolor BE = new tb_pt_articulocolor(); DataTable dt = new DataTable(); BE.articid = xarticid.ToString(); BE.colorid = txt_colorid.Text.ToString().ToUpper(); BE.status = "0".ToString(); BE.filtro = "1"; dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { txt_colorid.Text = dt.Rows[0]["colorid"].ToString(); txt_colorname.Text = dt.Rows[0]["colorname"].ToString(); btn_add.Enabled = true; } } }
private void Update_dbf() { try { if (colorid.Text.Trim().Length == 0) { MessageBox.Show("Falta Codigo Color !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (articid.Text.Trim().Length == 0) { MessageBox.Show("Ingrese Codigo Articulo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_pt_articulocolorBL(); var BE = new tb_pt_articulocolor(); BE.articid = articidold.Text.Trim(); BE.colorid = colorid.Text.Trim(); BE.status = cmb_estado.SelectedIndex.ToString(); BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Update_dbf(EmpresaID, BE)) { SEGURIDAD_LOG("M"); MessageBox.Show("Datos Modificado 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 (colorid.Text.Trim().Length != 3) { MessageBox.Show("Falta Codigo Color !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new tb_pt_articulocolorBL(); var BE = new tb_pt_articulocolor(); BE.articid = articid.Text.Trim(); BE.colorid = colorid.Text.Trim(); BE.status = cmb_estado.SelectedIndex.ToString(); BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos Eliminado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); form_bloqueado(false); data_Tablacolor(); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_Tablacolor() { try { Tablacolor = new DataTable(); if (Tablacolor.Rows.Count > 0) { Tablacolor.Rows.Clear(); } var BL = new tb_pt_articulocolorBL(); var BE = new tb_pt_articulocolor(); BE.articid = articid.Text.Trim(); BE.colorname = txt_criterio.Text.Trim().ToUpper(); Tablacolor = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tablacolor.Rows.Count > 0) { btn_imprimir.Enabled = true; MDI_gridcolor.DataSource = Tablacolor; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool Insert_dbf(string empresaid, tb_pt_articulocolor BE) { Conex_FoxDA cone = new Conex_FoxDA(); using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion())) { String commandString = "INSERT INTO ptema712 (pt712stat ,pt712idar ,pt712idco ,pt712usid ,pt712feac ,ensql ,status) " + "VALUES (?, ?, ?, ?, ?, ?, ?) "; OleDbCommand cmd = new OleDbCommand(commandString, cnx); cmd.Parameters.Add("@pt712stat ", OleDbType.Decimal).Value = 1; cmd.Parameters.Add("@pt712idar ", OleDbType.Char, 7).Value = BE.articid.ToString(); cmd.Parameters.Add("@pt712idco ", OleDbType.Char, 3).Value = BE.colorid.ToString(); cmd.Parameters.Add("@pt712usid ", OleDbType.Char, 3).Value = BE.usuar.ToString(); cmd.Parameters.Add("@pt712feac ", OleDbType.Date).Value = DateTime.Today.ToShortDateString(); cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 1; cmd.Parameters.Add("@status ", OleDbType.Char, 1).Value = BE.status.ToString(); cnx.Open(); try { if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } }
public bool Update_dbf(string empresaid, tb_pt_articulocolor BE) { Conex_FoxDA cone = new Conex_FoxDA(); using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion())) { String commandString = "UPDATE ptema712 SET pt712idco = ? ,pt712usid = ? ,pt712feac = ? ,ENSQL = ? ,status = ? " + " WHERE pt712idar = ? "; OleDbCommand cmd = new OleDbCommand(commandString, cnx); //cmd.Parameters.Add("@pt712stat ", OleDbType.Decimal).Value = 1; cmd.Parameters.Add("@pt712idar ", OleDbType.Char, 7).Value = BE.articid.ToString(); cmd.Parameters.Add("@pt712idco ", OleDbType.Char, 3).Value = BE.colorid.ToString(); cmd.Parameters.Add("@pt712usid ", OleDbType.Char, 3).Value = BE.usuar.ToString(); cmd.Parameters.Add("@pt712feac ", OleDbType.Date).Value = DateTime.Today.ToShortDateString(); cmd.Parameters.Add("@ENSQL ", OleDbType.Boolean).Value = 1; cmd.Parameters.Add("@status ", OleDbType.Char, 1).Value = BE.status.ToString(); cnx.Open(); try { if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } }
public bool Update_dbf(string empresaid, tb_pt_articulocolor BE) { return tablaDA.Update_dbf(empresaid, BE); }
public bool Insert_dbf(string empresaid, tb_pt_articulocolor BE) { return tablaDA.Insert_dbf(empresaid, BE); }
public DataSet GetAll(string empresaid, tb_pt_articulocolor BE) { return tablaDA.GetAll(empresaid, BE); }
public bool Delete(string empresaid, tb_pt_articulocolor BE) { return tablaDA.Delete(empresaid, BE); }
private void CargarComboArticuloColor(String xarticid) { // Cargamos el Combo de Colores de Acuerdo al Articulo tb_pt_articulocolorBL BL2 = new tb_pt_articulocolorBL(); tb_pt_articulocolor BE2 = new tb_pt_articulocolor(); DataTable dt2 = new DataTable(); BE2.articid = xarticid.ToString(); dt2 = BL2.GetAll(Session["ssEmpresaID"].ToString(), BE2).Tables[0]; cmb_colorid.DataSource = dt2; cmb_colorid.ValueField = "colorid"; cmb_colorid.TextField = "colorname"; cmb_colorid.DataBind(); }