Esempio n. 1
0
        public static clsActive SelectRow(int codigo)
        {
            DAOActive daoProxy = new DAOActive();
            DataSet dtsProxy = daoProxy.selectRow(codigo);

            return Load(dtsProxy.Tables[0].Rows[0]);
        }
Esempio n. 2
0
        public static List<clsActive> SelectByName(string nombre)
        {
            DAOActive daoProxy = new DAOActive();
            DataSet dtsProxy = daoProxy.selectByName(nombre);

            return LoadList(dtsProxy.Tables[0]);
        }
Esempio n. 3
0
        public static List<clsActive> SelectAll()
        {
            DAOActive daoProxy = new DAOActive();
            DataSet dtsProxy = daoProxy.selectAll();

            return LoadList(dtsProxy.Tables[0]);
        }
Esempio n. 4
0
        public static bool Delete(int iActive_id)
        {
            ValidationException x = new ValidationException();
            if (iActive_id <= 0)
                x.AgregarError("Ingrese el código del Activo");

            if (x.Cantidad > 0)
                throw x;

            DAOActive daoProxy = new DAOActive();
            return daoProxy.Delete(iActive_id);
        }
Esempio n. 5
0
        public static int Insert(clsActive objProxy)
        {
            ValidationException x = new ValidationException();
            //if (string.IsNullOrEmpty(objProxy.SActive_name))
            //    x.AgregarError("Ingrese el nombre del Activo");

            //if (x.Cantidad > 0)
            //    throw x;

            DAOActive daoProxy = new DAOActive();
            return daoProxy.Insert(objProxy.SActive_name,
                                    objProxy.ISubFamily_id.ISubFamily_id,
                                    objProxy.IProvider_id.IProvider_id,
                                    objProxy.SActive_desc,
                                    objProxy.SBarCode,
                                    objProxy.DRegister_time,
                                    objProxy.IUtilTime,
                                    objProxy.SBrand,
                                    objProxy.SModel,
                                    objProxy.SForm,
                                    objProxy.SSerialNumber,
                                    objProxy.SColor,
                                    objProxy.SCapacity,
                                    objProxy.SMaterial,
                                    objProxy.IHeihgt,
                                    objProxy.IWidth,
                                    objProxy.IWide,
                                    objProxy.IDiameter,
                                    objProxy.SUnit,
                                    objProxy.IDivNumber,
                                    objProxy.SAsign_Type,
                                    objProxy.SAquisition_Type,
                                    objProxy.DtBuy_time,
                                    objProxy.IBuy_price,
                                    objProxy.SStatus);
        }
Esempio n. 6
0
        public static clsActive TraerXid(int codigo)
        {
            DAOActive daoProxy = new DAOActive();
            DataSet dtsProxy = daoProxy.TraerXId(codigo);

            return Load(dtsProxy.Tables[0].Rows[0]);
        }