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();
}
}
public override List <TableInfo> RefreshTableNames()
{
var item = CurrentTables.ToList();
TableNames.SetSource(item);
return(item);
}
/// <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();
}
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);
}
public int countTableRows(TableNames table)
{
dataTable = this.getAllData(table);
int RowNumber = dataTable.Rows.Count;
return(RowNumber);
}
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();
}
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;
}
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);
}));
}
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);
}
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);
}
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);
}
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);
}
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);
}
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;
}
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);
}
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);
}
/// <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);
}
/// <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);
}
/// <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());
}
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);
}
//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);
}
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);
}
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);
}
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);
}
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;
}
}
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();
}
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;
}
}
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;
}
}
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();
}
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();
}
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;
}
}
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;
}
}
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();
}
public void InsertOnSubmit(TableNames entityName, object entity)
{
this.AddObject(entityName.ToString(), entity);
}
