public static string CheckForDofaaCreationErrors(int DofatSarfId, int SyndicateId)
{
string msg = string.Empty;
SqlConnection con = new SqlConnection(Properties.Settings.Default.RetirementCenterConnectionString);
SqlCommand cmd = new SqlCommand(string.Format(@"SELECT COUNT(*) FROM vQry06 WHERE(SyndicateId = {0})", SyndicateId), con);
int result = 0;
try
{
con.Open();
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في اخطاء فرعيات مسئول الصرف", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry07 WHERE SyndicateId = {0}", SyndicateId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في ورثة تصرف لاعضاء لا تصرف", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry08 WHERE SyndicateId = {0}", SyndicateId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في خطاء في مسئول الورثة", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry11 WHERE SyndicateId = {0} AND DofatSarfId = {1}", SyndicateId, DofatSarfId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في الاستثنائات", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry12 WHERE SyndicateId = {0}", SyndicateId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في ورثة بدون مسئول صرف", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry13 WHERE SyndicateId = {0}", SyndicateId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في اخطاء في تقرير الورثة", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry14 WHERE SyndicateId = {0}", SyndicateId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في ورثة بأسماء فارغة", result) + Environment.NewLine;
cmd.CommandText = string.Format(@"SELECT COUNT(*) FROM vQry15 WHERE SyndicateId = {0}", SyndicateId);
result = Convert.ToInt32(cmd.ExecuteScalar());
if (result != 0)
msg += string.Format(@"{0} في اخطاء لجان الفرعيات الورثة", result) + Environment.NewLine;
DataSources.dsQueriesTableAdapters.Qry09TableAdapter adp = new DataSources.dsQueriesTableAdapters.Qry09TableAdapter();
result = adp.GetDataBySyndicateId(SyndicateId, DofatSarfId).Count;
if (result != 0)
msg += string.Format(@"{0} في ورثه ليس لهم استثناء", result) + Environment.NewLine;
}
catch (SqlException ex)
{
con.Close();
throw ex;
}
con.Close();
return msg;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.gridControlData = new DevExpress.XtraGrid.GridControl();
this.qry09BindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dsQueries = new RetirementCenter.DataSources.dsQueries();
this.gridViewData = new DevExpress.XtraGrid.Views.Grid.GridView();
this.colpersonName = new DevExpress.XtraGrid.Columns.GridColumn();
this.colMMashatName = new DevExpress.XtraGrid.Columns.GridColumn();
this.colSyndicateWarasa = new DevExpress.XtraGrid.Columns.GridColumn();
this.colSubCommitteWarasa = new DevExpress.XtraGrid.Columns.GridColumn();
this.colSyndicateM = new DevExpress.XtraGrid.Columns.GridColumn();
this.colSubCommitteM = new DevExpress.XtraGrid.Columns.GridColumn();
this.colpersonNameR = new DevExpress.XtraGrid.Columns.GridColumn();
this.colpersonNID = new DevExpress.XtraGrid.Columns.GridColumn();
this.colsarfnumber = new DevExpress.XtraGrid.Columns.GridColumn();
this.colyasref = new DevExpress.XtraGrid.Columns.GridColumn();
this.coldatein = new DevExpress.XtraGrid.Columns.GridColumn();
this.colRealName = new DevExpress.XtraGrid.Columns.GridColumn();
this.colPersonId = new DevExpress.XtraGrid.Columns.GridColumn();
this.colMMashatId = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemDateEditDate = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.repositoryItemPictureEditImg = new DevExpress.XtraEditors.Repository.RepositoryItemPictureEdit();
this.repositoryItemCheckEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
this.repositoryItemDateEditDMY = new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
this.LSMSTBLDofatSarf = new DevExpress.Data.Linq.LinqServerModeSource();
this.panelControl1 = new DevExpress.XtraEditors.PanelControl();
this.LUETBLDofatSarf = new DevExpress.XtraEditors.GridLookUpEdit();
this.gridLookUpEdit1View = new DevExpress.XtraGrid.Views.Grid.GridView();
this.colDofatSarf1 = new DevExpress.XtraGrid.Columns.GridColumn();
this.labelControl1 = new DevExpress.XtraEditors.LabelControl();
this.btnPrintExport = new DevExpress.XtraEditors.SimpleButton();
this.colDofatSarf = new DevExpress.XtraGrid.Columns.GridColumn();
this.qry09TableAdapter = new RetirementCenter.DataSources.dsQueriesTableAdapters.Qry09TableAdapter();
((System.ComponentModel.ISupportInitialize)(this.gridControlData)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.qry09BindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsQueries)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridViewData)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDate)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDate.VistaTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemPictureEditImg)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemCheckEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDMY)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDMY.VistaTimeProperties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.LSMSTBLDofatSarf)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();
this.panelControl1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.LUETBLDofatSarf.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridLookUpEdit1View)).BeginInit();
this.SuspendLayout();
//
// gridControlData
//
this.gridControlData.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.gridControlData.DataSource = this.qry09BindingSource;
this.gridControlData.EmbeddedNavigator.Buttons.CancelEdit.Visible = false;
this.gridControlData.EmbeddedNavigator.Buttons.Edit.Visible = false;
this.gridControlData.EmbeddedNavigator.Buttons.EndEdit.Visible = false;
this.gridControlData.EmbeddedNavigator.Buttons.Remove.Visible = false;
this.gridControlData.EmbeddedNavigator.TextStringFormat = "صف {0} من {1}";
this.gridControlData.Location = new System.Drawing.Point(0, 53);
this.gridControlData.MainView = this.gridViewData;
this.gridControlData.Name = "gridControlData";
this.gridControlData.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
this.repositoryItemDateEditDate,
this.repositoryItemPictureEditImg,
this.repositoryItemCheckEdit1,
this.repositoryItemDateEditDMY});
this.gridControlData.Size = new System.Drawing.Size(734, 404);
this.gridControlData.TabIndex = 1;
this.gridControlData.UseEmbeddedNavigator = true;
this.gridControlData.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.gridViewData});
//
// qry09BindingSource
//
this.qry09BindingSource.DataMember = "Qry09";
this.qry09BindingSource.DataSource = this.dsQueries;
//
// dsQueries
//
this.dsQueries.DataSetName = "dsQueries";
this.dsQueries.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// gridViewData
//
this.gridViewData.Appearance.ColumnFilterButton.BackColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.ColumnFilterButton.BorderColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.ColumnFilterButton.ForeColor = System.Drawing.Color.DimGray;
this.gridViewData.Appearance.ColumnFilterButton.Options.UseBackColor = true;
this.gridViewData.Appearance.ColumnFilterButton.Options.UseBorderColor = true;
this.gridViewData.Appearance.ColumnFilterButton.Options.UseForeColor = true;
this.gridViewData.Appearance.ColumnFilterButtonActive.BackColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.ColumnFilterButtonActive.BorderColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.ColumnFilterButtonActive.ForeColor = System.Drawing.Color.Gainsboro;
this.gridViewData.Appearance.ColumnFilterButtonActive.Options.UseBackColor = true;
this.gridViewData.Appearance.ColumnFilterButtonActive.Options.UseBorderColor = true;
this.gridViewData.Appearance.ColumnFilterButtonActive.Options.UseForeColor = true;
this.gridViewData.Appearance.Empty.BackColor = System.Drawing.Color.DimGray;
this.gridViewData.Appearance.Empty.GradientMode = System.Drawing.Drawing2D.LinearGradientMode.BackwardDiagonal;
this.gridViewData.Appearance.Empty.Options.UseBackColor = true;
this.gridViewData.Appearance.EvenRow.BackColor = System.Drawing.Color.White;
this.gridViewData.Appearance.EvenRow.Options.UseBackColor = true;
this.gridViewData.Appearance.FilterCloseButton.BackColor = System.Drawing.Color.Gray;
this.gridViewData.Appearance.FilterCloseButton.BorderColor = System.Drawing.Color.Gray;
this.gridViewData.Appearance.FilterCloseButton.Options.UseBackColor = true;
this.gridViewData.Appearance.FilterCloseButton.Options.UseBorderColor = true;
this.gridViewData.Appearance.FilterPanel.BackColor = System.Drawing.Color.Gray;
this.gridViewData.Appearance.FilterPanel.ForeColor = System.Drawing.Color.Black;
this.gridViewData.Appearance.FilterPanel.Options.UseBackColor = true;
this.gridViewData.Appearance.FilterPanel.Options.UseForeColor = true;
this.gridViewData.Appearance.FocusedRow.BackColor = System.Drawing.Color.Black;
this.gridViewData.Appearance.FocusedRow.ForeColor = System.Drawing.Color.White;
this.gridViewData.Appearance.FocusedRow.Options.UseBackColor = true;
this.gridViewData.Appearance.FocusedRow.Options.UseForeColor = true;
this.gridViewData.Appearance.FooterPanel.BackColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.FooterPanel.BorderColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.FooterPanel.Options.UseBackColor = true;
this.gridViewData.Appearance.FooterPanel.Options.UseBorderColor = true;
this.gridViewData.Appearance.FooterPanel.Options.UseTextOptions = true;
this.gridViewData.Appearance.FooterPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridViewData.Appearance.GroupButton.BackColor = System.Drawing.Color.Silver;
this.gridViewData.Appearance.GroupButton.BorderColor = System.Drawing.Color.Silver;
this.gridViewData.Appearance.GroupButton.Options.UseBackColor = true;
this.gridViewData.Appearance.GroupButton.Options.UseBorderColor = true;
this.gridViewData.Appearance.GroupFooter.BackColor = System.Drawing.Color.Silver;
this.gridViewData.Appearance.GroupFooter.BorderColor = System.Drawing.Color.Silver;
this.gridViewData.Appearance.GroupFooter.Options.UseBackColor = true;
this.gridViewData.Appearance.GroupFooter.Options.UseBorderColor = true;
this.gridViewData.Appearance.GroupPanel.BackColor = System.Drawing.Color.DimGray;
this.gridViewData.Appearance.GroupPanel.ForeColor = System.Drawing.Color.Gray;
this.gridViewData.Appearance.GroupPanel.Options.UseBackColor = true;
this.gridViewData.Appearance.GroupPanel.Options.UseForeColor = true;
this.gridViewData.Appearance.GroupRow.BackColor = System.Drawing.Color.Silver;
this.gridViewData.Appearance.GroupRow.Font = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
this.gridViewData.Appearance.GroupRow.Options.UseBackColor = true;
this.gridViewData.Appearance.GroupRow.Options.UseFont = true;
this.gridViewData.Appearance.HeaderPanel.BackColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.HeaderPanel.BorderColor = System.Drawing.Color.DarkGray;
this.gridViewData.Appearance.HeaderPanel.Options.UseBackColor = true;
this.gridViewData.Appearance.HeaderPanel.Options.UseBorderColor = true;
this.gridViewData.Appearance.HideSelectionRow.BackColor = System.Drawing.Color.LightSlateGray;
this.gridViewData.Appearance.HideSelectionRow.Options.UseBackColor = true;
this.gridViewData.Appearance.HorzLine.BackColor = System.Drawing.Color.LightGray;
this.gridViewData.Appearance.HorzLine.Options.UseBackColor = true;
this.gridViewData.Appearance.OddRow.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridViewData.Appearance.OddRow.Options.UseBackColor = true;
this.gridViewData.Appearance.Preview.BackColor = System.Drawing.Color.Gainsboro;
this.gridViewData.Appearance.Preview.ForeColor = System.Drawing.Color.DimGray;
this.gridViewData.Appearance.Preview.Options.UseBackColor = true;
this.gridViewData.Appearance.Preview.Options.UseForeColor = true;
this.gridViewData.Appearance.Row.BackColor = System.Drawing.Color.White;
this.gridViewData.Appearance.Row.Options.UseBackColor = true;
this.gridViewData.Appearance.RowSeparator.BackColor = System.Drawing.Color.DimGray;
this.gridViewData.Appearance.RowSeparator.Options.UseBackColor = true;
this.gridViewData.Appearance.SelectedRow.BackColor = System.Drawing.Color.DimGray;
this.gridViewData.Appearance.SelectedRow.Options.UseBackColor = true;
this.gridViewData.Appearance.VertLine.BackColor = System.Drawing.Color.LightGray;
this.gridViewData.Appearance.VertLine.Options.UseBackColor = true;
this.gridViewData.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.colpersonName,
this.colMMashatName,
this.colSyndicateWarasa,
this.colSubCommitteWarasa,
this.colSyndicateM,
this.colSubCommitteM,
this.colpersonNameR,
this.colpersonNID,
this.colsarfnumber,
this.colyasref,
this.coldatein,
this.colRealName,
this.colPersonId,
this.colMMashatId});
this.gridViewData.GridControl = this.gridControlData;
this.gridViewData.Name = "gridViewData";
this.gridViewData.OptionsBehavior.ReadOnly = true;
this.gridViewData.OptionsCustomization.AllowRowSizing = true;
this.gridViewData.OptionsFind.AlwaysVisible = true;
this.gridViewData.OptionsPrint.EnableAppearanceEvenRow = true;
this.gridViewData.OptionsPrint.EnableAppearanceOddRow = true;
this.gridViewData.OptionsView.ColumnAutoWidth = false;
this.gridViewData.OptionsView.EnableAppearanceEvenRow = true;
this.gridViewData.OptionsView.EnableAppearanceOddRow = true;
this.gridViewData.OptionsView.ShowAutoFilterRow = true;
this.gridViewData.OptionsView.ShowFooter = true;
//
// colpersonName
//
this.colpersonName.AppearanceCell.Options.UseTextOptions = true;
this.colpersonName.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colpersonName.AppearanceHeader.Options.UseTextOptions = true;
this.colpersonName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colpersonName.Caption = "اسم الوريث";
this.colpersonName.FieldName = "personName";
this.colpersonName.Name = "colpersonName";
this.colpersonName.Visible = true;
this.colpersonName.VisibleIndex = 0;
//
// colMMashatName
//
this.colMMashatName.AppearanceCell.Options.UseTextOptions = true;
this.colMMashatName.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colMMashatName.AppearanceHeader.Options.UseTextOptions = true;
this.colMMashatName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colMMashatName.Caption = "اسم العضو";
this.colMMashatName.FieldName = "MMashatName";
this.colMMashatName.Name = "colMMashatName";
this.colMMashatName.Visible = true;
this.colMMashatName.VisibleIndex = 4;
//
// colSyndicateWarasa
//
this.colSyndicateWarasa.AppearanceCell.Options.UseTextOptions = true;
this.colSyndicateWarasa.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSyndicateWarasa.AppearanceHeader.Options.UseTextOptions = true;
this.colSyndicateWarasa.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSyndicateWarasa.Caption = "فرعية الوريث";
this.colSyndicateWarasa.FieldName = "SyndicateW";
this.colSyndicateWarasa.Name = "colSyndicateWarasa";
this.colSyndicateWarasa.Visible = true;
this.colSyndicateWarasa.VisibleIndex = 2;
this.colSyndicateWarasa.Width = 77;
//
// colSubCommitteWarasa
//
this.colSubCommitteWarasa.AppearanceCell.Options.UseTextOptions = true;
this.colSubCommitteWarasa.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSubCommitteWarasa.AppearanceHeader.Options.UseTextOptions = true;
this.colSubCommitteWarasa.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSubCommitteWarasa.Caption = "لجنة الوريث";
this.colSubCommitteWarasa.FieldName = "SubCommitteW";
this.colSubCommitteWarasa.Name = "colSubCommitteWarasa";
this.colSubCommitteWarasa.Visible = true;
this.colSubCommitteWarasa.VisibleIndex = 3;
//
// colSyndicateM
//
this.colSyndicateM.AppearanceCell.Options.UseTextOptions = true;
this.colSyndicateM.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSyndicateM.AppearanceHeader.Options.UseTextOptions = true;
this.colSyndicateM.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSyndicateM.Caption = "فرعية العضو";
this.colSyndicateM.FieldName = "SyndicateM";
this.colSyndicateM.Name = "colSyndicateM";
this.colSyndicateM.Visible = true;
this.colSyndicateM.VisibleIndex = 5;
//
// colSubCommitteM
//
this.colSubCommitteM.AppearanceCell.Options.UseTextOptions = true;
this.colSubCommitteM.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSubCommitteM.AppearanceHeader.Options.UseTextOptions = true;
this.colSubCommitteM.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colSubCommitteM.Caption = "لجنة العضو";
this.colSubCommitteM.FieldName = "SubCommitteM";
this.colSubCommitteM.Name = "colSubCommitteM";
this.colSubCommitteM.Visible = true;
this.colSubCommitteM.VisibleIndex = 6;
//
// colpersonNameR
//
this.colpersonNameR.AppearanceCell.Options.UseTextOptions = true;
this.colpersonNameR.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colpersonNameR.AppearanceHeader.Options.UseTextOptions = true;
this.colpersonNameR.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colpersonNameR.Caption = "اسم المسئول";
this.colpersonNameR.FieldName = "personNameR";
this.colpersonNameR.Name = "colpersonNameR";
this.colpersonNameR.Visible = true;
this.colpersonNameR.VisibleIndex = 1;
this.colpersonNameR.Width = 92;
//
// colpersonNID
//
this.colpersonNID.AppearanceCell.Options.UseTextOptions = true;
this.colpersonNID.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colpersonNID.AppearanceHeader.Options.UseTextOptions = true;
this.colpersonNID.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colpersonNID.Caption = "الرقم القومي";
this.colpersonNID.FieldName = "personNID";
this.colpersonNID.Name = "colpersonNID";
this.colpersonNID.Visible = true;
this.colpersonNID.VisibleIndex = 9;
this.colpersonNID.Width = 80;
//
// colsarfnumber
//
this.colsarfnumber.AppearanceCell.Options.UseTextOptions = true;
this.colsarfnumber.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colsarfnumber.AppearanceHeader.Options.UseTextOptions = true;
this.colsarfnumber.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colsarfnumber.Caption = "رقم الصرف";
this.colsarfnumber.FieldName = "sarfnumber";
this.colsarfnumber.Name = "colsarfnumber";
this.colsarfnumber.Visible = true;
this.colsarfnumber.VisibleIndex = 7;
//
// colyasref
//
this.colyasref.AppearanceCell.Options.UseTextOptions = true;
this.colyasref.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colyasref.AppearanceHeader.Options.UseTextOptions = true;
this.colyasref.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colyasref.Caption = "يصرف";
this.colyasref.FieldName = "yasref";
this.colyasref.Name = "colyasref";
this.colyasref.Visible = true;
this.colyasref.VisibleIndex = 8;
this.colyasref.Width = 46;
//
// coldatein
//
this.coldatein.AppearanceCell.Options.UseTextOptions = true;
this.coldatein.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.coldatein.AppearanceHeader.Options.UseTextOptions = true;
this.coldatein.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.coldatein.Caption = "تاريخ الادخال";
this.coldatein.FieldName = "datein";
this.coldatein.Name = "coldatein";
this.coldatein.Visible = true;
this.coldatein.VisibleIndex = 11;
//
// colRealName
//
this.colRealName.AppearanceCell.Options.UseTextOptions = true;
this.colRealName.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colRealName.AppearanceHeader.Options.UseTextOptions = true;
this.colRealName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colRealName.Caption = "مدخل البيان";
this.colRealName.FieldName = "RealName";
this.colRealName.Name = "colRealName";
this.colRealName.Visible = true;
this.colRealName.VisibleIndex = 10;
//
// colPersonId
//
this.colPersonId.AppearanceCell.Options.UseTextOptions = true;
this.colPersonId.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colPersonId.AppearanceHeader.Options.UseTextOptions = true;
this.colPersonId.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colPersonId.Caption = "كود الوريث";
this.colPersonId.FieldName = "PersonId";
this.colPersonId.Name = "colPersonId";
this.colPersonId.Visible = true;
this.colPersonId.VisibleIndex = 12;
//
// colMMashatId
//
this.colMMashatId.AppearanceCell.Options.UseTextOptions = true;
this.colMMashatId.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colMMashatId.AppearanceHeader.Options.UseTextOptions = true;
this.colMMashatId.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colMMashatId.Caption = "كود العضو";
this.colMMashatId.FieldName = "MMashatId";
this.colMMashatId.Name = "colMMashatId";
this.colMMashatId.Visible = true;
this.colMMashatId.VisibleIndex = 13;
//
// repositoryItemDateEditDate
//
this.repositoryItemDateEditDate.AutoHeight = false;
this.repositoryItemDateEditDate.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEditDate.DisplayFormat.FormatString = "u";
this.repositoryItemDateEditDate.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.repositoryItemDateEditDate.Mask.EditMask = "u";
this.repositoryItemDateEditDate.Name = "repositoryItemDateEditDate";
this.repositoryItemDateEditDate.VistaTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()});
//
// repositoryItemPictureEditImg
//
this.repositoryItemPictureEditImg.Name = "repositoryItemPictureEditImg";
//
// repositoryItemCheckEdit1
//
this.repositoryItemCheckEdit1.AutoHeight = false;
this.repositoryItemCheckEdit1.Name = "repositoryItemCheckEdit1";
//
// repositoryItemDateEditDMY
//
this.repositoryItemDateEditDMY.AutoHeight = false;
this.repositoryItemDateEditDMY.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.repositoryItemDateEditDMY.DisplayFormat.FormatString = "dd/MM/yyyy";
this.repositoryItemDateEditDMY.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.repositoryItemDateEditDMY.EditFormat.FormatString = "dd/MM/yyyy";
this.repositoryItemDateEditDMY.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
this.repositoryItemDateEditDMY.Mask.EditMask = "dd/MM/yyyy";
this.repositoryItemDateEditDMY.Name = "repositoryItemDateEditDMY";
this.repositoryItemDateEditDMY.VistaTimeProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()});
//
// LSMSTBLDofatSarf
//
this.LSMSTBLDofatSarf.ElementType = typeof(RetirementCenter.DataSources.Linq.TBLDofatSarf);
this.LSMSTBLDofatSarf.KeyExpression = "[DofatSarfId]";
//
// panelControl1
//
this.panelControl1.Controls.Add(this.LUETBLDofatSarf);
this.panelControl1.Controls.Add(this.labelControl1);
this.panelControl1.Controls.Add(this.btnPrintExport);
this.panelControl1.Dock = System.Windows.Forms.DockStyle.Top;
this.panelControl1.Location = new System.Drawing.Point(0, 0);
this.panelControl1.Name = "panelControl1";
this.panelControl1.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
this.panelControl1.Size = new System.Drawing.Size(734, 47);
this.panelControl1.TabIndex = 3;
//
// LUETBLDofatSarf
//
this.LUETBLDofatSarf.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.LUETBLDofatSarf.Location = new System.Drawing.Point(426, 15);
this.LUETBLDofatSarf.Name = "LUETBLDofatSarf";
this.LUETBLDofatSarf.Properties.Appearance.Font = new System.Drawing.Font("Tahoma", 10F);
this.LUETBLDofatSarf.Properties.Appearance.Options.UseFont = true;
this.LUETBLDofatSarf.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
this.LUETBLDofatSarf.Properties.DataSource = this.LSMSTBLDofatSarf;
this.LUETBLDofatSarf.Properties.DisplayMember = "DofatSarf";
this.LUETBLDofatSarf.Properties.NullText = "";
this.LUETBLDofatSarf.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
this.LUETBLDofatSarf.Properties.ValueMember = "DofatSarfId";
this.LUETBLDofatSarf.Properties.View = this.gridLookUpEdit1View;
this.LUETBLDofatSarf.Size = new System.Drawing.Size(249, 22);
this.LUETBLDofatSarf.TabIndex = 3;
this.LUETBLDofatSarf.EditValueChanged += new System.EventHandler(this.LUETBLDofatSarf_EditValueChanged);
//
// gridLookUpEdit1View
//
this.gridLookUpEdit1View.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.colDofatSarf1});
this.gridLookUpEdit1View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.gridLookUpEdit1View.Name = "gridLookUpEdit1View";
this.gridLookUpEdit1View.OptionsSelection.EnableAppearanceFocusedCell = false;
this.gridLookUpEdit1View.OptionsView.ShowGroupPanel = false;
//
// colDofatSarf1
//
this.colDofatSarf1.Caption = "الدفعة";
this.colDofatSarf1.FieldName = "DofatSarf";
this.colDofatSarf1.Name = "colDofatSarf1";
this.colDofatSarf1.Visible = true;
this.colDofatSarf1.VisibleIndex = 0;
//
// labelControl1
//
this.labelControl1.Anchor = System.Windows.Forms.AnchorStyles.Right;
this.labelControl1.Location = new System.Drawing.Point(681, 20);
this.labelControl1.Name = "labelControl1";
this.labelControl1.Size = new System.Drawing.Size(41, 13);
this.labelControl1.TabIndex = 2;
this.labelControl1.Text = "الدفعــــة";
//
// btnPrintExport
//
this.btnPrintExport.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnPrintExport.Location = new System.Drawing.Point(12, 12);
this.btnPrintExport.Name = "btnPrintExport";
this.btnPrintExport.Size = new System.Drawing.Size(134, 23);
this.btnPrintExport.TabIndex = 1;
this.btnPrintExport.Text = "طباعه و تصدير";
this.btnPrintExport.Click += new System.EventHandler(this.btnPrintExport_Click);
//
// colDofatSarf
//
this.colDofatSarf.AppearanceCell.Options.UseTextOptions = true;
this.colDofatSarf.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colDofatSarf.AppearanceHeader.Options.UseTextOptions = true;
this.colDofatSarf.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.colDofatSarf.Caption = "الدفعـــــــة";
this.colDofatSarf.FieldName = "DofatSarf";
this.colDofatSarf.Name = "colDofatSarf";
this.colDofatSarf.Visible = true;
this.colDofatSarf.VisibleIndex = 0;
//
// qry09TableAdapter
//
this.qry09TableAdapter.ClearBeforeFill = true;
//
// Qry09Frm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(734, 462);
this.Controls.Add(this.panelControl1);
this.Controls.Add(this.gridControlData);
this.Name = "Qry09Frm";
this.Text = "ورثه ليس لهم استثناء";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.Qry06Frm_Load);
((System.ComponentModel.ISupportInitialize)(this.gridControlData)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.qry09BindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsQueries)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridViewData)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDate.VistaTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDate)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemPictureEditImg)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemCheckEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDMY.VistaTimeProperties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemDateEditDMY)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.LSMSTBLDofatSarf)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();
this.panelControl1.ResumeLayout(false);
this.panelControl1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.LUETBLDofatSarf.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridLookUpEdit1View)).EndInit();
this.ResumeLayout(false);
}