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