/// <summary> /// 绑定数据集到GridControl控件中的RepositoryItemLookUpEdit列 /// </summary> /// <param name="lookUpEdit">lookupEdit控件</param> /// <param name="dataTable">数据源</param> /// <param name="displayMember">显示名称</param> /// <param name="valueMember">对应EditValue值</param> public static void BindLookUpEdit(RepositoryItemLookUpEdit lookUpEdit, DataTable dataTable, string displayMember, string valueMember) { if (dataTable.Rows.Count == 0 || dataTable.Rows[0][displayMember].ToString() != "--请选择--") { DataRow dataRowTemp = dataTable.NewRow(); dataRowTemp[displayMember] = "--请选择--"; dataRowTemp[valueMember] = "-99999"; dataTable.Rows.InsertAt(dataRowTemp, 0); } lookUpEdit.DataSource = dataTable; lookUpEdit.DisplayMember = displayMember; lookUpEdit.ValueMember = valueMember; lookUpEdit.Columns.Clear(); lookUpEdit.Columns.Add(new LookUpColumnInfo(displayMember)); lookUpEdit.ShowHeader = false; lookUpEdit.ShowFooter = false; //lookUpEdit.NullText = ""; lookUpEdit.PopupFormMinSize = new System.Drawing.Size(10, 10); //lookUpEdit.PopupWidth = lookUpEdit.Width - 3; lookUpEdit.DropDownRows = dataTable.Rows.Count <= 6 ? dataTable.Rows.Count : 6; lookUpEdit.NullText = ""; if (dataTable.Rows.Count > 0) { lookUpEdit.ForceInitialize(); } }
private void bindComboToGrid() { RepositoryItemLookUpEdit cboTeamMember = new RepositoryItemLookUpEdit(); gridView1.Columns["TeamMemberID"].ColumnEdit = cboTeamMember; cboTeamMember.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; cboTeamMember.Name = "TeamMemberID"; cboTeamMember.ValueMember = "ID"; cboTeamMember.DisplayMember = "userName"; cboTeamMember.Columns.Add(new LookUpColumnInfo("userName", 80)); usersGrid.RepositoryItems.Add(cboTeamMember); cboTeamMember.DataSource = frmMain.usersList; cboTeamMember.ForceInitialize(); gridView1.Columns["TeamMemberID"].Caption = "Team Member"; RepositoryItemLookUpEdit cboManager = new RepositoryItemLookUpEdit(); gridView1.Columns["ManagerID"].ColumnEdit = cboManager; cboManager.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; cboManager.Name = "ManagerID"; cboManager.ValueMember = "ID"; cboManager.DisplayMember = "userName"; cboManager.Columns.Add(new LookUpColumnInfo("userName", 80)); usersGrid.RepositoryItems.Add(cboManager); cboManager.DataSource = frmMain.usersList; cboManager.ForceInitialize(); gridView1.Columns["ManagerID"].Caption = "Manager"; }
static public void LookUpEdit_SetList(ref RepositoryItemLookUpEdit lookUpEdit, DataTable table, string valuefield, string namefield, string filter, int[] hiddencolumns) { #region Creating table if (table != null) { if (string.IsNullOrEmpty(filter)) { lookUpEdit.DataSource = table; } else { DataView dv = new DataView(table); dv.RowFilter = filter; lookUpEdit.DataSource = dv; } lookUpEdit.ForceInitialize(); lookUpEdit.PopulateColumns(); } #endregion #region Hide columns if (hiddencolumns != null && hiddencolumns.Length > 0) { for (int i = 0; i < hiddencolumns.Length; i++) { int index = hiddencolumns[i]; if (index >= 0 && index < lookUpEdit.Columns.Count) { lookUpEdit.Columns[index].Visible = false; } } } #endregion #region Setting properties lookUpEdit.CaseSensitiveSearch = false; lookUpEdit.CharacterCasing = CharacterCasing.Upper; lookUpEdit.ValueMember = valuefield.ToUpper(); lookUpEdit.DisplayMember = namefield.ToUpper(); lookUpEdit.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit; lookUpEdit.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete; lookUpEdit.ShowHeader = false; //lookUpEdit.ShowFooter = false; lookUpEdit.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; lookUpEdit.NullText = string.Empty; #endregion if (valuefield != namefield) { LookUpEdit_SetDisplayValue(ref lookUpEdit, valuefield, namefield); } }
/// <summary> /// 绑定数据集到GridControl控件中的RepositoryItemLookUpEdit列(无请选择列) /// </summary> /// <param name="lookUpEdit">lookupEdit控件</param> /// <param name="dataTable">数据源</param> /// <param name="displayMember">显示名称</param> /// <param name="valueMember">对应EditValue值</param> public static void BindLookUpEdit(RepositoryItemLookUpEdit lookUpEdit, DataTable dataTable, string displayMember, string valueMember, string defaultvalue) { lookUpEdit.DataSource = dataTable; lookUpEdit.DisplayMember = displayMember; lookUpEdit.ValueMember = valueMember; lookUpEdit.Columns.Clear(); lookUpEdit.Columns.Add(new LookUpColumnInfo(displayMember)); lookUpEdit.ShowHeader = false; lookUpEdit.ShowFooter = false; lookUpEdit.NullText = ""; lookUpEdit.PopupFormMinSize = new System.Drawing.Size(10, 10); lookUpEdit.DropDownRows = dataTable.Rows.Count <= 6 ? dataTable.Rows.Count : 6; if (dataTable.Rows.Count > 0) { lookUpEdit.ForceInitialize(); } }
private void PopulateFiscalYear() { DataTable dt = new DataTable(); dt = UnitDirBL.GetFiscalYear(); RepositoryItemLookUpEdit Fiscal = cboFiscalYear.Edit as RepositoryItemLookUpEdit; Fiscal.DataSource = dt; Fiscal.PopulateColumns(); Fiscal.ForceInitialize(); Fiscal.DisplayMember = "FName"; Fiscal.ValueMember = "FYearId"; Fiscal.Columns["FYearId"].Visible = false; Fiscal.Columns["StartDate"].Visible = false; Fiscal.Columns["EndDate"].Visible = false; Fiscal.ShowFooter = false; Fiscal.ShowHeader = false; }
private void GridCustomRowCellEditForEditing(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e) { if (e.Column.FieldName == nameof(invoices_details.itemunit_id)) { RepositoryItemLookUpEdit repo = new RepositoryItemLookUpEdit(); repo.NullText = ""; e.RepositoryItem = repo; var ins = new Session.ProductViewClass.ProductUOMView(); var row = Grid.GetRow(e.RowHandle) as invoices_details; if (row == null) { return; } var item = Session.ProductView.SingleOrDefault(x => x.id == row.itemid); if (item == null) { return; } repo.DataSource = item.Units; repo.ValueMember = nameof(ins.unitid); repo.DisplayMember = nameof(ins.UnitName); repo.ForceInitialize(); repo.PopulateColumns(); repo.BestFitMode = BestFitMode.BestFitResizePopup; repo.HighlightedItemStyle = DevExpress.XtraEditors.HighlightStyle.Standard; repo.Columns[nameof(ins.unitid)].Visible = false; repo.Columns[nameof(ins.UnitName)].Caption = "إسم الوحدة"; repo.Columns[nameof(ins.factor)].Caption = "معالج التحويل"; repo.Columns[nameof(ins.buyprice)].Caption = "سعر الشراء"; repo.Columns[nameof(ins.sellprice)].Caption = "سعر البيع"; repo.Columns[nameof(ins.barcode)].Caption = "الباركود"; } else if (e.Column.FieldName == nameof(details.itemid)) { e.RepositoryItem = repoItems; } }
private void cboCheckList_EditValueChanged(object sender, EventArgs e) { DataTable dtFlatTypeCheckList = new DataTable(); DataTable dtExe = new DataTable(); i_CheckListId = Convert.ToInt32(cboCheckList.EditValue.ToString()); if (i_CheckListId != 0) { dtFlatTypeCheckList = ApplyOthersDL.GetFlatTypeCheckList(i_FlatTypeId, i_CheckListId); grdFlatCheckList.DataSource = dtFlatTypeCheckList; grdFlatCheckList.ForceInitialize(); grdFlatCheckListView.PopulateColumns(); RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit(); cboExecutive.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; dtExe = CRM.DataLayer.UnitDirDL.Executive(); cboExecutive.DataSource = dtExe; cboExecutive.ForceInitialize(); cboExecutive.PopulateColumns(); cboExecutive.DisplayMember = "ExecName"; cboExecutive.ValueMember = "ExecId"; cboExecutive.ShowHeader = false; cboExecutive.ShowFooter = false; cboExecutive.Columns["ExecId"].Visible = false; cboExecutive.NullText = "None"; RepositoryItemDateEdit expDate = new RepositoryItemDateEdit(); expDate.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; grdFlatCheckListView.OptionsBehavior.Editable = true; grdFlatCheckListView.Columns["ExpCompletionDate"].ColumnEdit = expDate; grdFlatCheckListView.Columns["FlatNo"].OptionsColumn.AllowEdit = false; grdFlatCheckListView.Columns["ExecutiveId"].ColumnEdit = cboExecutive; grdFlatCheckListView.Columns["FlatId"].Visible = false; grdFlatCheckListView.Columns["ExpCompletionDate"].Width = 125; grdFlatCheckListView.Columns["CompletionDate"].Width = 100; grdFlatCheckListView.Columns["Status"].Width = 50; } }
private void Frm_Invoices_Load(object sender, EventArgs e) { switch (Type) { case Master.InvoiceType.Purshases: this.LabelName.Text = "فاتورة مشتريات"; break; case Master.InvoiceType.Sales: this.LabelName.Text = "فاتورة مبيعات"; break; case Master.InvoiceType.PurchasesReturn: this.LabelName.Text = "فاتورة مرتجع مشتريات"; break; case Master.InvoiceType.SalesReturn: this.LabelName.Text = "فاتورة مرتجع مبيعات"; break; default: break; } //ColorTranslator.FromHtml("#FF99FFCC");// Grid.OptionsView.ShowIndicator = false; Lkp_PartType.IntializeData(Master.PartTypesList); Grid.OptionsView.NewItemRowPosition = NewItemRowPosition.Top; Grid.Columns[nameof(details.total_price)].OptionsColumn.AllowFocus = false; Grid.Columns[nameof(details.id)].Visible = false; Grid.Columns[nameof(details.invoiceid)].Visible = false; Grid.OptionsView.ShowVerticalLines = DefaultBoolean.False; Grid.OptionsView.BestFitMode = GridBestFitMode.Full; Grid.Appearance.EvenRow.BackColor = Master.color(220, "#FAFAD2"); //Color.FromArgb(220,255, 249, 210); Grid.OptionsView.EnableAppearanceEvenRow = true; Grid.Appearance.OddRow.BackColor = Master.color(50, "#D2D2FA"); //Color.FromArgb(50,220, 220, 220); Grid.OptionsView.EnableAppearanceOddRow = true; Grid.Columns.Add(new GridColumn() { Name = "clmCode", FieldName = "Code", Caption = "باركود", UnboundType = UnboundColumnType.String, }); Grid.Columns.Add(new GridColumn() { Name = "clmIndex", FieldName = "Index", Caption = "#", UnboundType = UnboundColumnType.Integer, MaxWidth = 30, //Nulltext }); Grid.Columns["Index"].OptionsColumn.AllowFocus = false; Grid.Columns[nameof(details.total_price)].OptionsColumn.AllowFocus = false; Grid.Columns[nameof(details.itemid)].Caption = "إسم الصنف"; Grid.Columns[nameof(details.itemunit_id)].Caption = "الوحدة"; Grid.Columns[nameof(details.item_Qty)].Caption = "الكمية"; Grid.Columns[nameof(details.price)].Caption = "السعر"; Grid.Columns[nameof(details.total_price)].Caption = "إجمالي السعر"; Grid.Columns[nameof(details.cost_value)].Caption = "التكلفة"; Grid.Columns[nameof(details.totalcoste_value)].Caption = "إجمالي التكلفة"; Grid.Columns[nameof(details.discount)].Caption = "% الخصم"; Grid.Columns[nameof(details.discount_value)].Caption = "الخصم"; Grid.Columns[nameof(details.store_id)].Caption = "المخزن"; Grid.Columns["Index"].VisibleIndex = 0; Grid.Columns["Code"].VisibleIndex = 1; Grid.Columns[nameof(details.itemid)].VisibleIndex = 2; Grid.Columns[nameof(details.itemunit_id)].VisibleIndex = 3; Grid.Columns[nameof(details.item_Qty)].VisibleIndex = 4; Grid.Columns[nameof(details.price)].VisibleIndex = 5; Grid.Columns[nameof(details.discount)].VisibleIndex = 6; Grid.Columns[nameof(details.discount_value)].VisibleIndex = 7; Grid.Columns[nameof(details.total_price)].VisibleIndex = 8; Grid.Columns[nameof(details.cost_value)].VisibleIndex = 9; Grid.Columns[nameof(details.totalcoste_value)].VisibleIndex = 10; Grid.Columns[nameof(details.store_id)].VisibleIndex = 11; /*Create Grid view items in cells itemid*/ repoItems.IntializeData(Session.ProductView.Where(x => x.status == true), Grid.Columns[nameof(details.itemid)], Grid_Details); repoItems.ValidateOnEnterKey = true; repoItems.AllowNullInput = DefaultBoolean.False; repoItems.BestFitMode = BestFitMode.BestFitResizePopup; repoItems.ImmediatePopup = true; repoItemsAll.IntializeData(Session.ProductView, Grid.Columns[nameof(details.itemid)], Grid_Details); GridView repoview = repoItems.View; repoview.FocusRectStyle = DrawFocusRectStyle.RowFullFocus; repoview.OptionsSelection.UseIndicatorForSelection = true; repoview.OptionsView.ShowAutoFilterRow = true; repoItems.PopulateViewColumns(); repoview.Columns[nameof(product.status)].Visible = false; repoview.Columns[nameof(product.type)].Visible = false; repoview.Columns[nameof(product.id)].Visible = false; repoview.Columns[nameof(product.code)].Caption = "الكود "; repoview.Columns[nameof(product.name)].Caption = "الإسم "; repoview.Columns[nameof(product.category)].Caption = "الفئة "; repoview.Columns[nameof(product.details)].Caption = "الوصف "; repoUOM.IntializeData(Session.units, Grid.Columns[nameof(details.itemunit_id)], Grid_Details); repoStores.IntializeData(Session.Stores, Grid.Columns[nameof(details.store_id)], Grid_Details); //repoItems.ValueMember = "id"; repoStores.ForceInitialize(); repoStores.PopulateColumns(); repoStores.Columns[0].Visible = false; repoview.Columns[1].Caption = "اسم المخزن "; repoStores.BestFitMode = BestFitMode.BestFitResizePopup; #region : SpinEdit RepositoryItemSpinEdit spinEdit = new RepositoryItemSpinEdit(); Grid.Columns[nameof(details.total_price)].ColumnEdit = spinEdit; Grid.Columns[nameof(details.price)].ColumnEdit = spinEdit; Grid.Columns[nameof(details.discount_value)].ColumnEdit = spinEdit; spinEdit.Mask.EditMask = "N3"; spinEdit.Mask.UseMaskAsDisplayFormat = true; spinEdit.MinValue = Convert.ToDecimal(0.1); spinEdit.MaxValue = Convert.ToDecimal(1000000000); spinEdit.Increment = 1; RepositoryItemSpinEdit spinRatioEdit = new RepositoryItemSpinEdit(); Grid.Columns[nameof(details.discount)].ColumnEdit = spinRatioEdit; spinRatioEdit.Increment = 0.01m; spinRatioEdit.Mask.EditMask = "p"; spinRatioEdit.Mask.UseMaskAsDisplayFormat = true; spinRatioEdit.MaxValue = 1; RepositoryItemSpinEdit spinspinQteEdit = new RepositoryItemSpinEdit(); Grid.Columns[nameof(details.item_Qty)].ColumnEdit = spinspinQteEdit; spinspinQteEdit.Increment = 0.1m; spinspinQteEdit.Mask.EditMask = "n"; spinRatioEdit.Mask.UseMaskAsDisplayFormat = true; spinspinQteEdit.MinValue = Convert.ToDecimal(0.1); spinspinQteEdit.MaxValue = Convert.ToDecimal(1000000000); spinspinQteEdit.Increment = 1; Grid_Details.RepositoryItems.Add(spinspinQteEdit); Grid_Details.RepositoryItems.Add(spinRatioEdit); Grid_Details.RepositoryItems.Add(spinEdit); #endregion #region : Events this.Activated += Frm_Invoices_Activated; GLkp_PartName.ButtonClick += GLkp_PartName_ButtonClick; /*احتساب قيم و نسب الضريبة*/ Sp_DiscValue.Enter += new EventHandler(Sp_InvDiscValue_Enter); Sp_DiscValue.Leave += Sp_InvDiscValue_Leave;; Sp_DiscValue.EditValueChanged += Sp_InvDiscValue_EditValueChanged; Sp_DiscRatio.EditValueChanged += Sp_InvDiscValue_EditValueChanged; Sp_TaxValue.Enter += Sp_InvTaxValue_Enter; Sp_TaxValue.Leave += Sp_InvTaxValue_Leave; Sp_TaxValue.EditValueChanged += Sp_InvTaxValue_EditValueChanged; Sp_TaxRatio.EditValueChanged += Sp_InvTaxValue_EditValueChanged; Sp_Total.EditValueChanged += Spn_EditValueChanged; Sp_Expences.EditValueChanged += Spn_EditValueChanged; Sp_Expences.EditValueChanged += Sp_InvPaid_EditValueChanged; Sp_Paid.EditValueChanged += Sp_InvPaid_EditValueChanged; Sp_Net.DoubleClick += Sp_Net_DoubleClick; Sp_Net.EditValueChanging += Sp_Net_EditValueChanging; /* الصنف "ID" جلب الوحدات حسب*/ Grid.CustomRowCellEditForEditing += GridCustomRowCellEditForEditing; /* جلب بيانات وحدة الصنف */ Grid.CellValueChanged += GridCellValueChanged; Grid.RowCountChanged += GridRowCountChanged; Grid.RowUpdated += GridRowUpdated; Lkp_Branch.EditValueChanging += Lkp_Branch_EditValueChanging; Grid.CustomUnboundColumnData += GridCustomUnboundColumnData; Grid_Details.ProcessGridKey += Grid_Details_ProcessGridKey; Grid.ValidateRow += GridValidateRow; Grid.InvalidRowException += GridInvalidRowException; #endregion MoveFocusToGrid(); }
private void FillCheck() { grdCheck.DataSource = null; DataTable dt = new DataTable(); if (m_sType == "FlatType") { if (m_sCType == "") { return; } dt = UnitDirBL.FlatTypeCheckList(m_iId, m_sCType, m_icostCentreId); grdCheck.DataSource = dt; grdCheckView.PopulateColumns(); grdCheckView.Columns["CheckListId"].Visible = false; grdCheckView.Columns["Status"].Visible = false; grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false; RepositoryItemDateEdit expDate = new RepositoryItemDateEdit(); grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate; //grdCheckView.Columns["Status"].Width = 50; //grdCheckView.Columns["Status"].Caption = "Select"; //grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true; //grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)); grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status); } grdCheckView.OptionsBehavior.Editable = true; } else if (m_sType == "Flat") { if (m_sCType == "") { return; } dt = UnitDirBL.FlatCheckList(m_iId, m_sCType); grdCheck.DataSource = dt; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)) == true) { } else { bChkAlertSend = true; } } } grdCheckView.PopulateColumns(); grdCheckView.Columns["CheckListId"].Visible = false; grdCheckView.Columns["Status"].Visible = false; grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false; grdCheckView.Columns["ExecutiveId"].Caption = "Executive"; RepositoryItemDateEdit expDate = new RepositoryItemDateEdit(); grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate; DataTable dtExe = new DataTable(); RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit(); dtExe = UnitDirBL.Executive(); cboExecutive.DataSource = dtExe; cboExecutive.ForceInitialize(); cboExecutive.PopulateColumns(); cboExecutive.DisplayMember = "ExecName"; cboExecutive.ValueMember = "ExecId"; cboExecutive.ShowHeader = false; cboExecutive.ShowFooter = false; cboExecutive.Columns["ExecId"].Visible = false; cboExecutive.NullText = "None"; grdCheckView.Columns["ExecutiveId"].ColumnEdit = cboExecutive; //grdCheckView.Columns["Status"].Width = 50; //grdCheckView.Columns["Status"].Caption = "Select"; //grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true; //grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)); grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status); } grdCheckView.OptionsBehavior.Editable = true; } else if (m_sType == "ProjectInfo") { dt = UnitDirBL.ProjectCheckList(m_iId); grdCheck.DataSource = dt; grdCheckView.PopulateColumns(); grdCheckView.Columns["CheckListId"].Visible = false; grdCheckView.Columns["Status"].Visible = false; grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false; RepositoryItemDateEdit Date = new RepositoryItemDateEdit(); grdCheckView.Columns["CompletionDate"].ColumnEdit = Date; //grdCheckView.Columns["Status"].Width = 50; //grdCheckView.Columns["Status"].Caption = "Select"; //grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true; //grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)); grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status); } grdCheckView.OptionsBehavior.Editable = true; } else if (m_sType == "Final") { //if (m_iId == 0) { MessageBox.Show("Select Flat"); return; } if (dtFinal != null && dtFinal.Rows.Count > 0) { dt = dtFinal; grdCheck.DataSource = dt; } //dtLand = dt; else { if (m_sBussinessType == "L") { dt = UnitDirBL.FinalCheckListPlot(m_iId); dtLand = UnitDirBL.FinalPlot(m_iId); grdCheck.DataSource = dt; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dtLand.Rows.Count; j++) { if (Convert.ToInt32(dtLand.Rows[j]["CheckListId"]) == Convert.ToInt32(dt.Rows[i]["CheckListId"])) { } else { bChkAlertSend = true; } } } } } else { dt = UnitDirBL.FinalCheckListFlat(m_iId); grdCheck.DataSource = dt; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)) == true) { } else { bChkAlertSend = true; } } } } } grdCheckView.PopulateColumns(); grdCheckView.Columns["CheckListId"].Visible = false; grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false; grdCheckView.Columns["ExecutiveId"].Caption = "Executive"; RepositoryItemDateEdit expDate = new RepositoryItemDateEdit(); grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate; DataTable dtExe = new DataTable(); dtExe = UnitDirBL.Executive(); RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit(); cboExecutive.DataSource = dtExe; cboExecutive.ForceInitialize(); cboExecutive.PopulateColumns(); cboExecutive.DisplayMember = "ExecName"; cboExecutive.ValueMember = "ExecId"; cboExecutive.ShowHeader = false; cboExecutive.ShowFooter = false; cboExecutive.Columns["ExecId"].Visible = false; cboExecutive.NullText = "None"; grdCheckView.Columns["ExecutiveId"].ColumnEdit = cboExecutive; if (m_sBussinessType == "B") { grdCheckView.Columns["Status"].Visible = false; selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)); grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status); } } else { selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dtLand.Rows.Count; j++) { if (Convert.ToInt32(dt.Rows[i]["CheckListId"]) == Convert.ToInt32(dtLand.Rows[j]["CheckListId"])) { grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, true); } } } } grdCheckView.OptionsBehavior.Editable = true; } else if (m_sType == "Cancel") { if (dtCancel != null && dtCancel.Rows.Count > 0) { dt = dtCancel; } else { dt = UnitDirBL.CancelCheckListFlat(m_iId); } if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)) == true) { } else { bChkAlertSend = true; } } } grdCheck.DataSource = dt; grdCheckView.PopulateColumns(); grdCheckView.Columns["CheckListId"].Visible = false; grdCheckView.Columns["Status"].Visible = false; grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false; grdCheckView.Columns["ExecutiveId"].Caption = "Executive"; RepositoryItemDateEdit expDate = new RepositoryItemDateEdit(); grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate; DataTable dtExe = new DataTable(); dtExe = UnitDirBL.Executive(); RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit(); cboExecutive.DataSource = dtExe; cboExecutive.DisplayMember = "ExecName"; cboExecutive.ValueMember = "ExecId"; cboExecutive.ForceInitialize(); cboExecutive.PopulateColumns(); cboExecutive.ShowHeader = false; cboExecutive.ShowFooter = false; cboExecutive.Columns["ExecId"].Visible = false; cboExecutive.NullText = "None"; grdCheckView.Columns["ExecutiveId"].ColumnEdit = cboExecutive; selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)); grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status); } grdCheckView.OptionsBehavior.Editable = true; } else if (m_sType == "Project") { if (m_sCType == "") { return; } dt = UnitDirBL.ProjectCheckListFlat(m_iId, m_sCType); grdCheck.DataSource = dt; grdCheckView.PopulateColumns(); grdCheckView.Columns["CheckListId"].Visible = false; grdCheckView.Columns["Status"].Visible = false; grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false; grdCheckView.Columns["CheckListName"].Width = 200; //grdCheckView.Columns["Status"].Width = 50; //grdCheckView.Columns["Status"].Caption = "Select"; //grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true; //grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; selection = new GridSelectAll(grdCheckView); selection.CheckMarkColumn.VisibleIndex = 2; for (int i = 0; i < dt.Rows.Count; i++) { bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)); grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status); } grdCheckView.OptionsBehavior.Editable = true; } grdCheckView.Appearance.HeaderPanel.Font = new Font(grdCheckView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdCheckView.OptionsSelection.InvertSelection = true; grdCheckView.OptionsSelection.EnableAppearanceHideSelection = false; grdCheckView.Appearance.FocusedRow.BackColor = Color.Teal; grdCheckView.Appearance.FocusedRow.ForeColor = Color.White; grdCheckView.BestFitColumns(); }