public FullFactorialDOEStudySergio(string name, string description, WorkflowComponent studiedComponent, List <BoundedDesignVariableNoInitial> factors, List <Data> responses, bool createFolder, string parentName = "")
            : base(name, description, studiedComponent, factors.Select(f => f.Data).ToList(), responses, parentName)
        {
            base.StudiedComponent = studiedComponent;

            // Copy factors to avoid aliasing problems when editing studies
            Factors   = factors.Select(f => f.Copy() as BoundedDesignVariableNoInitial).ToList();
            Responses = responses;


            SetIDColumn();

            foreach (BoundedDesignVariableNoInitial factor in Factors)
            {
                SetColumn(factor.Name, factor.Data);
            }


            foreach (Data response in Responses)
            {
                SetColumn(response.Name, response);
            }

            TableNames.Add(Name);

            Treatment = new FullFactorial("FullFactorial", "", studiedComponent, Factors, responses);
            if (createFolder)
            {
                Treatment.CreateFolder();
            }
        }
예제 #2
0
        public override List <TableInfo> RefreshTableNames()
        {
            var item = CurrentTables.ToList();

            TableNames.SetSource(item);
            return(item);
        }
예제 #3
0
        /// <summary>
        ///     Gets font metric data for a TrueType font or TrueType collection.
        /// </summary>
        /// <returns></returns>
        public byte[] GetFontData()
        {
            if (data == null)
            {
                try {
                    // Check if this is a TrueType font collection
                    uint ttcfTag  = TableNames.ToUint(TableNames.Ttcf);
                    uint ttcfSize = LibWrapper.GetFontData(dc.Handle, ttcfTag, 0, null, 0);

                    if (ttcfSize != 0 && ttcfSize != 0xFFFFFFFF)
                    {
                        data = ReadFontFromCollection();
                    }
                    else
                    {
                        data = ReadFont();
                    }
                }
                catch (Exception e) {
                    throw new Exception(
                              String.Format("Failed to load data for font {0}", FaceName), e);
                }
            }

            return(data);
        }
        public FullFactorialDOEStudy(string name, string description, WorkflowComponent workflow, List <Data> factors, List <decimal> startingValues, List <decimal> stepSizes, List <int> noOfLevels, List <Data> responses)
            : base(name, description, workflow, factors, responses)
        {
            base.StudiedComponent = workflow;

            this.startingValues = startingValues;
            this.stepSizes      = stepSizes;
            this.noOfLevels     = noOfLevels;



            ColumnNames.Add("ID");
            ColumnTypes.Add(DataTypes.INTEGER);
            ColumnFormats.Add(0);
            ColumnUnits.Add("");

            for (int i = 0; i < factors.Count; i++)
            {
                string columnHeader = factors[i].Name;
                ColumnNames.Add(columnHeader);
                if (factors[i] is IntegerData)
                {
                    ColumnTypes.Add(DataTypes.INTEGER);
                    ColumnFormats.Add(0);
                    ColumnUnits.Add(((IntegerData)factors[i]).Unit);
                }
                else if (factors[i] is DoubleData)
                {
                    ColumnTypes.Add(DataTypes.DOUBLE);
                    ColumnFormats.Add(((DoubleData)factors[i]).DecimalPlaces);
                    ColumnUnits.Add(((DoubleData)factors[i]).Unit);
                }
            }
            for (int i = 0; i < responses.Count; i++)
            {
                string columnHeader = responses[i].Name;
                ColumnNames.Add(columnHeader);
                if (responses[i] is IntegerData)
                {
                    ColumnTypes.Add(DataTypes.INTEGER);
                    ColumnFormats.Add(0);
                    ColumnUnits.Add(((IntegerData)responses[i]).Unit);
                }
                else if (responses[i] is DoubleData)
                {
                    ColumnTypes.Add(DataTypes.DOUBLE);
                    ColumnFormats.Add(((DoubleData)responses[i]).DecimalPlaces);
                    ColumnUnits.Add(((DoubleData)responses[i]).Unit);
                }
            }



            TableNames.Add(Name);



            Treatment = new FullFactorial("testFF", "", Project.ProjectPath + "\\DOE.sdf", workflow as Workflow, factors, startingValues, stepSizes, noOfLevels, responses);
            Treatment.CreateFolder();
        }
예제 #5
0
        public virtual TableInfo AddTable(string tableName, string desc = null, bool shouldDescOnly = false)
        {
            if (string.IsNullOrWhiteSpace(tableName))
            {
                return(null);
            }
            TableInfo fir = CurrentTables.FirstOrDefault(d => d.Name == tableName);

            if (fir != null)
            {
                CurrentTables.Remove(fir);

                CurrentTables.Insert(0, fir);
                return(fir);
            }

            var table = new TableInfo(tableName, this)
            {
                Description = desc
            };

            CurrentTables.Insert(1, table);

            TableNames.SetSource(CurrentTables);
            return(table);
        }
예제 #6
0
        public int countTableRows(TableNames table)
        {
            dataTable = this.getAllData(table);
            int RowNumber = dataTable.Rows.Count;

            return(RowNumber);
        }
예제 #7
0
        public DataTable getAllData(TableNames table)
        {
            string selectQuery = $"select * from {table}";

            dataTable = sqlDB.ExecuteQuery(selectQuery);
            return(dataTable);
        }
        public MissionStudy(string name, string description, WorkflowComponent studiedComponent, Mission mission, string parentName = "")
            : base(name, null, null, description, parentName)
        {
            StudiedComponent = studiedComponent;
            Mission          = mission;

            SetIDColumn();

            ModelDataInputs = studiedComponent.ModelDataInputs;
            foreach (Data input in ModelDataInputs)
            {
                SetColumn(input.Name, input);
            }

            ModelDataOutputs = studiedComponent.ModelDataOutputs;
            foreach (Data output in ModelDataOutputs)
            {
                SetColumn(output.Name, output);
            }

            TableNames.Add(Name);


            Treatment = new MissionTreatment(name, description, studiedComponent, mission);
            Treatment.CreateFolder();
        }
예제 #9
0
        public List <PlayerDTO> getPlayerDTOList(TableNames table)
        {
            List <PlayerDTO> playerDTOList = new List <PlayerDTO>();
            DataTable        dataTable     = this.getAllData(table);

            foreach (DataRow dr in dataTable.Rows)
            {
                PlayerDTO playerDTO = new PlayerDTO();
                playerDTO.PlayerName = (string)dr["NAME"];
                int jobInt = (int)dr["JOB"];
                playerDTO.JOB       = (JOBs)Enum.ToObject(typeof(JOBs), jobInt);
                playerDTO.HP        = (int)dr["HP"];
                playerDTO.MP        = (int)dr["MP"];
                playerDTO.STR       = (int)dr["STR"];
                playerDTO.DEF       = (int)dr["DEF"];
                playerDTO.AGI       = (int)dr["AGI"];
                playerDTO.LUCK      = (int)dr["LUCK"];
                playerDTO.CreateDay = (string)dr["CREATE_AT"];

                /*if (dr["CREATE_AT"] != null)
                 * {
                 *  playerDTO.CreateDay =
                 *      DateTime.Parse((string) dr["CREATE_AT"]);
                 * }*/
                playerDTOList.Add(playerDTO);
            }
            return(playerDTOList);
        }
 internal SqlQueryBuilder(string tableName, ISqlAdapter adapter)
 {
     TableNames.Add(tableName);
     Adapter           = adapter;
     Parameters        = new ExpandoObject();
     CurrentParamIndex = 0;
 }
예제 #11
0
        private IEnumerable <FreeDocument> GetEntities2(
            string tableName, int mount = -1, int skip = 0)
        {
            TableInfo table = null;

            LastFileName = tableName;
            List <string> fileNames = new List <string>();

            if (tableName == openfile && MainDescription.IsUIForm)
            {
                var ofd2 = new OpenFileDialog();
                ofd2.DefaultExt  = "*";
                ofd2.Filter      = FileConnector.GetDataFilter();
                ofd2.Multiselect = true;
                if (ofd2.ShowDialog() == true)
                {
                    fileNames.AddRange(ofd2.FileNames);
                }
            }
            else
            {
                table = TableNames.Collection.FirstOrDefault(d => d.Name == tableName);
                if (table != null)
                {
                    if ((File.Exists(table.Description) == false))
                    {
                        CurrentTables.Remove(table);
                        TableNames.InformPropertyChanged("Collection");
                        return(new List <FreeDocument>());
                    }
                    fileNames.Add(table.Description);
                }
            }

            if (fileNames.Count() == 1)
            {
                var filename = fileNames.FirstOrDefault();
                LastFileName = Path.GetFileName(filename);
                table        = AddTable(LastFileName, filename);
            }



            return(fileNames.SelectMany(d =>
            {
                var connector = FileConnector.SmartGetExport(d);
                var tableConnector2 = connector as FileConnectorTable;
                if (tableConnector2 != null)
                {
                    tableConnector2.EncodingType = this.EncodingType;
                }
                if (mount > 0)
                {
                    return connector.ReadFile().Skip(skip).Take(mount);
                }

                return connector.ReadFile().Skip(skip);
            }));
        }
예제 #12
0
        public void addData(PlayerDTO playerDTO, TableNames table)
        {
            string query =
                $"insert into {table.ToString()} values(\'{playerDTO.PlayerName}\',{(int)playerDTO.JOB},{playerDTO.HP},{playerDTO.MP},{playerDTO.STR}," +
                $"{playerDTO.DEF},{playerDTO.AGI},{playerDTO.LUCK},\'{playerDTO.CreateDay}\')";

            sqlDB.ExecuteNonQuery(query);
        }
예제 #13
0
        public void deletePlayer(int playerId, TableNames table)
        {
            string query =
                $"delete from {table.ToString()} where NAME = (select NAME from " +
                $"{table.ToString()} limit 1 offset {playerId.ToString()})";

            sqlDB.ExecuteNonQuery(query);
        }
예제 #14
0
        public void Join(string originalTableName, string joinTableName, string leftField, string rightField)
        {
            var joinString =
                $"JOIN {Adapter.Table(joinTableName)} ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
            SplitColumns.Add(rightField);
        }
예제 #15
0
        public override List <TableInfo> RefreshTableNames()
        {
            var table = GetDataTable("select name from sysobjects where xtype='u'");
            var names =
                (from DataRow dr1 in table.Rows select new TableInfo(dr1.ItemArray[0].ToString(), this)).ToList();

            TableNames.SetSource(names);
            return(names);
        }
예제 #16
0
        public virtual List <TableInfo> RefreshTableNames()
        {
            DataTable        items = GetDataTable("show tables");
            List <TableInfo> res   =
                (from DataRow dr in items.Rows select new TableInfo(dr.ItemArray[0].ToString(), this)).ToList();

            TableNames.SetSource(res);
            return(res);
        }
        public void Join(string joinTableName, string commandText, JoinType joinType)
        {
            var join       = GetJoinExpression(joinType);
            var joinString =
                $"{join} {Adapter.Table(joinTableName)} " +
                $"ON {commandText}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
        }
        public void Join(string originalTableName, string joinTableName, string leftField, string rightField, JoinType joinType)
        {
            var join       = GetJoinExpression(joinType);
            var joinString =
                $"{join} {Adapter.Table(joinTableName)} " +
                $"ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
            SplitColumns.Add(rightField);
        }
예제 #19
0
        internal SqlQueryBuilder(string tableName, ISqlAdapter adapter, int paramCountIndex = 0)
        {
            if (adapter == null)
            {
                throw new InvalidOperationException("Set Adapter first, eg: SqlBuilder.SetAdapter(new SqlServerAdapter())");
            }

            TableNames.Add(tableName);
            Adapter           = adapter;
            Parameters        = new ExpandoObject();
            CurrentParamIndex = paramCountIndex;
        }
예제 #20
0
        public override List <TableInfo> RefreshTableNames()
        {
            var items            = GetDataTable("select name from sqlite_master where type='table' order by name");
            List <TableInfo> res = new List <TableInfo>();

            foreach (DataRow dr in items.Rows)
            {
                res.Add(new TableInfo(dr.ItemArray[0].ToString(), this));
            }
            TableNames.SetSource(res);
            return(res);
        }
예제 #21
0
        private List <string> GetCheckedTableNames()
        {
            List <string> tableNames = new List <string>();

            for (int i = 0; i < TableNames.Items.Count; i++)
            {
                if (TableNames.GetItemChecked(i))
                {
                    tableNames.Add(TableNames.Items[i].ToString());
                }
            }
            return(tableNames);
        }
        //Gets the table name for this type
        //For Get(id) and Delete(id) we don't have an entity, just the type so this method is used
        //Use dynamic type to be able to handle both our Table-attribute and the DataAnnotation
        //Uses class name by default and overrides if the class has a Table attribute
        private static string GetTableName(Type type)
        {
            string tableName;

            if (TableNames.TryGetValue(type, out tableName))
            {
                return(tableName);
            }

            tableName = _tableNameResolver.ResolveTableName(type);
            TableNames.AddOrUpdate(type, tableName, (t, v) => tableName);
            return(tableName);
        }
예제 #23
0
        /// <summary>
        ///     Call RefreshPossibleTableId() first!
        /// </summary>
        /// <returns></returns>
        internal string GetNextPossibleTableName()
        {
            var i     = PossibleTableId;
            var sName = string.Format("Table{0}", i);

            // possible infinite loop, but how many tables do you have anyway?
            while (TableNames.Contains(sName))
            {
                ++i;
                sName = string.Format("Table{0}", i);
            }
            return(sName);
        }
예제 #24
0
        /// <summary>
        /// Get the PTable Name for an Entity Type.
        /// </summary>
        /// <param name="type">Entity Type.</param>
        /// <returns>Table Name.</returns>
        protected string GetTableName(Type type)
        {
            var cacheHit = TableNames.TryGetValue(type, out string tableName);

            if (!cacheHit)
            {
                tableName = Context.Model.FindEntityType(type).GetTableName();

                TableNames.TryAdd(type, tableName);
            }

            return(tableName);
        }
예제 #25
0
        /// <summary>
        /// 映射数据同步领域上下文范围
        /// </summary>
        /// <typeparam name="LocalEntity">本地实体</typeparam>
        /// <typeparam name="TService">服务器端数据同步服务对象</typeparam>
        static void Mapping <LocalEntity>()
            where LocalEntity : Pharos.Logic.LocalEntity.BaseEntity, new()
        {
            var type = typeof(LocalEntity);
            var key  = type.ToString();

            var titleAttr = Attribute.GetCustomAttribute(type, typeof(ExcelAttribute)) as ExcelAttribute;

            if (titleAttr != null)
            {
                TableNames.Add(key, titleAttr.Title);
            }
            Entities.Add(key, new LocalEntity());
        }
예제 #26
0
        private List <string> ExtractCommonData(string srcDBName, string destDBName, List <TableDefinition> definitions)
        {
            List <string> sqlCommandList = new List <string>();

            TableNames.Where(tableName => !IsTableMatched(tableName, definitions)).ToList().ForEach(tableName =>
            {
                // copy table now.
                string sqlCommandText = $"CREATE TABLE IF NOT EXISTS `{destDBName}`.`{tableName}` LIKE `{srcDBName}`.`{tableName}`; INSERT INTO `{destDBName}`.`{tableName}` SELECT {tableName}.* FROM `{srcDBName}`.`{tableName}`";

                sqlCommandList.Add(sqlCommandText);
            });

            return(sqlCommandList);
        }
예제 #27
0
        //Gets the table name for this type
        //For Get(id) and Delete(id) we don't have an entity, just the type so this method is used
        //Use dynamic type to be able to handle both our Table-attribute and the DataAnnotation
        //Uses class name by default and overrides if the class has a Table attribute
        private string GetTableName(Type type)
        {
            string tableName;

            if (TableNames.TryGetValue(type, out tableName))
            {
                return(tableName);
            }

            tableName        = _tableNameResolver.ResolveTableName(type);
            TableNames[type] = tableName;

            return(tableName);
        }
예제 #28
0
        private List <string> ExtractUnitData(string srcDBName, string destDBName, List <TableDefinition> definitions, Dictionary <string, object> unitDataDictionary)
        {
            List <string> sqlCommandList = new List <string>();

            TableNames.Where(tableName => IsTableMatched(tableName, definitions)).ToList().ForEach(tableName =>
            {
                var filteredDefinitions = GetMatchedTableDefinitions(tableName, definitions);

                filteredDefinitions.ForEach(definition =>
                {
                    if (definition.Type == DefinitionType.Skip)
                    {
                        return;  // Skip: continue to next definition.
                    }

                    // Default: Copy whole table.
                    string sqlCommandText = $"CREATE TABLE IF NOT EXISTS `{destDBName}`.`{tableName}` LIKE `{srcDBName}`.`{tableName}`; " +
                                            $"INSERT INTO `{destDBName}`.`{tableName}` " +
                                            $"SELECT {tableName}.* FROM `{srcDBName}`.`{tableName}` ";

                    // Extract: Append Join & Where
                    if (definition.Type == DefinitionType.Extract)
                    {
                        string value            = unitDataDictionary[definition.Value].ToString();
                        string extraWhereClause = string.IsNullOrWhiteSpace(definition.ExtraWhereClause) ? "" : $"AND {definition.ExtraWhereClause}";

                        if (string.IsNullOrWhiteSpace(definition.DataClassTable))
                        {
                            sqlCommandText += $"JOIN `{srcDBName}`.`{definition.ForeignTable}` ON {tableName}.{definition.ForeignKey} =  {definition.ForeignTablePrimaryKey} " +
                                              $"WHERE {definition.Filter} {definition.Operator} '{value}' {extraWhereClause}";
                        }
                        else
                        {
                            // If DataClassTable exists:
                            // SELECT * FROM Table
                            // JOIN DataClassTable ON Table.dataId = DataClassTable.id
                            // JOIN ForeignTable ON DataClassTable.Column = ForeignTable.FK
                            sqlCommandText += $"JOIN `{srcDBName}`.`{definition.DataClassTable}` ON {tableName}.dataId = {definition.DataClassTable}.id " +
                                              $"JOIN `{srcDBName}`.`{definition.ForeignTable}` ON {definition.DataClassTable}.{definition.ForeignKey} = {definition.ForeignTablePrimaryKey} " +
                                              $"WHERE {definition.Filter} {definition.Operator} '{value}' {extraWhereClause}";
                        }
                    }

                    sqlCommandList.Add(sqlCommandText);
                });
            });

            return(sqlCommandList);
        }
예제 #29
0
        public string GetTableAlias(Type type)
        {
            if (!UseTableAlias)
            {
                return(string.Empty);
            }
            if (TableNames.ContainsKey(type))
            {
                return(TableNames[type]);
            }
            var name = string.Format("t{0}", TableNames.Count);

            this.TableNames.Add(type, name);
            return(name);
        }
예제 #30
0
        private byte[] ReadTableData(string tableName)
        {
            uint tag  = TableNames.ToUint(tableName);
            uint size = LibWrapper.GetFontData(dc.Handle, tag, 0, null, 0);

            byte[] data = new byte[size];
            uint   rv   = LibWrapper.GetFontData(dc.Handle, tag, 0, data, (uint)data.Length);

            if (rv == GdiFontMetrics.GDI_ERROR)
            {
                throw new Exception("Failed to retrieve table " + tableName);
            }

            return(data);
        }
예제 #31
0
        public static Table GetTable(TableNames tName)
        {
            Table table = new Table();
            switch (tName)
            {
                case TableNames.Brand:
                    {
                        table.Discription = "Table contain information about Brands";
                        table.InsertString = String.Format(_baseInsertString, "brand",
                            "brandid,brandname,brandfoundationyear,brandsite,brandcountry",
                            "@brandid, @brandname, @brandfoundationyear, @brandsite, @brandcountry");

                        break;
                    }

                case TableNames.Model:
                    break;

            }
            return table;
        }
 public CodeFrm(TableNames CodeName)
 {
     InitializeComponent();
     ViewName = CodeName;
     switch (CodeName)
     {
         case TableNames.CDEdara:
             gridControlCode.MainView = gridViewCDEdara;
             LoadData(TableNames.CDEdara);
             Text += " الادارات";
             break;
         case TableNames.CDserviceType:
             gridControlCode.MainView = gridViewCDserviceType;
             LoadData(TableNames.CDserviceType);
             Text += " انواع الخدمات";
             break;
         case TableNames.CDReply:
             gridControlCode.MainView = gridViewCDReply;
             LoadData(TableNames.CDReply);
             Text += " الرد";
             break;
         case TableNames.CDSyndicate:
             gridControlCode.MainView = gridViewCDSyndicate;
             LoadData(TableNames.CDSyndicate);
             Text += " النقابات الفرعية";
             break;
         case TableNames.CDSubCommitte:
             gridControlCode.MainView = gridViewCDSubCommitte;
             LoadData(TableNames.CDSubCommitte);
             Text += " اللجان النقابية";
             break;
         case TableNames.CDAttatech:
             gridControlCode.MainView = gridViewCDAttatech;
             LoadData(TableNames.CDAttatech);
             Text += " المرفقات";
             break;
         default:
             break;
     }
 }
예제 #33
0
 private void LoadData(TableNames CodeName)
 {
     DataTable dt = new DataTable();
     switch (CodeName)
     {
         case TableNames.CD_AsaseSalary:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT AsaseSalaryId, AsaseSalary, school_allcode, AsaseDate, FromDate1, ToDate2, Alawa1, DateAlawa1, DateAlawa2, Alawa2,
             DateAlawa3, Alawa3, DateAlawa4, Alawa4, Alawa5, DateAlawa5, MokafaDayes, MinAsaseMokafa, MinMokafa FROM CD_AsaseSalary");
             repositoryItemGridLookUpEditSPOS.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT school_allcode, school_allname, school_allname_e FROM TBLSCHOOLALL");
             break;
         case TableNames.CD_SarfGeha:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SarfGehaId, SarfGeha FROM CD_SarfGeha");
             break;
         case TableNames.CDMonth:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT month_code, month_name, month_name_e FROM CDMonth");
             break;
         case TableNames.CD_Esthkak:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EsthkakId, Esthkak, EsthkakTypeId, EsthkakNesba, EsthkakMony FROM CD_Esthkak");
             repositoryItemGridLookUpEditEsthkakTypeId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EsthkakTypeId, EsthkakType FROM CD_EsthkakType");
             break;
         case TableNames.CD_Estktaa:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EstktaaId, Estktaa, EstktaaTypeId, EstktaaNesba, EstktaaMony FROM CD_Estktaa");
             repositoryItemGridLookUpEditEsthkakTypeId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EsthkakTypeId, EsthkakType FROM CD_EsthkakType");
             break;
         case TableNames.CD_HesaTime:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT marhala_code, daycode, hasa_code, Convert(Datetime, tiem_be, 114) AS tiem_be, Convert(Datetime, tiem_en, 114) AS tiem_en,
             marhala_code as org_marhala_code, daycode as org_daycode, hasa_code as org_hasa_code
             FROM gdw.CD_HesaTime");
             repositoryItemGridLookUpEditmarhala_code.DataSource = FXFW.SqlDB.LoadDataTable("Select marhala_code, marhala_name, marhala_name_e From CDMarahel");
             repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
             repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
             break;
         case TableNames.CDSubjectWekly:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT alsofof_code, SubjectId, hesasno, twoh, alsofof_code AS org_alsofof_code, SubjectId AS org_SubjectId FROM CDSubjectWekly");
             repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject");
             repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable("Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
             break;
         case TableNames.CDPlace:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
             break;
         case TableNames.TBLNesab:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, EmpID, nesabfealy, nesabedafy, rem,
             asase_code AS org_asase_code, EmpID AS org_EmpID FROM gdw.TBLNesab WHERE asase_code = " + FXFW.SqlDB.asase_code);
             repositoryItemGridLookUpEditEmpID.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
             ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '')  AS emp_name
             FROM TBL_Emp");
             break;
         case TableNames.TBLTeacherNoDays:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID, daycode, hasa_code,
             EmpID AS org_EmpID, daycode AS org_daycode, hasa_code AS org_hasa_code FROM TBLTeacherNoDays");
             repositoryItemGridLookUpEditEmpID.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
             ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '')  AS emp_name
             FROM TBL_Emp");
             repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
             repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
             break;
         case TableNames.TBLTeachersPlan:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, EmpID, alsofof_code, fasl_code, SubjectId FROM gdw.TBLTeachersPlan Where asase_code = " + FXFW.SqlDB.asase_code);
             repositoryItemGridLookUpEditEmpID.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID,
             ISNULL(EMP_FIRST_NAME, '') + ' ' + ISNULL(EMP_FATHER_NAME, '') + ' ' + ISNULL(EMP_FAM_NAME, '') + ' ' + ISNULL(EMP_FOURTH_NAME, '')  AS emp_name
             FROM TBL_Emp");
             repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable("Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
             repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable("Select fasl_code, fasl_name, fasl_name_e FROM CDAlsofof");
             break;
         case TableNames.CDPlaceTraining:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT PlaceTrainingId, PlaceTrainingName, PlaceTrainingName_e, PlaceTrainingTell, PlaceTrainingemail FROM CDPlaceTraining");
             break;
         case TableNames.CD_AgazaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e, allow FROM CD_AgazaType");
             break;
         case TableNames.CDTakdeer:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             break;
         case TableNames.CD_EznType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EznTypeId, EznType, EznType_e FROM CD_EznType");
             break;
         case TableNames.CD_GzaaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GzaaTypeId, GzaaType, GzaaType_e FROM CD_GzaaType");
             break;
         case TableNames.CD_GehaGazaa:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GehaGazaaId, GehaGazaa, GehaGazaa_e FROM CD_GehaGazaa");
             break;
         default:
             break;
     }
     gridControlCode.DataSource = dt;
     //gridViewCDMarahel.BestFitColumns()
     ((DevExpress.XtraGrid.Views.Grid.GridView)gridControlCode.MainView).BestFitColumns();
 }
예제 #34
0
 public CodeFrm(TableNames CodeName)
 {
     InitializeComponent();
     ViewName = CodeName;
     switch (CodeName)
     {
         case TableNames.CD_Asasetime:
             gridControlCode.MainView = gridViewCD_Asasetime;
             LoadData(TableNames.CD_Asasetime);
             Text += " تحديد العام الدراسي";
             break;
         case TableNames.CDAlhasas:
             gridControlCode.MainView = gridViewCDAlhasas;
              LoadData(TableNames.CDAlhasas);
              Text += "  الحصص";
             break;
         case TableNames.CDAlsofof:
             gridControlCode.MainView = gridViewCDAlsofof;
             LoadData(TableNames.CDAlsofof);
             Text += "  الصفوف";
             break;
         case TableNames.CDEFasl:
             gridControlCode.MainView = gridViewCDEFasl;
             LoadData(TableNames.CDEFasl);
             Text += "  الفصول";
             break;
         case TableNames.CDDayname:
             gridControlCode.MainView = gridViewCDDayname;
             LoadData(TableNames.CDDayname);
             Text += "  الايام";
             break;
         case TableNames.CD_HesaTime:
             gridControlCode.MainView = gridViewCD_HesaTime;
             LoadData(TableNames.CD_HesaTime);
             Text += "  مواعيد الحصص";
             break;
         case TableNames.CDSubjectWekly:
             gridControlCode.MainView = gridViewCDSubjectWekly;
             LoadData(TableNames.CDSubjectWekly);
             Text += " خطة المواد الاسبوعية";
             break;
         case TableNames.CDPlace:
             gridControlCode.MainView = gridViewCDPlace;
             LoadData(TableNames.CDPlace);
             Text += " الاماكن";
             break;
         case TableNames.CD_EmpState:
             gridControlCode.MainView = gridViewCD_EmpState;
             LoadData(TableNames.CD_EmpState);
             Text += " الحالة الوظيفية";
             break;
         case TableNames.CD_JobDescription:
             gridControlCode.MainView = gridViewCD_JobDescription;
             LoadData(TableNames.CD_JobDescription);
             Text += " الوصف الوظيفي";
             break;
         case TableNames.CD_EmpJob:
             gridControlCode.MainView = gridViewCD_EmpJob;
             LoadData(TableNames.CD_EmpJob);
             Text += " وظائف العاملين";
             break;
         case TableNames.CD_Department:
             gridControlCode.MainView = gridViewCD_Department;
             LoadData(TableNames.CD_Department);
             Text += " الاقسام";
             break;
         case TableNames.CD_Subject:
             gridControlCode.MainView = gridViewCD_Subject;
             LoadData(TableNames.CD_Subject);
             Text += " المواد";
             break;
         case TableNames.CD_QualifiedPlace:
             gridControlCode.MainView = gridViewCD_QualifiedPlace;
             LoadData(TableNames.CD_QualifiedPlace);
             Text += " جهة الؤهل";
             break;
         case TableNames.CDQualification:
             gridControlCode.MainView = gridViewCDQualification;
             LoadData(TableNames.CDQualification);
             Text += " المؤهلات";
             break;
         case TableNames.CD_Specialization:
             gridControlCode.MainView = gridViewCD_Specialization;
             LoadData(TableNames.CD_Specialization);
             Text += " تخصص المؤهل";
             break;
         case TableNames.CD_MaritalStatus:
             gridControlCode.MainView = gridViewCD_MaritalStatus;
             LoadData(TableNames.CD_MaritalStatus);
             Text += " الحالة الاجتماعية";
             break;
         case TableNames.TBL_Priority:
             gridControlCode.MainView = gridViewTBL_Priority;
             LoadData(TableNames.TBL_Priority);
             Text += " أولويات المواد";
             break;
         case TableNames.CD_AgazaType:
             gridControlCode.MainView = gridViewCD_AgazaType;
             LoadData(TableNames.CD_AgazaType);
             Text += " الاجازات";
             break;
         default:
             break;
     }
 }
예제 #35
0
 public CodeFrm(TableNames CodeName)
 {
     InitializeComponent();
     ViewName = CodeName;
     switch (CodeName)
     {
         case TableNames.CD_AsaseACC:
             gridControlCode.MainView = gridViewCD_AsaseACC;
             LoadData(TableNames.CD_AsaseACC);
             Text += " تحديد العام الدراسي";
             break;
         case TableNames.CD_PayType:
             gridControlCode.MainView = gridViewCD_PayType;
              LoadData(TableNames.CD_PayType);
              Text += " انواع التحصيل";
             break;
         case TableNames.CD_PayTypeDetiel:
             gridControlCode.MainView = gridViewCD_PayTypeDetiel;
             LoadData(TableNames.CD_PayTypeDetiel);
             Text += " بنود التحصيل";
             break;
         case TableNames.CD_PayMony:
             gridControlCode.MainView = gridViewCD_PayMony;
             LoadData(TableNames.CD_PayMony);
             Text += " مبالغ الانشطه";
             break;
         case TableNames.CD_Discounts:
             gridControlCode.MainView = gridViewCD_Discounts;
             LoadData(TableNames.CD_Discounts);
             Text += " اكواد الخصومات";
             break;
         case TableNames.CD_KastNo:
             gridControlCode.MainView = gridViewCD_KastNo;
             LoadData(TableNames.CD_KastNo);
             Text += " اكواد الاقساط";
             break;
         case TableNames.CD_KastSaf:
             gridControlCode.MainView = gridViewCD_KastSaf;
             LoadData(TableNames.CD_KastSaf);
             Text += " مبالغ القسط للصفوف";
             break;
         case TableNames.CD_KastBnood:
             gridControlCode.MainView = gridViewCD_KastBnood;
             LoadData(TableNames.CD_KastBnood);
             Text += " بنود القسط";
             break;
         case TableNames.CD_Specialization:
             gridControlCode.MainView = gridViewCD_Specialization;
             LoadData(TableNames.CD_Specialization);
             Text += " تخصص المؤهل";
             break;
         case TableNames.CD_MaritalStatus:
             gridControlCode.MainView = gridViewCD_MaritalStatus;
             LoadData(TableNames.CD_MaritalStatus);
             Text += " الحالة الاجتماعية";
             break;
         case TableNames.CD_Courses:
             gridControlCode.MainView = gridViewCD_Courses;
             LoadData(TableNames.CD_Courses);
             Text += " الدورات التدريبية";
             break;
         case TableNames.CDPlaceTraining:
             gridControlCode.MainView = gridViewCDPlaceTraining;
             LoadData(TableNames.CDPlaceTraining);
             Text += " الحالة الاجتماعية";
             break;
         case TableNames.CD_AgazaType:
             gridControlCode.MainView = gridViewCD_AgazaType;
             LoadData(TableNames.CD_AgazaType);
             Text += " انواع الغياب";
             break;
         case TableNames.CDTakdeer:
             gridControlCode.MainView = gridViewCDTakdeer;
             LoadData(TableNames.CDTakdeer);
             Text += " التقديرات";
             break;
         case TableNames.CD_EznType:
             gridControlCode.MainView = gridViewCD_EznType;
             LoadData(TableNames.CD_EznType);
             Text += " الاذن";
             break;
         case TableNames.CD_GzaaType:
             gridControlCode.MainView = gridViewCD_GzaaType;
             LoadData(TableNames.CD_GzaaType);
             Text += " الجزاءات";
             break;
         case TableNames.CD_GehaGazaa:
             gridControlCode.MainView = gridViewCD_GehaGazaa;
             LoadData(TableNames.CD_GehaGazaa);
             Text += " جهة الجزاء";
             break;
         default:
             break;
     }
 }
예제 #36
0
 private void LoadData(TableNames CodeName)
 {
     DataTable dt = new DataTable();
     switch (CodeName)
     {
         case TableNames.CD_AsaseACC:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, asase_year, school_allcode, SPOS,
             (Select school_allname From TBLSCHOOLALL Where school_allcode = CD_AsaseACC.school_allcode) AS school_allname FROM CD_AsaseACC");
             repositoryItemGridLookUpEditSPOS.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SPOS, SCHOOL, SCHOOl_e, school_allcode FROM TBLSCHOOL");
             break;
         case TableNames.CD_PayType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT PayTypeId, PayType, Additional FROM CD_PayType");
             break;
         case TableNames.CD_PayTypeDetiel:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT PayTypeDetielId, PayTypeDetiel, PayTypeId FROM CD_PayTypeDetiel");
             repositoryItemGridLookUpEditPayTypeId.DataSource = FXFW.SqlDB.LoadDataTable("SELECT PayTypeId, PayType, Additional FROM CD_PayType");
             break;
         case TableNames.CD_PayMony:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, PayTypeDetielId, alsofof_code, PayMony, (Select asase_year From CD_AsaseACC Where asase_code = CD_PayMony.asase_code) AS asase_year,
             asase_code AS asase_code_SRC, PayTypeDetielId AS PayTypeDetielId_SRC, alsofof_code AS alsofof_code_SRC FROM CD_PayMony WHERE asase_code = " + FXFW.SqlDB.asase_code);
             repositoryItemGridLookUpEditPayTypeDetielId.DataSource = FXFW.SqlDB.LoadDataTable("Select PayTypeDetielId, PayTypeDetiel FROM CD_PayTypeDetiel");
             repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable("Select alsofof_code, alsofof_name FROM CDAlsofof");
             break;
         case TableNames.CD_Discounts:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT DiscountsId, Discounts, PayTypeDetielId, Percentage FROM CD_Discounts");
             repositoryItemGridLookUpEditPayTypeDetielId.DataSource = FXFW.SqlDB.LoadDataTable("Select PayTypeDetielId, PayTypeDetiel FROM CD_PayTypeDetiel");
             break;
         case TableNames.CD_KastNo:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT KastNoId, KastName FROM CD_KastNo");
             break;
         case TableNames.CD_KastSaf:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT KastNoId, alsofof_code, KastSafMony, KastNoId AS KastNoId_SRC, alsofof_code AS alsofof_code_SRC FROM CD_KastSaf");
             repositoryItemGridLookUpEditKastNoId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT KastNoId, KastName FROM CD_KastNo");
             repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable("Select alsofof_code, alsofof_name FROM CDAlsofof");
             break;
         case TableNames.CD_KastBnood:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT KastNoId, PayTypeDetielId, Awlawea, KastNoId AS KastNoId_SRC, PayTypeDetielId AS PayTypeDetielId_SRC FROM CD_KastBnood");
             repositoryItemGridLookUpEditKastNoId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT KastNoId, KastName FROM CD_KastNo");
             repositoryItemGridLookUpEditPayTypeDetielId.DataSource = FXFW.SqlDB.LoadDataTable("Select PayTypeDetielId, PayTypeDetiel FROM CD_PayTypeDetiel");
             break;
         case TableNames.CD_Specialization:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SpecializationId, qualId, SpecializationName, SpecializationName_e FROM CD_Specialization");
             repositoryItemGridLookUpEditqualId.DataSource = FXFW.SqlDB.LoadDataTable("Select qualId, qualName, qualName_e From CDQualification");
             break;
         case TableNames.CD_MaritalStatus:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT MaritalStatusId, MaritalStatus, MaritalStatus_e FROM CD_MaritalStatus");
             break;
         case TableNames.CD_Courses:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT CourseId, CourseName, CourseName_e FROM CD_Courses");
             break;
         case TableNames.CDPlaceTraining:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT PlaceTrainingId, PlaceTrainingName, PlaceTrainingName_e, PlaceTrainingTell, PlaceTrainingemail FROM CDPlaceTraining");
             break;
         case TableNames.CD_AgazaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e, allow FROM CD_AgazaType");
             break;
         case TableNames.CDTakdeer:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             break;
         case TableNames.CD_EznType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EznTypeId, EznType, EznType_e FROM CD_EznType");
             break;
         case TableNames.CD_GzaaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GzaaTypeId, GzaaType, GzaaType_e FROM CD_GzaaType");
             break;
         case TableNames.CD_GehaGazaa:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GehaGazaaId, GehaGazaa, GehaGazaa_e FROM CD_GehaGazaa");
             break;
         default:
             break;
     }
     gridControlCode.DataSource = dt;
     //gridViewCDMarahel.BestFitColumns()
     ((DevExpress.XtraGrid.Views.Grid.GridView)gridControlCode.MainView).BestFitColumns();
 }
예제 #37
0
 private void LoadData(TableNames CodeName)
 {
     DataTable dt = new DataTable();
     switch (CodeName)
     {
         case TableNames.CDGov:
             dt = SQLProvider.SelectCDGov();
             break;
         case TableNames.CDMarkez:
             dt = SQLProvider.SelectCDMarkez();
             repositoryItemGridLookUpEditGovId.DataSource = SQLProvider.SelectCDGov(); 
             break;
         case TableNames.CDSyndicate:
             dt = SQLProvider.SelectCDSyndicate();
             break;
         case TableNames.CDSubCommitte:
             dt = SQLProvider.SelectCDSubCommitte();
             repositoryItemGridLookUpEditSyndicateId.DataSource = SQLProvider.SelectCDSyndicate(); 
             break;
         case TableNames.CDBirthPlace:
             dt = SQLProvider.SelectCDBirthPlace();
             break;
         case TableNames.CDJop:
             dt = SQLProvider.SelectCDJop();
             break;
         case TableNames.CDJobDescription:
             dt = SQLProvider.SelectCDJobDescription();
             repositoryItemGridLookUpEditjopId.DataSource = SQLProvider.SelectCDJop(); 
             break;
         case TableNames.CDGehaType:
             dt = SQLProvider.SelectCDGehaType();
             break;
         case TableNames.CDModerea:
             dt = SQLProvider.SelectCDModerea();
             repositoryItemGridLookUpEditGovId.DataSource = SQLProvider.SelectCDGov(); 
             break;
         case TableNames.CDEDARET:
             dt = SQLProvider.SelectCDEDARET();
             repositoryItemGridLookUpEditModereaId.DataSource = SQLProvider.SelectCDModerea();
             break;
         case TableNames.CDGeha:
             dt = SQLProvider.SelectCDGeha();
             repositoryItemGridLookUpEditGehaTypeID.DataSource = SQLProvider.SelectCDGehaType();
             repositoryItemGridLookUpEditGovId.DataSource = SQLProvider.SelectCDGov();
             repositoryItemGridLookUpEditModereaId.DataSource = SQLProvider.SelectCDModerea();
             repositoryItemGridLookUpEditEdaraId.DataSource = SQLProvider.SelectCDEDARET();
             break;
         case TableNames.CDQualification:
             dt = SQLProvider.SelectCDQualification();
             break;
         case TableNames.CDSpecialization:
             dt = SQLProvider.SelectCDSpecialization();
             repositoryItemGridLookUpEditqualId.DataSource = SQLProvider.SelectCDQualification();
             break;
         case TableNames.CDEstefaaKed:
             dt = SQLProvider.SelectCDEstefaaKed();
             break;
         case TableNames.CDJobtitle:
             dt = SQLProvider.SelectCDJobtitle();
             break;
         case TableNames.CDAttachmentType:
             dt = SQLProvider.SelectCDAttachmentType();
             break;
         case TableNames.CDsarfType:
             dt = SQLProvider.SelectCDsarfType();
             repositoryItemGridLookUpEditMashHalaId.DataSource = SQLProvider.SelectCDMashHala();
             break;
         case TableNames.TBLDofatSarf:
             dt = SQLProvider.SelectTBLDofatSarf();
             break;
         default:
             break;
     }
     gridControlCode.DataSource = dt;
     //gridViewCDMarahel.BestFitColumns()
     ((DevExpress.XtraGrid.Views.Grid.GridView)gridControlCode.MainView).BestFitColumns();
     
 }
 private void LoadData(TableNames CodeName)
 {
     DataTable dt = new DataTable();
     switch (CodeName)
     {
         case TableNames.CDEdara:
             dt = SQLProvider.SelectCDEdara();
             break;
         case TableNames.CDserviceType:
             dt = SQLProvider.SelectCDserviceType();
             break;
         case TableNames.CDReply:
             dt = SQLProvider.SelectCDReply();
             break;
         case TableNames.CDSyndicate:
             dt = SQLProvider.SelectCDSyndicate();
             break;
         case TableNames.CDSubCommitte:
             dt = SQLProvider.SelectCDSubCommitte();
             repositoryItemGridLookUpEditSyndicateId.DataSource = SQLProvider.SelectCDSyndicate();
             break;
         case TableNames.CDAttatech:
             dt = SQLProvider.SelectCDAttatech();
             repositoryItemGridLookUpEditserviceTypeId.DataSource = SQLProvider.SelectCDserviceType();
             break;
         default:
             break;
     }
     gridControlCode.DataSource = dt;
     //gridViewCDMarahel.BestFitColumns()
     ((DevExpress.XtraGrid.Views.Grid.GridView)gridControlCode.MainView).BestFitColumns();
 }
예제 #39
0
 public CodeFrm(TableNames CodeName)
 {
     InitializeComponent();
     ViewName = CodeName;
     switch (CodeName)
     {
         case TableNames.CDGov:
             gridControlCode.MainView = gridViewCDGov;
             LoadData(TableNames.CDGov);
             Text += " المحافظات";
             break;
         case TableNames.CDMarkez:
             gridControlCode.MainView = gridViewCDMarkez;
              LoadData(TableNames.CDMarkez);
              Text += " المراكز";
             break;
         case TableNames.CDSyndicate:
             gridControlCode.MainView = gridViewCDSyndicate;
             LoadData(TableNames.CDSyndicate);
             Text += " النقابات الفرعية";
             break;
         case TableNames.CDSubCommitte:
             gridControlCode.MainView = gridViewCDSubCommitte;
             LoadData(TableNames.CDSubCommitte);
             Text += " اللجان النقابية";
             break;
         case TableNames.CDBirthPlace:
             gridControlCode.MainView = gridViewCDBirthPlace;
             LoadData(TableNames.CDBirthPlace);
             Text += " محل الميلاد";
             break;
         case TableNames.CDJop:
             gridControlCode.MainView = gridViewCDJop;
             LoadData(TableNames.CDJop);
             Text += " الوظائف";
             break;
         case TableNames.CDJobDescription:
             gridControlCode.MainView = gridViewCDJobDescription;
             LoadData(TableNames.CDJobDescription);
             Text += " الوصف الوظيفي";
             break;
         case TableNames.CDGehaType:
             gridControlCode.MainView = gridViewCDGehaType;
             LoadData(TableNames.CDGehaType);
             Text += " جهات العمل";
             break;
         case TableNames.CDModerea:
             gridControlCode.MainView = gridViewCDModerea;
             LoadData(TableNames.CDModerea);
             Text += " المديريات";
             break;
         case TableNames.CDEDARET:
             gridControlCode.MainView = gridViewCDEDARET;
             LoadData(TableNames.CDEDARET);
             Text += " الادارات";
             break;
         case TableNames.CDGeha:
             gridControlCode.MainView = gridViewCDGeha;
             LoadData(TableNames.CDGeha);
             Text += " جهات العمل";
             break;
         case TableNames.CDQualification:
             gridControlCode.MainView = gridViewCDQualification;
             LoadData(TableNames.CDQualification);
             Text += " المؤهلات";
             break;
         case TableNames.CDSpecialization:
             gridControlCode.MainView = gridViewCDSpecialization;
             LoadData(TableNames.CDSpecialization);
             Text += " تخصص المؤهل";
             break;
         case TableNames.CDEstefaaKed:
             gridControlCode.MainView = gridViewCDEstefaaKed;
             LoadData(TableNames.CDEstefaaKed);
             Text += " استيفاء العضوية";
             break;
         case TableNames.CDJobtitle:
             gridControlCode.MainView = gridViewCDJobtitle;
             gridControlCode.Enabled = false;
             LoadData(TableNames.CDJobtitle);
             Text += " وظائف الاعضاء";
             break;
         case TableNames.CDAttachmentType:
             gridControlCode.MainView = gridViewCDAttachmentType;
             LoadData(TableNames.CDAttachmentType);
             Text += " انواع المرفقات";
             break;
         case TableNames.CDsarfType:
             gridControlCode.MainView = gridViewCDsarfType;
             LoadData(TableNames.CDsarfType);
             Text += " فئات الصرف";
             break;
         case TableNames.TBLDofatSarf:
             gridControlCode.MainView = gridViewTBLDofatSarf;
             LoadData(TableNames.TBLDofatSarf);
             Text += " دفعات الصرف";
             break;
         default:
             break;
     }
     
 }
 private void LoadData(TableNames CodeName)
 {
     DataTable dt = new DataTable();
     switch (CodeName)
     {
         case TableNames.CD_AsaseEmp:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, asase_year, school_allcode, SPOS, Convert(Datetime, HodorTime, 114) AS HodorTime, Convert(Datetime, EnsrafTime, 114) AS EnsrafTime, MonthEznNo,
             (Select Syndicate From CDSyndicate Where SyndicateId = CD_AsaseEmp.SPOS) AS school_allname FROM CD_AsaseEmp");
             repositoryItemGridLookUpEditSPOS.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubCommitteId, SubCommitte FROM CDSubCommitte");
             repositoryItemGridLookUpEditschool_allname.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SyndicateId, Syndicate FROM CDSyndicate");
             break;
         case TableNames.CD_EmpState:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EmpStateID, EmpStateName, EmpStateName_e, OnWork FROM CD_EmpState");
             break;
         case TableNames.CD_JobDescription:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT JobId, JobNAME, JobNAME_e FROM CD_EmpJop");
             break;
         case TableNames.CD_EmpJob:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT JobDescriptionId, JobId, JobDescription, JobDescription_e, 
             JobDescriptionId AS org_JobDescriptionId, JobId AS org_JobId FROM CD_JobDescription");
             repositoryItemGridLookUpEditJobDescriptionId.DataSource = FXFW.SqlDB.LoadDataTable("SELECT JobId, JobNAME, JobNAME_e FROM CD_EmpJop"); 
             break;
         case TableNames.CD_Department:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT DepartmentId, Department, Department_e FROM CD_Department");
             break;
         case TableNames.CD_Subject:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e, simple FROM CD_Subject");
             break;
         case TableNames.CD_QualifiedPlace:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT QualifiedPlaceId, QualifiedPlaceName, QualifiedPlaceName_e FROM CD_QualifiedPlace");
             break;
         case TableNames.CDQualification:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT qualId, qualName, qualName_e, trbawy FROM CDQualification");
             break;
         case TableNames.CD_Specialization:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SpecializationId, qualId, SpecializationName, SpecializationName_e FROM CD_Specialization");
             repositoryItemGridLookUpEditqualId.DataSource = FXFW.SqlDB.LoadDataTable("Select qualId, qualName, qualName_e From CDQualification"); 
             break;
         case TableNames.CD_MaritalStatus:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT MaritalStatusId, MaritalStatus, MaritalStatus_e FROM CD_MaritalStatus");
             break;
         case TableNames.CD_Courses:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT CourseId, CourseName, CourseName_e FROM CD_Courses");
             break;
         case TableNames.CDPlaceTraining:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT PlaceTrainingId, PlaceTrainingName, PlaceTrainingName_e, PlaceTrainingTell, PlaceTrainingemail FROM CDPlaceTraining");
             break;
         case TableNames.CD_AgazaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e, allow FROM CD_AgazaType");
             break;
         case TableNames.CDTakdeer:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT TakdeerId, TakdeerName, TakdeerName_e FROM CDTakdeer");
             break;
         case TableNames.CD_EznType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EznTypeId, EznType, EznType_e FROM CD_EznType");
             break;
         case TableNames.CD_GzaaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GzaaTypeId, GzaaType, GzaaType_e FROM CD_GzaaType");
             break;
         case TableNames.CD_GehaGazaa:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GehaGazaaId, GehaGazaa, GehaGazaa_e FROM CD_GehaGazaa");
             break;
         case TableNames.CD_EmpTIME:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EmpID, FatraId, Convert(Datetime, TimeAttendance, 114) AS TimeAttendance, Convert(Datetime, TimeLeave, 114) AS TimeLeave, 
             EmpID AS org_EmpID, FatraId AS org_FatraId FROM CD_EmpTIME");
             repositoryItemGridLookUpEditEmpID.DataSource = FXFW.SqlDB.LoadDataTable("SELECT EmpID, Isnull(EMP_FIRST_NAME, '') + ' ' + Isnull(EMP_FATHER_NAME, '') + ' ' + Isnull(EMP_FAM_NAME, '') + ' ' + Isnull(EMP_FOURTH_NAME, '') AS Emp_Name From TBL_Emp");
             repositoryItemGridLookUpEditFatraId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT FatraId, FatraName FROM CD_Ftra");
             break;
         case TableNames.CDGov:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT GovId, GOV FROM CDGov");
             break;
         case TableNames.CD_AsaseSalary:
             dt = SQLProvider.SelectCD_AsaseSalary();
             break;
         default:
             break;
     }
     gridControlCode.DataSource = dt;
     //gridViewCDMarahel.BestFitColumns()
     ((DevExpress.XtraGrid.Views.Grid.GridView)gridControlCode.MainView).BestFitColumns();
     
 }
 public CodeFrm(TableNames CodeName)
 {
     InitializeComponent();
     ViewName = CodeName;
     switch (CodeName)
     {
         case TableNames.CD_AsaseEmp:
             gridControlCode.MainView = gridViewCD_AsaseEmp;
             LoadData(TableNames.CD_AsaseEmp);
             Text += " تحديد العام";
             break;
         case TableNames.CD_EmpState:
             gridControlCode.MainView = gridViewCD_EmpState;
              LoadData(TableNames.CD_EmpState);
              Text += " الحالة الوظيفية";
             break;
         case TableNames.CD_JobDescription:
             gridControlCode.MainView = gridViewCD_JobDescription;
             LoadData(TableNames.CD_JobDescription);
             Text += " وظائف العاملين";
             break;
         case TableNames.CD_EmpJob:
             gridControlCode.MainView = gridViewCD_EmpJob;
             LoadData(TableNames.CD_EmpJob);
             Text += " الوصف الوظيفي";
             break;
         case TableNames.CD_Department:
             gridControlCode.MainView = gridViewCD_Department;
             LoadData(TableNames.CD_Department);
             Text += " الاقسام";
             break;
         case TableNames.CD_Subject:// Removed
             gridControlCode.MainView = gridViewCD_Subject;
             LoadData(TableNames.CD_Subject);
             Text += " المواد";
             break;
         case TableNames.CD_QualifiedPlace:
             gridControlCode.MainView = gridViewCD_QualifiedPlace;
             LoadData(TableNames.CD_QualifiedPlace);
             Text += " جهة الؤهل";
             break;
         case TableNames.CDQualification:
             gridControlCode.MainView = gridViewCDQualification;
             LoadData(TableNames.CDQualification);
             Text += " المؤهلات";
             break;
         case TableNames.CD_Specialization:
             gridControlCode.MainView = gridViewCD_Specialization;
             LoadData(TableNames.CD_Specialization);
             Text += " تخصص المؤهل";
             break;
         case TableNames.CD_MaritalStatus:
             gridControlCode.MainView = gridViewCD_MaritalStatus;
             LoadData(TableNames.CD_MaritalStatus);
             Text += " الحالة الاجتماعية";
             break;
         case TableNames.CD_Courses:
             gridControlCode.MainView = gridViewCD_Courses;
             LoadData(TableNames.CD_Courses);
             Text += " الدورات التدريبية";
             break;
         case TableNames.CDPlaceTraining:
             gridControlCode.MainView = gridViewCDPlaceTraining;
             LoadData(TableNames.CDPlaceTraining);
             Text += " الحالة الاجتماعية";
             break;
         case TableNames.CD_AgazaType:
             gridControlCode.MainView = gridViewCD_AgazaType;
             LoadData(TableNames.CD_AgazaType);
             Text += " انواع الغياب";
             break;
         case TableNames.CDTakdeer:
             gridControlCode.MainView = gridViewCDTakdeer;
             LoadData(TableNames.CDTakdeer);
             Text += " التقديرات";
             break;
         case TableNames.CD_EznType:
             gridControlCode.MainView = gridViewCD_EznType;
             LoadData(TableNames.CD_EznType);
             Text += " الاذن";
             break;
         case TableNames.CD_GzaaType:
             gridControlCode.MainView = gridViewCD_GzaaType;
             LoadData(TableNames.CD_GzaaType);
             Text += " الجزاءات";
             break;
         case TableNames.CD_GehaGazaa:
             gridControlCode.MainView = gridViewCD_GehaGazaa;
             LoadData(TableNames.CD_GehaGazaa);
             Text += " جهة الجزاء";
             break;
         case TableNames.CD_EmpTIME:
             gridControlCode.MainView = gridViewCD_EmpTIME;
             LoadData(TableNames.CD_EmpTIME);
             Text += " اوقات العاملين";
             break;
         case TableNames.CDGov:
             gridControlCode.MainView = gridViewCDGov;
             LoadData(TableNames.CDGov);
             Text += " المحافظات";
             break;
         case TableNames.CD_AsaseSalary:
             gridControlCode.MainView = gridViewCD_AsaseSalary;
             LoadData(TableNames.CD_AsaseSalary);
             Text += " السنة المالية";
             break;
         default:
             break;
     }
     
 }
예제 #42
0
 public CodeFrm(TableNames CodeName)
 {
     InitializeComponent();
     ViewName = CodeName;
     switch (CodeName)
     {
         case TableNames.CD_AsaseSalary:
             gridControlCode.MainView = gridViewCD_AsaseSalary;
             LoadData(TableNames.CD_AsaseSalary);
             Text += " تحديد العام المالي";
             break;
         case TableNames.CD_SarfGeha:
             gridControlCode.MainView = gridViewCD_SarfGeha;
              LoadData(TableNames.CD_SarfGeha);
              Text += "  جهات الصرف";
             break;
         case TableNames.CDMonth:
             gridControlCode.MainView = gridViewCDMonth;
             LoadData(TableNames.CDMonth);
             Text += "  الشهور";
             break;
         case TableNames.CD_Esthkak:
             gridControlCode.MainView = gridViewCD_Esthkak;
             LoadData(TableNames.CD_Esthkak);
             Text += "  الاستحقاقات";
             break;
         case TableNames.CD_Estktaa:
             gridControlCode.MainView = gridViewCD_Estktaa;
             LoadData(TableNames.CD_Estktaa);
             Text += "  الاستقطاعات";
             break;
         case TableNames.CD_HesaTime:
             gridControlCode.MainView = gridViewCD_HesaTime;
             LoadData(TableNames.CD_HesaTime);
             Text += "  مواعيد الحصص";
             break;
         case TableNames.CDSubjectWekly:
             gridControlCode.MainView = gridViewCDSubjectWekly;
             LoadData(TableNames.CDSubjectWekly);
             Text += " خطة المواد الاسبوعية";
             break;
         case TableNames.CDPlace:
             gridControlCode.MainView = gridViewCDPlace;
             LoadData(TableNames.CDPlace);
             Text += " الاماكن";
             break;
         case TableNames.TBLNesab:
             gridControlCode.MainView = gridViewTBLNesab;
             LoadData(TableNames.TBLNesab);
             Text += " نصاب المدرسين";
             break;
         case TableNames.TBLTeacherNoDays:
             gridControlCode.MainView = gridViewTBLTeacherNoDays;
             LoadData(TableNames.TBLTeacherNoDays);
             Text += " ايام اجازات المدرسين";
             break;
         case TableNames.TBLTeachersPlan:
             gridControlCode.MainView = gridViewTBLTeachersPlan;
             LoadData(TableNames.TBLTeachersPlan);
             Text += " خطط المدرسين";
             break;
         case TableNames.CDPlaceTraining:
             gridControlCode.MainView = gridViewCDPlaceTraining;
             LoadData(TableNames.CDPlaceTraining);
             Text += " الحالة الاجتماعية";
             break;
         case TableNames.CD_AgazaType:
             gridControlCode.MainView = gridViewCD_AgazaType;
             LoadData(TableNames.CD_AgazaType);
             Text += " انواع الغياب";
             break;
         case TableNames.CDTakdeer:
             gridControlCode.MainView = gridViewCDTakdeer;
             LoadData(TableNames.CDTakdeer);
             Text += " التقديرات";
             break;
         case TableNames.CD_EznType:
             gridControlCode.MainView = gridViewCD_EznType;
             LoadData(TableNames.CD_EznType);
             Text += " الاذن";
             break;
         case TableNames.CD_GzaaType:
             gridControlCode.MainView = gridViewCD_GzaaType;
             LoadData(TableNames.CD_GzaaType);
             Text += " الجزاءات";
             break;
         case TableNames.CD_GehaGazaa:
             gridControlCode.MainView = gridViewCD_GehaGazaa;
             LoadData(TableNames.CD_GehaGazaa);
             Text += " جهة الجزاء";
             break;
         default:
             break;
     }
 }
예제 #43
0
 private void LoadData(TableNames CodeName)
 {
     DataTable dt = new DataTable();
     switch (CodeName)
     {
         case TableNames.CD_Asasetime:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, asase_year, school_allcode, SPOS,
             (Select school_allname From TBLSCHOOLALL Where school_allcode = CD_Asasetime.school_allcode) AS school_allname FROM CD_Asasetime");
             repositoryItemGridLookUpEditSPOS.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SPOS, SCHOOL, SCHOOl_e, school_allcode FROM TBLSCHOOL");
             break;
         case TableNames.CDAlhasas:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
             break;
         case TableNames.CDAlsofof:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT alsofof_code, alsofof_name, marhala_code, alsofof_name_e, Shortly, Shortlye FROM CDAlsofof");
             repositoryItemGridLookUpEditmarhala_code.DataSource = FXFW.SqlDB.LoadDataTable("Select marhala_code, marhala_name, marhala_name_e From CDMarahel");
             break;
         case TableNames.CDEFasl:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e, Shortly, Shortlye FROM CDEFasl");
             break;
         case TableNames.CDDayname:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
             break;
         case TableNames.CD_HesaTime:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT marhala_code, daycode, hasa_code, Convert(Datetime, tiem_be, 114) AS tiem_be, Convert(Datetime, tiem_en, 114) AS tiem_en,
             marhala_code as org_marhala_code, daycode as org_daycode, hasa_code as org_hasa_code
             FROM gdw.CD_HesaTime");
             repositoryItemGridLookUpEditmarhala_code.DataSource = FXFW.SqlDB.LoadDataTable("Select marhala_code, marhala_name, marhala_name_e From CDMarahel");
             repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname");
             repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
             break;
         case TableNames.CDSubjectWekly:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT alsofof_code, SubjectId, hesasno, twoh, alsofof_code AS org_alsofof_code, SubjectId AS org_SubjectId FROM CDSubjectWekly");
             repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject");
             repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable("Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof");
             break;
         case TableNames.CDPlace:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace");
             break;
         case TableNames.CD_EmpState:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EmpStateID, EmpStateName, EmpStateName_e, OnWork FROM CD_EmpState");
             break;
         case TableNames.CD_JobDescription:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT JobDescriptionId, JobDescription, JobDescription_e FROM CD_JobDescription");
             break;
         case TableNames.CD_EmpJob:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT EmpJobId, JobDescriptionId, EmpJobName, EmpJobName_e FROM CD_EmpJob");
             repositoryItemGridLookUpEditJobDescriptionId.DataSource = FXFW.SqlDB.LoadDataTable("Select JobDescriptionId, JobDescription, JobDescription_e FROM CD_JobDescription");
             break;
         case TableNames.CD_Department:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT DepartmentId, Department, Department_e FROM CD_Department");
             break;
         case TableNames.CD_Subject:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e, simple FROM CD_Subject");
             break;
         case TableNames.CD_QualifiedPlace:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT QualifiedPlaceId, QualifiedPlaceName, QualifiedPlaceName_e FROM CD_QualifiedPlace");
             break;
         case TableNames.CDQualification:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT qualId, qualName, qualName_e, trbawy FROM CDQualification");
             break;
         case TableNames.CD_Specialization:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SpecializationId, qualId, SpecializationName, SpecializationName_e FROM CD_Specialization");
             repositoryItemGridLookUpEditqualId.DataSource = FXFW.SqlDB.LoadDataTable("Select qualId, qualName, qualName_e From CDQualification");
             break;
         case TableNames.CD_MaritalStatus:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT MaritalStatusId, MaritalStatus, MaritalStatus_e FROM CD_MaritalStatus");
             break;
         case TableNames.TBL_Priority:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, hasa_code, autoid FROM TBL_Priority");
             repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject");
             repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas");
             break;
         case TableNames.CD_AgazaType:
             dt = FXFW.SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e, allow FROM CD_AgazaType");
             break;
         default:
             break;
     }
     gridControlCode.DataSource = dt;
     //gridViewCDMarahel.BestFitColumns()
     ((DevExpress.XtraGrid.Views.Grid.GridView)gridControlCode.MainView).BestFitColumns();
 }
예제 #44
0
 public void InsertOnSubmit(TableNames entityName, object entity)
 {
     this.AddObject(entityName.ToString(), entity);
 }