private void LoadDefaultData(CodeFrm.TableNames TableName)
{
switch (TableName)
{
case CodeFrm.TableNames.CD_Esthkak:
repositoryItemGridLookUpEditEsthkakId.DataSource = SqlDB.LoadDataTable(@"SELECT EsthkakId, Esthkak FROM CD_Esthkak");
repositoryItemGridLookUpEditEsthkakId.DisplayMember = "Esthkak";
repositoryItemGridLookUpEditEsthkakId.ValueMember = "EsthkakId";
break;
case CodeFrm.TableNames.All:
//CD_Esthkak
repositoryItemGridLookUpEditEsthkakId.DataSource = SqlDB.LoadDataTable(@"SELECT EsthkakId, Esthkak FROM CD_Esthkak");
repositoryItemGridLookUpEditEsthkakId.DisplayMember = "Esthkak";
repositoryItemGridLookUpEditEsthkakId.ValueMember = "EsthkakId";
//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 repositoryItemGridLookUpEditEsthkakId_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_Esthkak);
FrmCode.ShowDialog();
LoadDefaultData(CodeFrm.TableNames.CD_Esthkak);
}
