예제 #1
0
        public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE GetModuleById(int moduelId)
        {
            VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE module = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE();
            try
            {
                CBE.ModuleCollection modules = new CBE.ModuleCollection();

                string    spName  = Constants.oraclePackagePrefix + "Module_GetById";
                DbCommand command = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.GetStoredProcCommand(spName);

                command.Parameters.Add(VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.CreateDbParameter(ref command, "p_module_id", DbType.Int32, module.ModuleId, ParameterDirection.Input));
                DataSet   ds = VaaaN.MLFF.Libraries.CommonLibrary.DBA.DBAccessor.LoadDataSet(command, tableName);
                DataTable dt = ds.Tables[tableName];

                if (dt != null && dt.Rows.Count > 0)
                {
                    module.ModuleId     = moduelId;
                    module.ModuleName   = Convert.ToString(dt.Rows[0]["MODULE_NAME"]);
                    module.IsGuiVisible = Convert.ToInt32(dt.Rows[0]["IS_GUI_VISIBLE"]);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(module);
        }
예제 #2
0
 public static VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE GetModuleById(VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE module)
 {
     return(VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.GetModuleById(module));
 }
예제 #3
0
 public static void Update(VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE module)
 {
     VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.Update(module);
 }
예제 #4
0
 public static void Insert(VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE module)
 {
     VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.Insert(module);
 }