public static void LoadPersonnelDataToControl(System.Windows.Forms.Control control, Model.Archive.ArchiveTab archiveTab, string personnelNumber)
{
System.Data.DataTable tempDataTable = SqlHelper.GetData(archiveTab.Name, personnelNumber);
List <Model.Archive.ArchiveField> archiveFields = Controller.Archive.DossierCacheController.GetArchiveFields(archiveTab.ID);
foreach (Model.Archive.ArchiveField field in archiveFields)
{
if (field.BoxTypeCode == (int)Enums.BoxTypes.کادر_ورود_اطلاعات_گروهی)
{
System.Data.DataTable subGroupDataTable = SqlHelper.GetData(field.FieldName, personnelNumber);
Njit.Program.Controls.DataGridViewExtended subGroupDataGridView = control.Controls[field.FieldName].Controls[field.FieldName] as Njit.Program.Controls.DataGridViewExtended;
List <Model.Archive.ArchiveSubGroupField> subGroupFields = Controller.Archive.DossierCacheController.GetSubGroupFields(field.ID);
subGroupDataGridView.Rows.Clear();
foreach (System.Data.DataRow row in subGroupDataTable.Rows)
{
subGroupDataGridView.Rows.Add();
int CurrentRowIndex = subGroupDataGridView.RowCount - 2;
foreach (Model.Archive.ArchiveSubGroupField SubGroupField in subGroupFields)
{
if (SubGroupField.FieldTypeCode == (int)Enums.FieldTypes.شخص_حقیقی)
{
subGroupDataGridView.Rows[CurrentRowIndex].Cells[SubGroupField.FieldName].Value = Controller.Archive.RightfulPersonController.TryGetRightfulPerson(row[SubGroupField.FieldName].ToString());
((subGroupDataGridView.Rows[CurrentRowIndex].Cells[SubGroupField.FieldName]) as Njit.Program.DataGridViewColumn.NjitComboBoxCell).SelectedValue = row[SubGroupField.FieldName];
}
else if (SubGroupField.FieldTypeCode == (int)Enums.FieldTypes.شخص_حقوقی)
{
subGroupDataGridView.Rows[CurrentRowIndex].Cells[SubGroupField.FieldName].Value = Controller.Archive.LegalPersonController.TryGetLegalPerson(row[SubGroupField.FieldName].ToString());
((subGroupDataGridView.Rows[CurrentRowIndex].Cells[SubGroupField.FieldName]) as Njit.Program.DataGridViewColumn.NjitComboBoxCell).SelectedValue = row[SubGroupField.FieldName];
}
else
{
subGroupDataGridView.Rows[CurrentRowIndex].Cells[SubGroupField.FieldName].Value = row[SubGroupField.FieldName].ToString();
}
}
}
subGroupDataGridView.BestFitColumns();
}
else if (tempDataTable.Rows.Count > 0)
{
if (field.BoxTypeCode == (int)Enums.BoxTypes.کادر_انتخاب_اشخاص)
{
((Njit.Program.Controls.ComboBoxExtended)(control.Controls[field.FieldName])).SelectedValue = tempDataTable.Rows[0][field.FieldName];
}
else if (field.BoxTypeCode == (int)Enums.BoxTypes.کادر_انتخاب)
{
((System.Windows.Forms.CheckBox)control.Controls[field.FieldName]).Checked = bool.Parse(tempDataTable.Rows[0][field.FieldName].ToString());
}
else
{
control.Controls[field.FieldName].Text = tempDataTable.Rows[0][field.FieldName].ToString();
}
}
}
}
public static void LoadArchiveTabDataToControls(System.Windows.Forms.Control control, Model.Archive.ArchiveTab archiveTab, Model.Archive.Document document)
{
if (archiveTab.IsNullOrEmpty())
{
return;
}
if (archiveTab.ArchiveFields.Count == 0)
{
return;
}
System.Data.DataTable tempDataTable = SqlHelper.GetDocuments(archiveTab.Name, document);
List <Model.Archive.ArchiveField> fields = Controller.Archive.ArchiveFieldController.GetArchiveFields(archiveTab);
foreach (Model.Archive.ArchiveField field in fields)
{
if (field.BoxTypeCode == (int)Enums.BoxTypes.کادر_ورود_اطلاعات_گروهی)
{
System.Data.DataTable DataTableSubGroup = SqlHelper.GetDocuments(field.FieldName, document);
Njit.Program.Controls.DataGridViewExtended subGroupDataGridView = control.Controls[field.FieldName].Controls[field.FieldName] as Njit.Program.Controls.DataGridViewExtended;
subGroupDataGridView.Rows.Clear();
List <Model.Archive.ArchiveSubGroupField> SubGroupFields = Controller.Archive.DossierCacheController.GetSubGroupFields(field.ID);
foreach (System.Data.DataRow row in DataTableSubGroup.Rows)
{
subGroupDataGridView.Rows.Add();
int CurrentRowIndex = subGroupDataGridView.RowCount - 2;
foreach (Model.Archive.ArchiveSubGroupField SubGroupField in SubGroupFields)
{
subGroupDataGridView.Rows[CurrentRowIndex].Cells[SubGroupField.FieldName].Value = row[SubGroupField.FieldName].ToString();
}
}
subGroupDataGridView.BestFitColumns();
}
else if (tempDataTable.Rows.Count > 0)
{
if (field.FieldName != "Field4" && field.FieldName != "Field5" && field.FieldName != "Field6")
{
control.Controls[field.FieldName].Text = tempDataTable.Rows[0][field.FieldName].ToString();
}
}
}
}
private void CreateObject(string tabPageName, Model.Archive.ArchiveField field, int xLabel, int yLabel, int xControl, int yControl)
{
try
{
if (field.BoxTypeCode != (int)Enums.BoxTypes.کادر_ورود_اطلاعات_گروهی && field.BoxTypeCode != (int)Enums.BoxTypes.کادر_انتخاب)
{
Label label = DossierFormHelper.CreateLabel(field.Label, xLabel, yLabel);
tabControlExtended.TabPages[tabPageName].Controls.Add(label);
}
if (field.StatusCode == (int)Enums.StatusOfFields.مقدار_نتواند_تهی_باشد)
{
Label labelStar = DossierFormHelper.CreateLabelStar(xLabel, yLabel);
tabControlExtended.TabPages[tabPageName].Controls.Add(labelStar);
}
else if (field.StatusCode == (int)Enums.StatusOfFields.مقدار_یکتا_باشد_و_نتواند_تهی_باشد)
{
Label labelStar = DossierFormHelper.CreateLabelStar(xLabel, yLabel);
labelStar.ForeColor = Color.Green;
tabControlExtended.TabPages[tabPageName].Controls.Add(labelStar);
}
switch (field.BoxTypeCode)
{
case (int)Enums.BoxTypes.کادر_متن:
Njit.Program.Controls.TextBoxExtended textBox = DossierFormHelper.CreateTextBox(field, xControl, yControl);
if (field.FieldTypeCode != (int)Enums.FieldTypes.متن_طولانی)
{
textBox.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Controls_KeyDown);
}
textBox.TextChanged += new EventHandler(Controls_TextChanged);
tabControlExtended.TabPages[tabPageName].Controls.Add(textBox);
if (field.AutoComplete)
{
textBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox.AutoCompleteMode = AutoCompleteMode.Append;
textBox.AutoCompleteCustomSource.AddRange(SqlHelper.GetAllFieldValues(tabPageName, field.FieldName));
}
if (field.FieldTypeCode == (int)Enums.FieldTypes.شمارنده)
{
textBox.ReadOnly = true;
Model.Archive.CounterFieldSetting counterFieldSetting = Controller.Archive.ArchiveFieldController.GetCounterFieldProperties(field.ID);
string newValue = SqlHelper.GetNewValueOfCounterFiled(field, counterFieldSetting);
textBox.Text = newValue;
}
break;
case (int)Enums.BoxTypes.کادر_ورود_تاریخ:
Njit.Program.Controls.DateControl dateControl = DossierFormHelper.CreateDateBox(field, xControl, yControl);
dateControl.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Controls_KeyDown);
dateControl.TextChanged += new EventHandler(Controls_TextChanged);
tabControlExtended.TabPages[tabPageName].Controls.Add(dateControl);
break;
case (int)Enums.BoxTypes.کادر_بازشو:
Njit.Program.Controls.ComboBoxExtended comboBoxExtended = DossierFormHelper.CreateComboBox(field, xControl, yControl);
comboBoxExtended.TextChanged += new EventHandler(Controls_TextChanged);
comboBoxExtended.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Controls_KeyDown);
tabControlExtended.TabPages[tabPageName].Controls.Add(comboBoxExtended);
break;
case (int)Enums.BoxTypes.کادر_انتخاب:
CheckBox checkBox = DossierFormHelper.CreateChekBox(field, xLabel, yLabel);
checkBox.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Controls_KeyDown);
tabControlExtended.TabPages[tabPageName].Controls.Add(checkBox);
break;
case (int)Enums.BoxTypes.کادر_ورود_ساعت:
Njit.Program.Controls.TimeControl timeControl = DossierFormHelper.CreateTimeBox(field, xControl, yControl);
timeControl.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Controls_KeyDown);
tabControlExtended.TabPages[tabPageName].Controls.Add(timeControl);
break;
case (int)Enums.BoxTypes.کادر_ورود_اطلاعات_گروهی:
Njit.Program.Controls.DataGridViewExtended dataGridViewExtended = DossierFormHelper.CreateDataGridView(field);
dataGridViewExtended.Rows.CollectionChanged += Rows_CollectionChanged;
dataGridViewExtended.CurrentCellChanged += DataGridView_CurrentCellChanged;
GroupBox groupBox = DossierFormHelper.CreateGroupBox(field, yControl);
groupBox.Controls.Add(dataGridViewExtended);
tabControlExtended.TabPages[tabPageName].Controls.Add(groupBox);
break;
case (int)Enums.BoxTypes.کادر_انتخاب_اشخاص:
Njit.Program.Controls.ComboBoxExtended personComboBoxExtended = DossierFormHelper.CreatePersonComboBox(field, xControl, yControl);
personComboBoxExtended.TextChanged += new EventHandler(Controls_TextChanged);
personComboBoxExtended.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Controls_KeyDown);
personComboBoxExtended.SelectedIndexChanged += personComboBoxExtended_SelectedIndexChanged;
tabControlExtended.TabPages[tabPageName].Controls.Add(personComboBoxExtended);
break;
}
}
catch (Exception ex)
{
PersianMessageBox.Show(ex.Message);
}
}
