private void LoadDefaultData(CodeFrm.TableNames TableName) { switch (TableName) { case CodeFrm.TableNames.CDAlsofof: repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable(@"Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof"); break; case CodeFrm.TableNames.CDEFasl: repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e FROM CDEFasl"); break; case CodeFrm.TableNames.All: 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 CDEFasl"); 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"); repositoryItemGridLookUpEditEmpID.DisplayMember = "emp_name"; repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID"; repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject"); break; default: break; } }
public void LoadCD_Asasetime() { foreach (DockPanel pnl in dockManagerMain.Panels) pnl.Enabled = false; repositoryItemLookUpEditasase_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT asase_code, asase_year, SPOS, (Select SCHOOL From TBLSCHOOL Where SPOS = CD_Asasetime.SPOS) AS SCHOOL, school_allcode FROM CD_Asasetime ORDER BY asase_code DESC"); DataTable dt = (DataTable)repositoryItemLookUpEditasase_code.DataSource; if (dt.Rows.Count == 0) { CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_Asasetime) { Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["CD_Asasetime.png"], 32, false) }; FrmCode.ExitAfterSave = true; FrmCode.ShowDialog(); } else { barEditItemasase_code.EditValue = dt.Rows[0]["asase_code"]; DevExpress.XtraEditors.Controls.ButtonPredefines btn = new DevExpress.XtraEditors.Controls.ButtonPredefines(); btn = DevExpress.XtraEditors.Controls.ButtonPredefines.OK; repositoryItemLookUpEditasase_code_ButtonClick(repositoryItemLookUpEditasase_code, new DevExpress.XtraEditors.Controls.ButtonPressedEventArgs(new DevExpress.XtraEditors.Controls.EditorButton(btn))); } }
private void LoadDefaultData(CodeFrm.TableNames TableName) { switch (TableName) { case CodeFrm.TableNames.CD_AgazaType: repositoryItemGridLookUpEditagaza_type_code.DataSource = SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e FROM CD_AgazaType"); repositoryItemGridLookUpEditagaza_type_code.DisplayMember = "AgazaTypeName"; repositoryItemGridLookUpEditagaza_type_code.ValueMember = "AgazaTypeId"; break; case CodeFrm.TableNames.All: //CD_Specialization repositoryItemGridLookUpEditagaza_type_code.DataSource = SqlDB.LoadDataTable(@"SELECT AgazaTypeId, AgazaTypeName, AgazaTypeName_e FROM CD_AgazaType"); repositoryItemGridLookUpEditagaza_type_code.DisplayMember = "AgazaTypeName"; repositoryItemGridLookUpEditagaza_type_code.ValueMember = "AgazaTypeId"; //TBL_Emp repositoryItemGridLookUpEditEmpID.DataSource = 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"); repositoryItemGridLookUpEditEmpID.DisplayMember = "Emp_Name"; repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID"; break; default: break; } }
private void repositoryItemGridLookUpEditagaza_type_code_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { if (e.Button.Kind != DevExpress.XtraEditors.Controls.ButtonPredefines.Plus) return; CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_AgazaType); FrmCode.ShowDialog(); LoadDefaultData(CodeFrm.TableNames.CD_AgazaType); }
private void LoadDefaultData(CodeFrm.TableNames TableName) { switch (TableName) { case CodeFrm.TableNames.CDDayname: repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname"); LUEDays.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname"); LUEDays.Properties.DisplayMember = "dayname"; LUEDays.Properties.ValueMember = "daycode"; break; case CodeFrm.TableNames.CDAlhasas: repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas"); break; case CodeFrm.TableNames.All: 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"); LUEDays.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname"); LUEDays.Properties.DisplayMember = "dayname"; LUEDays.Properties.ValueMember = "daycode"; 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"); repositoryItemGridLookUpEditEmpID.DisplayMember = "emp_name"; repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID"; LUEEmp.Properties.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"); LUEEmp.Properties.DisplayMember = "emp_name"; LUEEmp.Properties.ValueMember = "EmpID"; break; default: break; } }
private void navBarItemTimeTBL_Priority_LinkClicked(object sender, NavBarLinkEventArgs e) { CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.TBL_Priority) { MdiParent = this, Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["TBL_Priority.png"], 32, false) }; FrmCode.Show(); }
private void navBarItemTimeCD_Specialization_LinkClicked(object sender, NavBarLinkEventArgs e) { CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_Specialization) { MdiParent = this, Icon = FXFW.SqlDB.MakeIcon(imageCollection32.Images["CD_Specialization.png"], 32, false) }; FrmCode.Show(); }
private void LoadDefaultData(CodeFrm.TableNames TableName) { switch (TableName) { case CodeFrm.TableNames.CDAlsofof: repositoryItemGridLookUpEditalsofof_code.DataSource = FXFW.SqlDB.LoadDataTable(@"Select alsofof_code, alsofof_name, alsofof_name_e FROM CDAlsofof"); break; case CodeFrm.TableNames.CDEFasl: repositoryItemGridLookUpEditfasl_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT fasl_code, fasl_name, fasl_name_e FROM CDEFasl"); break; case CodeFrm.TableNames.CDDayname: repositoryItemGridLookUpEditdaycode.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT daycode, dayname, dayname_e FROM CDDayname"); break; case CodeFrm.TableNames.CDAlhasas: repositoryItemGridLookUpEdithasa_code.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT hasa_code, hasa_name, hasa_name_e FROM CDAlhasas"); break; case CodeFrm.TableNames.CDPlace: repositoryItemGridLookUpEditplacecd.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace"); LuePlace.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace"); LuePlaceShare.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace"); break; case CodeFrm.TableNames.All: 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 CDEFasl"); 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"); repositoryItemGridLookUpEditplacecd.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace"); DataTable dt = 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"); LUEEmp.Properties.DataSource = dt; repositoryItemGridLookUpEditEmpID.DataSource = dt; repositoryItemGridLookUpEditEmpID.DisplayMember = "emp_name"; repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID"; repositoryItemGridLookUpEditSubjectId.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT SubjectId, Subject, Subject_e FROM CD_Subject"); LuePlace.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace"); LuePlaceShare.Properties.DataSource = FXFW.SqlDB.LoadDataTable(@"SELECT placecd, place FROM gdw.CDPlace"); break; default: break; } }