示例#1
0
        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);
 }