/// <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();
}
