public SqlDataAdapter ListarLineas() { CargaParametroMat(); RegCatLinea OpLst = new RegCatLinea(db); return(OpLst.ListLineas()); }
public int ActualizaLinea() { CargaParametroMat(); RegCatLinea OpUp = new RegCatLinea(MatParam, db); return(OpUp.UpdateLinea()); }
public int AgregarLinea() { CargaParametroMat(); RegCatLinea OpRadd = new RegCatLinea(MatParam, db); return(OpRadd.AddRegLinea()); }
public int EliminaLinea() { //CargaParametroMat(); MatParam = new object[1, 2]; MatParam[0, 0] = "CveLinea"; MatParam[0, 1] = CveLinea; RegCatLinea OpDel = new RegCatLinea(MatParam, db); return(OpDel.DeleteLinea()); }
public DataTable CboLinea() { CargaParametroMat(); RegCatLinea OpLst = new RegCatLinea(db); DataSet Cbo = new DataSet(); OpLst.ComboLinea().Fill(Cbo); return(Cbo.Tables[0]); }
public SqlDataAdapter BuscaLinea(string buscar) { /* MatParam = new object[4, 2]; * MatParam[0, 0] = "CodLinea"; MatParam[0, 1] = buscar; * MatParam[1, 0] = "Descripcion"; MatParam[1, 1] = buscar; * MatParam[2, 0] = "Ubicacion"; MatParam[2, 1] = buscar; * MatParam[3, 0] = "Encargado"; MatParam[3, 1] = buscar; * RegCatLinea OpBsq = new RegCatLinea(MatParam);/ */ RegCatLinea OpBsq = new RegCatLinea(db); return(OpBsq.BuscaLinea(buscar)); }
public void EditarLinea() { MatParam = new object[1, 2]; MatParam[0, 0] = "CveLinea"; MatParam[0, 1] = CveLinea; RegCatLinea OpEdit = new RegCatLinea(MatParam, db); Datos = OpEdit.RegistroActivo(); DataSet Ds = new DataSet(); Datos.Fill(Ds); object[] ObjA = Ds.Tables[0].Rows[0].ItemArray; CveLinea = ObjA[0].ToString(); Descripcion = ObjA[1].ToString(); Estatus = ObjA[2].ToString(); }