protected override GridColumn CreateColumn()
{
var column = new BandedGridColumn();
column.OptionsColumn.AllowEdit = false;
return(column);
}
private void ExecQuery()
{
//this._paramList = frm.Parameters;
this.dtM = dal.GetSaleMonthByInv(_paramList.ToArray());
this.gridControl1.DataSource = dtM;
#region 重新初始化列
//this.gridView1.Columns.Clear();
this.InitGrid();
//List<BandedGridColumn> list = new List<BandedGridColumn>();
foreach (DataColumn col in dtM.Columns)
{
if (col.ColumnName == "cInvCode" || col.ColumnName == "cFree1")
{
}
else if (bandedGridView1.Columns.ColumnByFieldName(col.ColumnName) == null)
{
BandedGridColumn newcol = new BandedGridColumn();
newcol.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
newcol.Caption = col.ColumnName;
newcol.Name = newcol.FieldName = col.ColumnName;
newcol.Visible = true;
newcol.Width = 80;
newcol.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
newcol.DisplayFormat.FormatString = "{0:n3}";
this.bandedGridView1.Bands["others"].Columns.Add(newcol);
//list.Add(newcol);
}
}
//this.bandedGridView1.AddRange(list.ToArray());
#endregion
}
/// <summary>
/// 밴드에 컬럼을 추가합니다.
/// </summary>
/// <param name="Band">The band.</param>
/// <param name="Caption">The caption.</param>
/// <param name="FieldName">Name of the field.</param>
/// <param name="Name">The name.</param>
/// <param name="Allgment">The allgment.</param>
/// <param name="Width">The width.</param>
private void SetAddBandColumn(DevExpress.XtraGrid.Views.BandedGrid.GridBand Band,
string Caption,
string FieldName,
string Name,
DevExpress.Utils.HorzAlignment Allgment,
int Width)
{
try
{
DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn bandColumn = new BandedGridColumn();
bandColumn.AppearanceHeader.Options.UseTextOptions = true;
bandColumn.AppearanceHeader.TextOptions.HAlignment = Allgment;
bandColumn.Caption = Caption;
bandColumn.FieldName = FieldName;
bandColumn.Name = Name;
bandColumn.Width = Width;
Band.Columns.Add(bandColumn);
}
catch (Exception ex)
{
throw ex;
}
}
private void itemFilerRow_Click(object sender, EventArgs e)
{
BandedGridColumn Column = (sender as DevExpress.Utils.Menu.DXMenuItem).Tag as BandedGridColumn;
// GridView.ShowFilterPopup(Column);
GridView.ShowFilterEditor(Column);
}
void clearFilter(ButtonPressedEventArgs e, BandedGridColumn col)
{
if (e.Button.Kind == ButtonPredefines.Delete)
{
gvGrid.Columns[col.FieldName].ClearFilter();
}
}
private void Form1_Load(object sender, EventArgs e)
{
myUsers.Add(new User("Antuan", "Acapulco", 23));
myUsers[0].About = "Acapulco (Officially known as Acapulco de Juárez) is a city, and major sea port in the state of Guerrero on the Pacific coast of Mexico, 300 kilometres (190 mi) southwest from Mexico City";
myUsers.Add(new User("Bill", "Brussels", 17));
myUsers[1].About = "Brussels is the de facto capital city of the European Union (EU) and the largest urban area in Belgium.[6][7] It comprises 19 municipalities, including the City of Brussels proper, which is the capital of Belgium, Flanders and the French Community of Belgium.";
myUsers.Add(new User("Charli", "Chicago", 45));
myUsers[2].About = "Chicago is the largest city in the U.S. state of Illinois, and with more than 2.8 million people, the 3rd largest city in the United States";
myUsers.Add(new User("Denn", "Denver", 20));
myUsers[3].About = "Denver";
myUsers.Add(new User("Eva", "Ernakulam", 23));
myUsers[4].About = "The name 'Ernakulam' is derived from the name of a very famous temple of Lord Shiva called the Ernakulathappan Temple";
customGridControl1.DataSource = myUsers;
BandedGridColumn gridColumn1 = new BandedGridColumn();
BandedGridColumn gridColumn2 = new BandedGridColumn();
BandedGridColumn gridColumn3 = new BandedGridColumn();
gridColumn1.FieldName = "Name";
gridColumn1.Caption = "Name";
gridColumn2.FieldName = "City";
gridColumn2.Caption = "City";
gridColumn3.FieldName = "Age";
gridColumn3.Caption = "Age";
customGridView1.Columns.Add(gridColumn1);
customGridView1.Columns.Add(gridColumn2);
customGridView1.Columns.Add(gridColumn3);
customGridView1.OptionsView.ShowPreview = true;
customGridView1.PreviewFieldName = "About";
}
/// <summary>
/// Init the repository lookup edit for a banded column
/// </summary>
/// <param name="column">Banded column</param>
/// <param name="dataSource">Data source of repository</param>
public void InitColumnRepository(BandedGridColumn column, List <HRTimeSheetParamsInfo> dataSource)
{
//RepositoryItemBOSLookupEdit rep = new RepositoryItemBOSLookupEdit();
//rep.DataSource = dataSource;
//rep.DisplayMember = "HRTimeSheetParamNo";
//rep.ValueMember = "HRTimeSheetParamNo";
//rep.ShowHeader = false;
//rep.TextEditStyle = TextEditStyles.Standard;
//rep.NullText = string.Empty;
//LookUpColumnInfo lookupColumn = new LookUpColumnInfo();
//lookupColumn.FieldName = "HRTimeSheetParamNo";
//rep.Columns.Add(lookupColumn);
//column.ColumnEdit = rep;
RepositoryItemCheckedComboBoxEdit rep = new RepositoryItemCheckedComboBoxEdit();
rep.DataSource = dataSource;
rep.DisplayMember = "HRTimeSheetParamNo";
rep.ValueMember = "HRTimeSheetParamNo";
rep.TextEditStyle = TextEditStyles.Standard;
rep.NullText = string.Empty;
//LookUpColumnInfo lookupColumn = new LookUpColumnInfo();
//lookupColumn.FieldName = "HRTimeSheetParamNo";
//rep.Columns.Add(lookupColumn);
column.ColumnEdit = rep;
}
private void UpdateColumnOption(BandedGridColumn col, GridBand Owner, bool isEditable = false, bool isFillDown = false, int rowIndex = 0)
{
col.OwnerBand = Owner;
col.OptionsColumn.AllowEdit = isEditable;
col.AutoFillDown = isFillDown;
col.RowIndex = rowIndex;
}
private void itemGroup_Click(object sender, EventArgs e)
{
BandedGridColumn Column = (sender as DevExpress.Utils.Menu.DXMenuItem).Tag as BandedGridColumn;
Column.Group();
Column.View.ExpandAllGroups();
}
private void AddBand()
{
BandedGridColumn bgc;
KQHT_ThanhPhanDiemInfo pKQHT_ThanPhanDiemInfo = new KQHT_ThanhPhanDiemInfo();
cBKQHT_ThanhPhanDiem oBKQHT_ThanhPhanDiem = new cBKQHT_ThanhPhanDiem();
dtThanhPhan = oBKQHT_ThanhPhanDiem.Get(pKQHT_ThanPhanDiemInfo);
grbNhapDiem.Columns.Clear();
if ((dtThanhPhan != null) && (dtThanhPhan.Rows.Count > 0))
{
DataRow[] drThanhPhan = dtThanhPhan.Select("Thi=0");
foreach (DataRow dr in drThanhPhan)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString(), typeof(float));
bgc = new BandedGridColumn();
grbNhapDiem.Columns.Add(bgc);
SetColumnBandCaption(bgc, dr["KyHieu"].ToString(), dr["KQHT_ThanhPhanDiemID"].ToString(), 70, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.OptionsColumn.AllowEdit = false;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvDiem.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
}
}
private void SelectCells(BandedGridColumn column)
{
for (int i = 0; i < column.View.RowCount; i++)
{
column.View.SelectCell(i, column);
}
}
private void itemSortAZ_Click(object sender, EventArgs e)
{
BandedGridColumn Column = (sender as DevExpress.Utils.Menu.DXMenuItem).Tag as BandedGridColumn;
Column.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
GridControl.UpColnumHeaderIcon();
}
private void AddBand(string IDDM_Lops)
{
BandedGridColumn bgc;
if (IDDM_Lops.IndexOf(",") == 0)
{
IDDM_Lops = IDDM_Lops.Substring(1, IDDM_Lops.Length - 1);
}
if (IDDM_Lops.IndexOf(",") == IDDM_Lops.Length - 1)
{
IDDM_Lops = IDDM_Lops.Substring(0, IDDM_Lops.Length - 1);
}
dtThanhPhan = oBKQHT_CongThucDiem.GetDiemThi(IDDM_Lops, Program.IDNamHoc, Program.HocKy, IDDM_MonHoc);
grbThi.Columns.Clear();
if ((dtThanhPhan != null) && (dtThanhPhan.Rows.Count > 0))
{
foreach (DataRow dr in dtThanhPhan.Rows)
{
dtSinhVien.Columns.Add(dr["KQHT_ThanhPhanDiemID"].ToString(), typeof(float));
bgc = new BandedGridColumn();
grbThi.Columns.Add(bgc);
SetColumnBandCaption(bgc, dr["KyHieu"].ToString(), dr["KQHT_ThanhPhanDiemID"].ToString(), 80, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvSinhVien.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
}
}
protected object ItemByPoint(Point pt)
{
RowInfo currentRowInfo = ViewInfo.GetRowInfoByPoint(pt);
if (currentRowInfo != null)
{
GridBand band = currentRowInfo.Node[0] as GridBand;
if (band != null && !band.Visible)
{
return(band);
}
BandedGridColumn gridColumn = currentRowInfo.Node[0] as BandedGridColumn;
if (gridColumn != null && (!gridColumn.Visible || gridColumn.OwnerBand == null))
{
return(gridColumn);
}
return(null);
}
else
{
return(null);
}
}
/// <summary>
/// GridView数据项拖动管理
/// </summary>
/// <param name="gvSource">拖动的源GridView</param>
/// <param name="gvTarget">拖动的目标GridView</param>
/// <param name="callBack">当拖放完成后的回调函数，第一个参数是拖动的源数据RowIndex，第二个参数是目标RowIndex</param>
public GridViewMutilRowDragHelper(GridView gvSource, GridView gvTarget, Action <int, int, int> callBack)
{
var fieldName = "dragColumnField";
if (!gvSource.Columns.Select(x => x.FieldName).Contains(fieldName))
{
if (gvSource is BandedGridView bgv)
{
DragColumn = new BandedGridColumn();
var band = new GridBand();
band.OptionsBand.AllowMove = false;
band.OptionsBand.AllowSize = false;
band.OptionsBand.FixedWidth = true;
band.Visible = true;
band.Width = 20;
band.Fixed = FixedStyle.Left;
bgv.Bands.Insert(0, band);
band.Columns.Add(DragColumn as BandedGridColumn);
gvSource.Columns.Add(DragColumn);
}
else
{
DragColumn = new GridColumn();
DragColumn.Fixed = FixedStyle.Left;
gvSource.Columns.Insert(0, DragColumn);
}
DragColumn.Width = 20;
DragColumn.FieldName = fieldName;
DragColumn.Visible = true;
DragColumn.VisibleIndex = 0;
DragColumn.OptionsColumn.AllowSize = false;
DragColumn.OptionsColumn.AllowEdit = false;
DragColumn.OptionsColumn.ShowCaption = false;
DragColumn.OptionsColumn.FixedWidth = true;
DragColumn.OptionsColumn.AllowMove = false;
}
else
{
DragColumn = gvSource.Columns.FirstOrDefault(x => x.FieldName == fieldName);
}
this._gcSource = gvSource.GridControl;
this._gvSource = gvSource;
this._gvTarget = gvTarget;
this._gcTarget = gvTarget.GridControl;
this._callBack = callBack;
this._gvSource.SelectionChanged += GvSrc_SelectionChanged;
this._imgHelper = new DragImageHelper(gvSource);
this._timer = new Timer();
_timer.Interval = 200;
_timer.Enabled = true;
_timer.Tick += _timer_Tick;
AllowDrop = true;
AllowAutoScroll = true;
}
protected override BaseView CreateDefaultView()
{
var view = (MyBandedGridView)CreateView("MyBandedGridView");
view.Appearance.BandPanel.ForeColor = Color.DarkBlue;
view.Appearance.BandPanel.Font = new Font(new FontFamily("Tahoma"), 8.25f, FontStyle.Bold);
view.Appearance.BandPanel.TextOptions.HAlignment = HorzAlignment.Center;
view.BandPanelRowHeight = 40;
view.Appearance.ViewCaption.ForeColor = Color.Maroon;
view.Appearance.HeaderPanel.ForeColor = Color.Maroon;
view.Appearance.HeaderPanel.TextOptions.HAlignment = HorzAlignment.Center;
view.Appearance.FooterPanel.ForeColor = Color.Maroon;
view.Appearance.FooterPanel.Font = new Font(new FontFamily("Tahoma"), 8.25f, FontStyle.Bold);
view.OptionsMenu.EnableColumnMenu = false;
view.OptionsMenu.EnableFooterMenu = false;
view.OptionsMenu.EnableGroupPanelMenu = false;
view.OptionsNavigation.EnterMoveNextColumn = true;
view.OptionsPrint.AutoWidth = false;
view.OptionsPrint.PrintFooter = false;
view.OptionsPrint.PrintGroupFooter = false;
view.OptionsView.ShowAutoFilterRow = true;
view.OptionsView.ShowViewCaption = true;
view.OptionsView.ShowGroupPanel = false;
view.OptionsView.ColumnAutoWidth = false;
view.OptionsView.RowAutoHeight = true;
view.OptionsView.HeaderFilterButtonShowMode = FilterButtonShowMode.Button;
var idColumn = new BandedGridColumn
{
Caption = "Id",
FieldName = "Id"
};
idColumn.OptionsColumn.AllowEdit = false;
idColumn.OptionsColumn.ShowInCustomizationForm = false;
view.Columns.Add(idColumn);
var kodColumn = new BandedGridColumn
{
Caption = "Kod",
FieldName = "Kod",
Visible = true
};
kodColumn.OptionsColumn.AllowEdit = false;
kodColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
kodColumn.AppearanceCell.Options.UseTextOptions = true;
view.Columns.Add(kodColumn);
return(view);
}
public void AddColumnRepository(string colName, DevExpress.XtraEditors.Repository.RepositoryItem repositoryItem)
{
BandedGridColumn temp = GetGridColumn(colName);
if (temp != null)
{
temp.ColumnEdit = repositoryItem;
temp.OptionsColumn.AllowEdit = true;
}
}
private static void CreateFilterCriteria(IDynamicProperty property, BandedGridColumn column)
{
if (property.FilterCriteria == null || string.IsNullOrEmpty(property.FilterCriteria.FilterString))
{
return;
}
var filterInfo = new ColumnFilterInfo(property.FilterCriteria.FilterString);
column.FilterInfo = filterInfo;
}
public void CustomColumnTextDisplayFormat(string colName, string formatStr)
{
BandedGridColumn temp = GetGridColumn(colName);
if (temp != null)
{
temp.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
temp.DisplayFormat.FormatString = formatStr;
}
}
private void ОбновитьСтолбцыТаблицы()
{
this.данныеТаблицыИстории.BeginUpdate();
try
{
this.данныеТаблицыИстории.Bands.Clear();
this.данныеТаблицыИстории.Columns.Clear();
GridBand band = this.ДобавитьГруппуСтолбцов("Показатели", null);
this.ДобавитьСтолбец(band, "Код учреждения", "КодУчреждения", true, true);
this.ДобавитьСтолбец(band, "Элемент цепочки", "Учреждение", true, true);
this.ДобавитьСтолбец(band, "Форма", "Форма", true, true);
base.WindowState = FormWindowState.Maximized;
if (this.типПостроения == ТипПостроенияИсторииСборки.ПоСтолбцу)
{
this.данныеТаблицыИстории.OptionsView.ColumnAutoWidth = true;
this.данныеТаблицыИстории.OptionsBehavior.AutoUpdateTotalSummary = true;
this.ДобавитьСтолбец(band, "Строка / Ключевое значение", "Строка", true, true);
this.ДобавитьСтолбец(band, "Столбец", "Столбец", true, true);
this.ДобавитьСтолбецЗначения(band, "Значение", "Значение");
}
else
{
this.данныеТаблицыИстории.OptionsView.ColumnAutoWidth = false;
if (this.типПостроения == ТипПостроенияИсторииСборки.ПоСтрокеСИсточником)
{
this.данныеТаблицыИстории.OptionsView.EnableAppearanceOddRow = false;
this.данныеТаблицыИстории.OptionsView.EnableAppearanceEvenRow = false;
this.данныеТаблицыИстории.CustomDrawCell += new RowCellCustomDrawEventHandler(this.данныеТаблицыИстории_CustomDrawCell);
}
GridBand band2 = this.ДобавитьГруппуСтолбцов("Значения", null);
foreach (СтолбецМетаструктуры метаструктуры in this.списокСтолбцов.Values)
{
if (this.типПостроения == ТипПостроенияИсторииСборки.ПоСтрокеСИсточником)
{
GridBand band3 = this.ДобавитьГруппуСтолбцов("Столбец " + метаструктуры.Код, band2);
this.ДобавитьСтолбецЗначения(band3, "История", "значение_столбца_" + метаструктуры.Код);
this.ДобавитьСтолбецЗначения(band3, "Источник", "значение_столбца_источника_" + метаструктуры.Код);
BandedGridColumn column = this.ДобавитьСтолбецЗначения(band3, "Приемник", "значение_столбца_приемника_" + метаструктуры.Код);
column.OptionsColumn.AllowMerge = DefaultBoolean.True;
column.SummaryItem.SummaryType = SummaryItemType.None;
}
else
{
this.ДобавитьСтолбецЗначения(band2, "Столбец " + метаструктуры.Код, "значение_столбца_" + метаструктуры.Код);
}
}
}
}
catch (Exception exception)
{
Сообщение.ПоказатьИсключительнуюСитуацию("Ошибка построения таблицы.", exception);
}
this.данныеТаблицыИстории.EndUpdate();
}
public void UpdateColumnOption(BandedGridColumn col, GridBand Owner, bool isEditable = false, bool isFillDown = false, int rowIndex = 0)
{
if (col == null || Owner == null)
{
return;
}
col.OwnerBand = Owner;
col.OptionsColumn.AllowEdit = isEditable;
col.AutoFillDown = isFillDown;
col.RowIndex = rowIndex;
}
/// <summary>
/// Convert GridColumn to BandedGridColumn
/// </summary>
/// <param name="gridColumn">Column of GridView</param>
/// <param name="isAllowEdit">Allow column edit or not</param>
/// <returns></returns>
public BandedGridColumn ConvertToBandedColumn(GridColumn gridColumn, bool isAllowEdit)
{
BandedGridColumn bandedColumn = new BandedGridColumn();
bandedColumn.Name = gridColumn.Name;
bandedColumn.FieldName = gridColumn.FieldName;
bandedColumn.Caption = gridColumn.Caption;
bandedColumn.OptionsColumn.AllowEdit = isAllowEdit;
bandedColumn.Visible = true;
bandedColumn.Width = gridColumn.Width;
return(bandedColumn);
}
private void ThemGridBand(int i, string maThucDon)
{
GridBand grid = new GridBand();
BandedGridColumn band_DonGia = new BandedGridColumn();
BandedGridColumn band_SoLuong = new BandedGridColumn();
BandedGridColumn band_ThanhTien = new BandedGridColumn();
grid.Columns.Add(band_DonGia);
grid.Columns.Add(band_SoLuong);
grid.Columns.Add(band_ThanhTien);
bgvThucPham_PhieuCho.Bands.AddRange(new GridBand[] { grid });
bgvThucPham_PhieuCho.Columns.AddRange(new BandedGridColumn[] { band_DonGia, band_SoLuong, band_ThanhTien });
grid.Caption = gvDanhSachThucDon_PhieuCho.GetRowCellValue(i, colNhomTre_ThucDon_PhieuCho).ToString();
grid.AppearanceHeader.Font = new Font("Tahoma", 8, FontStyle.Bold);
grid.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grid.Name = "gridNhomTre_" + maThucDon;
band_DonGia.Caption = "Đơn giá";
band_DonGia.Visible = true;
band_DonGia.FieldName = "dongia_nhomtre_" + maThucDon;
band_DonGia.AppearanceHeader.Font = new Font("Tahoma", 8, FontStyle.Bold);
band_DonGia.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
band_DonGia.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
band_DonGia.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
band_DonGia.DisplayFormat.FormatString = "#,###";
band_DonGia.Width = 100;
band_SoLuong.Caption = "Số lượng";
band_SoLuong.Visible = true;
band_SoLuong.FieldName = "soluong_nhomtre_" + maThucDon;
band_SoLuong.AppearanceHeader.Font = new Font("Tahoma", 8, FontStyle.Bold);
band_SoLuong.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
band_SoLuong.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
band_SoLuong.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
band_SoLuong.DisplayFormat.FormatString = "0.00";
band_SoLuong.Width = 100;
band_ThanhTien.Caption = "Thành tiền";
band_ThanhTien.Visible = true;
band_ThanhTien.FieldName = "thanhtien_nhomtre_" + maThucDon;
band_ThanhTien.AppearanceHeader.Font = new Font("Tahoma", 8, FontStyle.Bold);
band_ThanhTien.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
band_ThanhTien.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
band_ThanhTien.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
band_ThanhTien.DisplayFormat.FormatString = "#,###";
band_ThanhTien.Width = 100;
band_ThanhTien.OptionsColumn.ReadOnly = true;
band_ThanhTien.OptionsColumn.AllowEdit = false;
}
/// <summary>
/// Create a new banded column from a grid one
/// </summary>
/// <param name="column">Given grid column</param>
/// <param name="owner">The grid band</param>
/// <param name="allowEdit">A variable indicates whether the column is editable</param>
/// <returns>The banded grid column</returns>
private BandedGridColumn CreateNewColumn(GridColumn column, GridBand owner, bool allowEdit)
{
BandedGridColumn bandedColumn = new BandedGridColumn();
bandedColumn.Name = column.Name;
bandedColumn.Caption = column.Caption;
bandedColumn.FieldName = column.FieldName;
bandedColumn.Visible = true;
bandedColumn.Width = column.Width;
bandedColumn.OptionsColumn.AllowEdit = allowEdit;
bandedColumn.OwnerBand = owner;
return(bandedColumn);
}
private void AddColumn(GridBand band, string fieldName)
{
BandedGridColumn col = new BandedGridColumn();
col.FieldName = fieldName;
col.Visible = true;
col.OptionsColumn.AllowEdit = false;
col.OptionsColumn.ReadOnly = true;
col.OptionsFilter.AllowFilter = false;
col.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gvwBase.Columns.Add(col);
col.OwnerBand = band;
}
private void pri_SetBandGridColumnStyle(BandedGridView bgv1, BandedGridColumn bgc, DataRow p_datarow)
{
bgc.Visible = true;
bgc.RowCount = 1;
bgc.OptionsFilter.AllowFilter = false;
bgc.Visible = true;
bgc.AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
bgc.OptionsColumn.ReadOnly = true;
if (p_datarow["IsGroup"].ToString().ToLower() == "true")
{
this.pri_setSumColumn(bgc);
}
this.pri_SetOrderNo(bgv1, bgc, p_datarow["OrderType"].ToString());
}
private static BandedGridColumn CreateBandedGridColumn(bool readOnly,
int rowIndex,
string caption,
string fieldName,
UnboundColumnType unboundColumnType,
SummaryItemType summaryItemType,
HorzAlignment headerAlignment,
object tag,
int?minWidth)
{
var bandedGridColumn = new BandedGridColumn();
bandedGridColumn.Caption = caption;
bandedGridColumn.DisplayFormat.FormatString = ColumnFormat;
bandedGridColumn.DisplayFormat.FormatType = FormatType.Numeric;
bandedGridColumn.FieldName = fieldName;
bandedGridColumn.Name = "col" + fieldName;
bandedGridColumn.Tag = tag;
bandedGridColumn.OptionsColumn.AllowSort = DefaultBoolean.False;
bandedGridColumn.OptionsColumn.ShowInCustomizationForm = false;
bandedGridColumn.OptionsFilter.AllowFilter = false;
bandedGridColumn.OptionsColumn.AllowEdit = !readOnly;
bandedGridColumn.OptionsColumn.ReadOnly = readOnly;
bandedGridColumn.OptionsColumn.AllowFocus = !readOnly;
bandedGridColumn.AppearanceHeader.Options.UseTextOptions = true;
bandedGridColumn.AppearanceHeader.TextOptions.HAlignment = headerAlignment;
if (minWidth.HasValue)
{
bandedGridColumn.MinWidth = minWidth.Value;
}
bandedGridColumn.RowIndex = rowIndex;
if (summaryItemType != SummaryItemType.None)
{
bandedGridColumn.Summary.AddRange(new GridSummaryItem[]
{
new GridColumnSummaryItem(summaryItemType,
fieldName,
SummaryFormat)
});
}
bandedGridColumn.Visible = true;
bandedGridColumn.UnboundType = unboundColumnType;
bandedGridColumn.Width = InitialColumnWidth;
return(bandedGridColumn);
}
private void AddBand()
{
BandedGridColumn bgc;
NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo = new NS_LoaiPhuCapInfo();
cBNS_LoaiPhuCap oBNS_LoaiPhuCap = new cBNS_LoaiPhuCap();
dtLoaiPhuCap = oBNS_LoaiPhuCap.Get(pNS_LoaiPhuCapInfo);
grbPhuCap.Columns.Clear();
if ((dtLoaiPhuCap != null) && (dtLoaiPhuCap.Rows.Count > 0))
{
foreach (DataRow dr in dtLoaiPhuCap.Rows)
{
if ("" + dr["KyHieu"] == "PCGV&YT")
{
IDPhuCapGV_YT = int.Parse(dr["NS_LoaiPhuCapID"].ToString());
}
dtGiaoVien.Columns.Add(dr["NS_LoaiPhuCapID"].ToString(), typeof(double));
bgc = new BandedGridColumn();
grbPhuCap.Columns.Add(bgc);
SetColumnBandCaption(bgc, dr["TenLoaiPhuCap"].ToString(), dr["NS_LoaiPhuCapID"].ToString(), 130, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.DisplayFormat.FormatString = "n2";
bgc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
bgc = new BandedGridColumn();
grbPhuCap.Columns.Add(bgc);
SetColumnBandCaption(bgc, "Tổng hệ số phụ cấp", "TongHeSoPhuCap", 120, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.DisplayFormat.FormatString = "n2";
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
bgc = new BandedGridColumn();
grbPhuCap.Columns.Add(bgc);
SetColumnBandCaption(bgc, "Thành tiền", "ThanhTienPhuCap", 120, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.DisplayFormat.FormatString = "n2";
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
}
public static void AddColumn(
this BandedGridView gridView,
string fieldName,
string caption,
int width,
bool isAllowEdit = false,
bool fixedWidth = true,
HorzAlignment textAlignment = HorzAlignment.Default,
RepositoryItem itemCtrl = null,
GridColumnSummaryItem summaryItem = null)
{
BandedGridColumn col = new BandedGridColumn
{
Caption = caption,
Name = fieldName,
FieldName = fieldName,
Visible = true
};
col.OptionsColumn.ShowCaption = !string.IsNullOrEmpty(caption);
if (width > 0)
{
col.Width = width;
}
col.OptionsColumn.ReadOnly = !isAllowEdit;
col.AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
col.AppearanceHeader.Options.UseTextOptions = true;
col.OptionsColumn.FixedWidth = fixedWidth;
col.OptionsColumn.AllowSize = false;
col.AppearanceCell.TextOptions.HAlignment = textAlignment;
col.AppearanceCell.Options.UseTextOptions = true;
if (itemCtrl != null)
{
col.ColumnEdit = itemCtrl;
}
// Add Summary Item
if (summaryItem != null)
{
col.Summary.Add(summaryItem);
}
gridView.Columns.Add(col);
}
private void AddBand()
{
BandedGridColumn bgc;
GridBand grbTenMon, grbSoTrinh;
dtMonHoc = oBXL_MonHocTrongKy.GetByLop(pDM_LopInfo.DM_LopID, Program.IDNamHoc, Program.HocKy);
grbMonHoc.Children.Clear();
if ((dtMonHoc != null) && (dtMonHoc.Rows.Count > 0))
{
foreach (DataRow dr in dtMonHoc.Rows)
{
// Dinh dang cua grid
// Ten mon
// SoHocTrinh
// L1 | L2
// Begin Add band TenMonHoc
grbTenMon = new GridBand();
grbTenMon.RowCount = 2;
grbTenMon.AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
grbMonHoc.Children.AddRange(new GridBand[] { grbTenMon });
// Begin Add band SoHocTrinh
grbSoTrinh = new GridBand();
grbTenMon.Children.Add(grbSoTrinh);
for (int i = 1; i <= 2; i++)
{
dtSinhVien.Columns.Add(dr["DM_MonHocID"].ToString() + "_" + i.ToString(), typeof(float));
dtColEnd++;
// Begin Add column DiemLan1
bgc = new BandedGridColumn();
grbSoTrinh.Columns.Add(bgc);
SetColumnBandCaption(bgc, "L" + i.ToString(), dr["DM_MonHocID"].ToString() + "_" + i.ToString(), 40,
DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvDiem.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
// End Add column DiemLan1
}
SetBandCaption(grbSoTrinh, dr["SoHocTrinh"].ToString(), 80);
// End Add band SoHocTrinh
SetBandCaption(grbTenMon, dr["TenMonHoc"].ToString(), 80);
// End Add band TenMonHoc
}
}
}
public frmBienMucAdvanceQL()
{
InitializeComponent();
TimKiem = new AppBienMucGridTemplate(gridViewMaster);
IDField = BIEN_MUC.BM_ID;
DisplayField = BIEN_MUC.MA_BANG;
Fix = new PhieuQuanLy10BandedFix(this);
AppCtrl.SetAutoHideEmptyBand(gridViewMaster);
BandedGridColumn colBanQuyen = new BandedGridColumn();//Cột dùng để lọc, ko hiện trên lưới
colBanQuyen.Caption = TimKiem.CotThoiHanBanQuyen.Caption;
gridViewMaster.Columns.Add(colBanQuyen);
TimKiem.gridBandNguonGoc.Columns.Add(colBanQuyen);
HelpGridColumn.CotDateEdit(colBanQuyen, BIEN_MUC.THOI_HAN_BAN_QUYEN);
BandedGridColumn colIsBanQuyen = new BandedGridColumn();//Cột dùng để lọc, ko hiện trên lưới
colIsBanQuyen.Caption = "Thời hạn bản quyền (loại)";
gridViewMaster.Columns.Add(colIsBanQuyen);
TimKiem.gridBandNguonGoc.Columns.Add(colIsBanQuyen);
AppCtrl.InitCotBanQuyen(colIsBanQuyen, BIEN_MUC.IS_THOI_HAN_BAN_QUYEN);
checkListCol = TimKiem.AddTuyBienCot(this.barManager1, MainBar, colBanQuyen,colIsBanQuyen);
AppCtrl.InitPrintGrid(this,false);
AppCtrl.FormatButtonTimKiem(this);
BarButtonItem xemtatCa = AppCtrl.AddXemTatCa(this);
xemtatCa.ItemClick += delegate(object sender, ItemClickEventArgs e)
{
popupControlContainerFilter.Visible = true;
dockPanel1.Visibility = DevExpress.XtraBars.Docking.DockVisibility.AutoHide;
dockPanel1.HideSliding();
filterControl1.SetDefaultColumn(null);
filterControl1.FilterString = null;
filterControl1.SetDefaultColumn(filterControl1.FilterColumns[BIEN_MUC.TIET_MUC]);
};
filterControl1.FilterChanged += delegate(object sender, FilterChangedEventArgs e)
{
if (e.Action == FilterChangedAction.ClearAll ||
(e.Action == FilterChangedAction.RemoveNode && filterControl1.FilterString == ""))
{
gridViewMaster.ClearColumnsFilter();
}
};
this.dockManager1.Load += new EventHandler(dockManager1_Load);
_msgConfirmBeforeDelete = "Bạn có muốn 'Xóa' biên mục đang chọn?";
_msgNotifyDeleteFail = "Thao tác 'Xóa' biên mục \"{0}\" thực hiện không thành công. Vui lòng kiểm tra lại dữ liệu.";
}
public static BandedGridColumn[] CreateBandedGridColumns(string[] Captions, bool[] Visible, params int[] Widths)
{
BandedGridColumn[] Cols = new BandedGridColumn[Captions.Length];
int VisibleIndex = -1;
for (int i = 0; i < Captions.Length; i++)
{
Cols[i] = new BandedGridColumn();
Cols[i].Caption = Captions[i];
Cols[i].Name = Captions[i];
if (Visible[i] == false) VisibleIndex = -1;
else VisibleIndex = i;
if (VisibleIndex == -1)
{
Cols[i].Visible = false;
Cols[i].OptionsColumn.AllowFocus = false;
Cols[i].OptionsColumn.ReadOnly = true;
Cols[i].OptionsColumn.AllowEdit = false;
Cols[i].Width = 0;
Cols[i].OptionsColumn.FixedWidth = true;
}
else
Cols[i].VisibleIndex = VisibleIndex;
if (Widths != null)
if (Widths[i] != -1) Cols[i].Width = Widths[i];
}
return Cols;
}
private void CreateGridViewDetail(string[] fields, string[] caption ,DateTime[]dsNgay )
{
//Làm sạch lưới
gridViewDetails.Bands.Clear();
int k = 0;
int cotphu = 0;
int SoCotPhu = 7;
string[] CotPhuField = new String[] { "N", "V", "SO", "KL", "TC", "HL","" };
#region 3.0.Các band và cột sử dụng
GridBand[] BThu = new GridBand[fields.Length / 2 + 1 + SoCotPhu];
for (k = 0; k < BThu.Length; k++)
{
BThu[k] = new GridBand();
}
GridBand[] BNgay = new GridBand[fields.Length / 2];
GridBand[] BSangChieu = new GridBand[fields.Length * 2];
BandedGridColumn[] BColumn = new BandedGridColumn[fields.Length + 1 + SoCotPhu];
for (k = 0; k < BColumn.Length; k++)
{
BColumn[k] = new BandedGridColumn();
if (k == 0)
{
BColumn[k].FieldName = "NAME";
BColumn[k].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
}
else if (k <= fields.Length)
{
BColumn[k].FieldName = fields[k - 1];
BColumn[k].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
BColumn[k].SummaryItem.DisplayFormat = "{0}";
BColumn[k].FieldName = fields[k - 1];
}
else
{
BColumn[k].FieldName = CotPhuField[cotphu];
BColumn[k].Name = CotPhuField[cotphu];
BColumn[k].OptionsColumn.ReadOnly = true;
cotphu++;
}
}
#endregion
#region 3.1.Gắn bands và cột lên lưới
gridViewDetails.Bands.AddRange(BThu);
gridViewDetails.Columns.AddRange(BColumn);
for (k = 0; k < gridViewDetails.Columns.Count; k++)
{
gridViewDetails.Columns[k].Visible = true;
gridViewDetails.Columns[k].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
#endregion
#region 3.2.Tạo các caption & band chứa band, ...
BThu[0].Columns.Add(BColumn[0]);
BThu[0].Caption = "Nhân viên";
int tt = 0;
for (int i = 1; i < BThu.Length - SoCotPhu; i++)
{
BNgay[i - 1] = new GridBand();
BThu[i].Children.Add(BNgay[i - 1]);
BSangChieu[tt] = new GridBand();
BSangChieu[tt].Caption = "Sáng";
BSangChieu[tt].Width = BSangChieu[tt].Caption.Length;
BSangChieu[tt].Columns.Add(BColumn[tt + 1]);
BNgay[i - 1].Children.Add(BSangChieu[tt++]);
BSangChieu[tt] = new GridBand();
BSangChieu[tt].Caption = "Chiều";
BSangChieu[tt].Width = BSangChieu[tt].Caption.Length;
BSangChieu[tt].Columns.Add(BColumn[tt + 1]);
BNgay[i - 1].Children.Add(BSangChieu[tt++]);
}
string[] CotPhuTen = new String[] { "Nghỉ có phép", "Nghỉ không phép", "Số ngày làm việc", "Số ngày không lương","Số ngày trợ cấp", "Số ngày hưởng lương", "" };
int col = 0;
for (k = BThu.Length - SoCotPhu; k < BThu.Length; k++)
{
BThu[k].Name = CotPhuField[col];
BThu[k].Caption = CotPhuTen[col];
BThu[k].Columns.Add(BColumn[tt + 1]);
tt++;
col++;
}
#endregion
#region 3.3.Gắn các tool lên cột
//Nut xoa
DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit rep_xoa = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
rep_xoa.Buttons.Add(new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Delete));
rep_xoa.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
BColumn[BColumn.Length - 1].ColumnEdit = rep_xoa;
rep_xoa.Buttons[0].Width = 23;
BColumn[BColumn.Length - 1].Width = 23;
BThu[BThu.Length - 1].Width = 23;
BThu[BThu.Length - 1].MinWidth = 23;
BThu[BThu.Length - 1].OptionsBand.FixedWidth = true;
BThu[BThu.Length - 1].OptionsBand.AllowSize = false;
rep_xoa.Click += new EventHandler(rep_xoa_Click);
//rep_cbb
DevExpress.XtraEditors.Repository.RepositoryItemComboBox rep_cbb = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox();
rep_cbb.Items.AddRange(new object[] {"N", "V", "4" });
for (k = 1; k <= fields.Length; k++)
{
BColumn[k].ColumnEdit = rep_cbb;
BColumn[k].MinWidth = BSangChieu[k - 1].Caption.Length;
BColumn[k].Width = 40;
}
#endregion
#region 3.4.Một số định dạng khác
BColumn[0].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Default;
BColumn[0].OptionsColumn.ReadOnly = true;
BColumn[0].OptionsColumn.AllowEdit = false;
BColumn[0].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["KL"].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["TC"].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["N"].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["V"].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["SO"].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["HL"].OptionsColumn.AllowFocus = false;
gridViewDetails.Columns["SO"].Width = 40;
gridViewDetails.Columns["SO"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridViewDetails.Columns["KL"].Width = 40;
gridViewDetails.Columns["KL"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridViewDetails.Columns["V"].Width = 40;
gridViewDetails.Columns["V"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridViewDetails.Columns["N"].Width = 40;
gridViewDetails.Columns["N"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridViewDetails.Columns["TC"].Width = 40;
gridViewDetails.Columns["TC"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridViewDetails.Columns["HL"].Width = 45;
gridViewDetails.Columns["HL"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
for (k = 2; k <= 7; k++)
{
BThu[BThu.Length - k].AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
}
BThu[0].Width = 150;
BThu[0].OptionsBand.FixedWidth = true;
BThu[0].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
BThu[BThu.Length - 1].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
for (k = BThu.Length -1 ; k>= BThu.Length - SoCotPhu; k--)
{
BThu[k].Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
}
for (k = 0; k < dsNgay.Length; k++)
{
BThu[k + 1].Caption = HelpDateExt.GetDayOfWeekVN(dsNgay[k]);
BNgay[k].Caption = dsNgay[k].ToShortDateString();
}
for (k = 0; k < BThu.Length; k++)
{
BThu[k].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
int l = 0;
for (k = 0; k < BNgay.Length; k++)
{
BNgay[k].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
BSangChieu[l++].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
BSangChieu[l++].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
gridViewDetails.OptionsView.ShowColumnHeaders = false;
#endregion
}
public static BandedGridColumn ThemCot(GridBand band, string Caption, int VisibleIndex, int Width)
{
BandedGridColumn Column = new BandedGridColumn();
Column.Caption = Caption;
Column.Name = Caption;
if (VisibleIndex != -2)
{
if (VisibleIndex == -1)
{
Column.Visible = false;
Column.OptionsColumn.AllowFocus = false;
Column.OptionsColumn.ReadOnly = true;
Column.OptionsColumn.AllowEdit = false;
Column.Width = 0;
Column.OptionsColumn.FixedWidth = true;
Column.OptionsColumn.ShowInCustomizationForm = false;
Column.OptionsColumn.AllowShowHide = false;
Column.OptionsFilter.AllowFilter = false;
}
else
Column.VisibleIndex = VisibleIndex;
}
if (Width != -1)
{
Column.Width = Width;
}
band.View.Columns.Add(Column);
band.Columns.Add(Column);
return Column;
}
public static BandedGridColumn CotPLDong(GridControl GridCtrl, BandedGridView Grid, bool isConfirmDelete)
{
DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit repositoryItemButtonEditDEL = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
repositoryItemButtonEditDEL.AutoHeight = false;
repositoryItemButtonEditDEL.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
repositoryItemButtonEditDEL.Buttons.Clear();
repositoryItemButtonEditDEL.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Delete, "", 10, true, true, false, DevExpress.Utils.HorzAlignment.Center, null, new DevExpress.Utils.KeyShortcut((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Delete)))});
repositoryItemButtonEditDEL.Name = "repositoryItemButtonEditDEL";
repositoryItemButtonEditDEL.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
// repositoryItemButtonEditDEL.KeyUp += delegate(object sender, KeyEventArgs e)
// {
// if (e.KeyData == Keys.Enter)
// Grid.DeleteRow(Grid.FocusedRowHandle);
// };
repositoryItemButtonEditDEL.Click += delegate(object sender, EventArgs e)
{
if (isConfirmDelete)
{
if (PLMessageBox.ShowConfirmMessage("Bạn có muốn xóa dòng này không ?") == DialogResult.Yes)
Grid.DeleteRow(Grid.FocusedRowHandle);
}
else
{
Grid.DeleteRow(Grid.FocusedRowHandle);
}
};
GridCtrl.RepositoryItems.Add(repositoryItemButtonEditDEL);
BandedGridColumn CotXoa = new BandedGridColumn();
CotXoa.AppearanceHeader.Options.UseTextOptions = true;
CotXoa.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
CotXoa.AppearanceCell.Options.UseTextOptions = true;
CotXoa.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
CotXoa.Caption = " ";
CotXoa.ColumnEdit = repositoryItemButtonEditDEL;
CotXoa.Name = "CotXoa";
CotXoa.OptionsColumn.AllowSize = false;
CotXoa.OptionsColumn.FixedWidth = true;
CotXoa.Visible = true;
CotXoa.VisibleIndex = 50;
CotXoa.Width = 25;
GridBand gridBand = new GridBand();
gridBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridBand.Columns.Add(CotXoa);
gridBand.MinWidth = 10;
gridBand.Name = "gridBandCotXoa";
gridBand.Caption = " ";
gridBand.OptionsBand.AllowSize = false;
gridBand.Width = 10;
Grid.Bands.Add(gridBand);
Grid.Columns.Add(CotXoa);
//Grid.Columns.Add(CotXoa);
return CotXoa;
}
public AppBienMucGridTemplate(PLBandedGridView gridViewMaster)
{
this.gridViewMaster = gridViewMaster;
#region Declare
CotMaBang = new BandedGridColumn();
CotTietMuc = new BandedGridColumn();
CotNoiDung = new BandedGridColumn();
CotSoTap = new BandedGridColumn();
CotTenTap = new BandedGridColumn();
CotTongTap = new BandedGridColumn();
CotSoBang = new BandedGridColumn();
CotLoaiBang = new BandedGridColumn();
CotThonSoLoaiBang = new BandedGridColumn();
CotPostMaster = new BandedGridColumn();
CotPopUp = new BandedGridColumn();
CotSDKCBHD = new BandedGridColumn();
CotTTDinhKem = new BandedGridColumn();
CotTuKhoa = new BandedGridColumn();
CotKHPL = new BandedGridColumn();
CotKHXK = new BandedGridColumn();
CotKe = new BandedGridColumn();
CotNgan = new BandedGridColumn();
CotTang = new BandedGridColumn();
CotSoLanPhat = new BandedGridColumn();
CotPhatLanDau = new BandedGridColumn();
CotThoiHanBanQuyen = new BandedGridColumn();
CotDonViSoHuu = new BandedGridColumn();
CotDonViCungCap = new BandedGridColumn();
CotNuoc = new BandedGridColumn();
CotDoiTuongKhanGia = new BandedGridColumn();
CotRating = new BandedGridColumn();
//CotTimeCode_Betacam_In = new BandedGridColumn();
//CotTimeCode_Beatacam_Out = new BandedGridColumn();
//CotTimeCode_Beatacam_Dur = new BandedGridColumn();
CotNgayNhap = new BandedGridColumn();
CotNguoiNhap = new BandedGridColumn();
CotPhongBan = new BandedGridColumn();
//CotTimeCode_File_In = new BandedGridColumn();
//CotTimeCode_File_Out = new BandedGridColumn();
//CotTimeCode_File_Duration = new BandedGridColumn();
CotGhiChu = new BandedGridColumn();
CotNgayMuon = new BandedGridColumn();
CotNgayTra = new BandedGridColumn();
CotDoiTuongMuon = new BandedGridColumn();
CotThongTinMuon = new BandedGridColumn();
CotNoiLuuTru = new BandedGridColumn();
CotTenGoc = new BandedGridColumn();
CotNamSX = new BandedGridColumn();
CotThoiLuong = new BandedGridColumn();
CotThanhLy = new BandedGridColumn();
gridBandThongTinChinh = new GridBand();
gridBandThongTinMuonTra = new GridBand();
gridBandNguonGoc = new GridBand();
gridBandThongTinPhatSong = new GridBand();
gridBandThongTinBetacam = new GridBand();
gridBandThongTinHD = new GridBand();
#endregion
#region Init Grid
gridViewMaster.Bands.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.GridBand[] {
this.gridBandThongTinChinh,
this.gridBandThongTinMuonTra,
this.gridBandNguonGoc,
this.gridBandThongTinPhatSong,
this.gridBandThongTinBetacam,
this.gridBandThongTinHD});
gridViewMaster.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] {
this.CotNoiDung,
this.CotTietMuc,
this.CotMaBang,
this.CotTenGoc,
this.CotSoTap,
this.CotTenTap,
this.CotTongTap,
this.CotThoiLuong,
this.CotSoBang,
this.CotLoaiBang,
this.CotThonSoLoaiBang,
this.CotPostMaster,
this.CotPopUp,
this.CotSDKCBHD,
this.CotTTDinhKem,
this.CotTuKhoa,
this.CotKHPL,
this.CotKHXK,
this.CotKe,
this.CotNgan,
this.CotTang,
this.CotSoLanPhat,
this.CotPhatLanDau,
this.CotThoiHanBanQuyen,
this.CotDonViSoHuu,
this.CotDonViCungCap,
this.CotNamSX,
this.CotNuoc,
this.CotDoiTuongKhanGia,
this.CotRating,
//this.CotTimeCode_Betacam_In,
//this.CotTimeCode_Beatacam_Out,
//this.CotTimeCode_Beatacam_Dur,
//this.CotTimeCode_File_In,
//this.CotTimeCode_File_Out,
//this.CotTimeCode_File_Duration,
this.CotNgayNhap,
this.CotNguoiNhap,
this.CotPhongBan,
this.CotGhiChu,
this.CotThanhLy,
this.CotNgayMuon,
this.CotNgayTra,
this.CotDoiTuongMuon,
this.CotThongTinMuon,
this.CotNoiLuuTru});
gridViewMaster.GroupCount = 2;
gridViewMaster.SortInfo.AddRange(new DevExpress.XtraGrid.Columns.GridColumnSortInfo[] {
new DevExpress.XtraGrid.Columns.GridColumnSortInfo(this.CotNoiDung, DevExpress.Data.ColumnSortOrder.Ascending),
new DevExpress.XtraGrid.Columns.GridColumnSortInfo(this.CotSoTap, DevExpress.Data.ColumnSortOrder.Ascending)});
CotNoiDung.GroupIndex = 0;
CotPostMaster.GroupIndex = 1;
#endregion
#region Init Column
//
// CotTenGoc
//
this.CotTenGoc.Caption = "Tên gốc";
this.CotTenGoc.Name = "CotTenGoc";
this.CotTenGoc.Width = 58;
//
// CotMaBang
//
this.CotMaBang.Caption = "Mã băng";
this.CotMaBang.Name = "CotMaBang";
this.CotMaBang.Width = 58;
//
// CotTietMuc
//
this.CotTietMuc.Caption = "Tiết mục";
this.CotTietMuc.Name = "CotTietMuc";
this.CotTietMuc.Width = 65;
//
// CotNoiDung
//
this.CotNoiDung.Caption = "Nội dung";
this.CotNoiDung.Name = "CotNoiDung";
this.CotNoiDung.Width = 67;
//
// CotSoTap
//
this.CotSoTap.Caption = "Tập số";
this.CotSoTap.Name = "CotSoTap";
this.CotSoTap.Width = 58;
//
// CotTenTap
//
this.CotTenTap.Caption = "Tên tập";
this.CotTenTap.Name = "CotTenTap";
this.CotTenTap.Width = 58;
//
// CotTongTap
//
this.CotTongTap.Caption = "Tổng tập";
this.CotTongTap.Name = "CotTongTap";
this.CotTongTap.Width = 58;
//
// CotThoiLuong
//
this.CotThoiLuong.Caption = "Thời lượng";
this.CotThoiLuong.Name = "CotThoiLuong";
this.CotThoiLuong.Width = 62;
//
// CotSoBang
//
this.CotSoBang.Caption = "Số băng";
this.CotSoBang.Name = "CotSoBang";
this.CotSoBang.Width = 58;
//
// CotLoaiBang
//
this.CotLoaiBang.Caption = "Loại lưu trữ";
this.CotLoaiBang.Name = "CotLoaiBang";
this.CotLoaiBang.Width = 67;
//
// CotThonSoLoaiBang
//
this.CotThonSoLoaiBang.Caption = "Thông số loại băng";
this.CotThonSoLoaiBang.Name = "CotThonSoLoaiBang";
this.CotThonSoLoaiBang.Width = 102;
//
// CotPostMaster
//
this.CotPostMaster.Caption = "Post/Master";
this.CotPostMaster.Name = "CotPostMaster";
this.CotPostMaster.Width = 61;
//
// CotPopUp
//
this.CotPopUp.Caption = "Pop Up";
this.CotPopUp.Name = "CotPopUp";
this.CotPopUp.Width = 58;
//
// CotKe
//
this.CotKe.Caption = "Kệ";
this.CotKe.Name = "CotKe";
this.CotKe.Width = 58;
//
// CotNgan
//
this.CotNgan.Caption = "Ngăn";
this.CotNgan.Name = "CotNgan";
this.CotNgan.Width = 58;
//
// CotTang
//
this.CotTang.Caption = "Tầng";
this.CotTang.Name = "CotTang";
this.CotTang.Width = 58;
//
// CotKHPL
//
this.CotKHPL.Caption = "KHPL";
this.CotKHPL.Name = "CotKHPL";
this.CotKHPL.ToolTip = "Ký hiệu phân loại";
this.CotKHPL.Width = 36;
//
// CotKHXK
//
this.CotKHXK.Caption = "KHXK";
this.CotKHXK.Name = "CotKHXK";
this.CotKHXK.ToolTip = "Ký hiệu xếp kho";
this.CotKHXK.Width = 37;
//
// CotTTDinhKem
//
this.CotTTDinhKem.Caption = "Thông tin đính kèm";
this.CotTTDinhKem.Name = "CotTTDinhKem";
this.CotTTDinhKem.Width = 102;
//
// CotTuKhoa
//
this.CotTuKhoa.Caption = "Từ khóa";
this.CotTuKhoa.Name = "CotTuKhoa";
this.CotTuKhoa.Width = 51;
//
// CotDoiTuongKhanGia
//
this.CotDoiTuongKhanGia.Caption = "Đối tượng khán giả";
this.CotDoiTuongKhanGia.Name = "CotDoiTuongKhanGia";
this.CotDoiTuongKhanGia.Width = 103;
//
// CotRating
//
this.CotRating.Caption = "Rating trung bình (%)";
this.CotRating.Name = "CotRating";
this.CotRating.Width = 117;
//
// CotNgayNhap
//
this.CotNgayNhap.Caption = "Ngày nhập";
this.CotNgayNhap.Name = "CotNgayNhap";
this.CotNgayNhap.Width = 64;
//
// CotNguoiNhap
//
this.CotNguoiNhap.Caption = "Người nhập";
this.CotNguoiNhap.Name = "CotNguoiNhap";
this.CotNguoiNhap.Width = 64;//
// CotPhongBan
//
this.CotPhongBan.Caption = "Phòng ban";
this.CotPhongBan.Name = "CotPhongBan";
this.CotPhongBan.Width = 64;
//
// CotGhiChu
//
this.CotGhiChu.Caption = "Ghi chú";
this.CotGhiChu.Name = "CotGhiChu";
this.CotGhiChu.Width = 58;
//
// CotNgayMuon
//
this.CotNgayMuon.Caption = "Ngày mượn";
this.CotNgayMuon.Name = "CotNgayMuon";
this.CotNgayMuon.Width = 67;
//
// CotNgayTra
//
this.CotNgayTra.Caption = "Ngày trả";
this.CotNgayTra.Name = "CotNgayTra";
this.CotNgayTra.Width = 67;
//
// CotDoiTuongMuon
//
this.CotDoiTuongMuon.Caption = "Đối tượng mượn";
this.CotDoiTuongMuon.Name = "CotDoiTuongMuon";
this.CotDoiTuongMuon.Width = 90;
//
// CotThongTinMuon
//
this.CotThongTinMuon.Caption = "Thông tin mượn";
this.CotThongTinMuon.Name = "CotThongTinMuon";
this.CotThongTinMuon.Width = 87;
//
// CotNamSX
//
this.CotNamSX.Caption = "Năm SX";
this.CotNamSX.Name = "CotNamSX";
this.CotNamSX.Width = 48;
//
// CotDonViCungCap
//
this.CotDonViCungCap.Caption = "Đơn vị cung cấp";
this.CotDonViCungCap.Name = "CotDonViCungCap";
this.CotDonViCungCap.Width = 89;
//
// CotDonViSoHuu
//
this.CotDonViSoHuu.Caption = "Đơn vị sở hữu";
this.CotDonViSoHuu.Name = "CotDonViSoHuu";
this.CotDonViSoHuu.Width = 79;
//
// CotNuoc
//
this.CotNuoc.Caption = "Nước SX";
this.CotNuoc.Name = "CotNuoc";
this.CotNuoc.ToolTip = "Nước sản xuất";
this.CotNuoc.Width = 52;
//
// CotThoiHanBangQuyen
//
this.CotThoiHanBanQuyen.Caption = "Thời hạn bản quyền";
this.CotThoiHanBanQuyen.Name = "CotThoiHanBangQuyen";
this.CotThoiHanBanQuyen.Width = 107;
//
// CotSoLanPhat
//
this.CotSoLanPhat.Caption = "Tồng số lần đã phát";
this.CotSoLanPhat.Name = "CotSoLanPhat";
this.CotSoLanPhat.Width = 107;
//
// CotPhatLanDau
//
this.CotPhatLanDau.Caption = "Ngày phát đầu tiên";
this.CotPhatLanDau.Name = "CotPhatLanDau";
this.CotPhatLanDau.ToolTip = "Những ngày phát lần đầu tương ứng trên các đài";
this.CotPhatLanDau.Width = 104;
//
// CotTimeCode_Betacam_In
////
//this.CotTimeCode_Betacam_In.Caption = "Timecode in (betacam)";
//this.CotTimeCode_Betacam_In.Name = "CotTimeCode_Betacam_In";
//this.CotTimeCode_Betacam_In.Width = 120;
////
//// CotTimeCode_Beatacam_Out
////
//this.CotTimeCode_Beatacam_Out.Caption = "Timecode out (betacam)";
//this.CotTimeCode_Beatacam_Out.Name = "CotTimeCode_Beatacam_Out";
//this.CotTimeCode_Beatacam_Out.Width = 128;
////
//// CotTimeCode_Beatacam_Dur
////
//this.CotTimeCode_Beatacam_Dur.Caption = "Timecode dur (betacam)";
//this.CotTimeCode_Beatacam_Dur.Name = "CotTimeCode_Beatacam_Dur";
//this.CotTimeCode_Beatacam_Dur.Width = 128;
////
//// CotTimeCode_File_In
////
//this.CotTimeCode_File_In.Caption = "Timecode in (file)";
//this.CotTimeCode_File_In.Name = "CotTimeCode_File_In";
//this.CotTimeCode_File_In.Width = 93;
////
//// CotTimeCode_File_Out
////
//this.CotTimeCode_File_Out.Caption = "Timecode out (file)";
//this.CotTimeCode_File_Out.Name = "CotTimeCode_File_Out";
//this.CotTimeCode_File_Out.Width = 101;
////
//// CotTimeCode_File_Duration
////
//this.CotTimeCode_File_Duration.Caption = "Timcode dur (file)";
//this.CotTimeCode_File_Duration.Name = "CotTimeCode_File_Duration";
//this.CotTimeCode_File_Duration.Width = 95;
//
// CotSDKCBHD
//
this.CotSDKCBHD.Caption = "Số ĐKCB HD";
this.CotSDKCBHD.Name = "CotSDKCBHD";
this.CotSDKCBHD.ToolTip = "Số đăng ký cá biệt ổ cứng";
this.CotSDKCBHD.Width = 71;
//
// CotNoiLuuTru
//
this.CotNoiLuuTru.Caption = "Nơi lưu trữ";
this.CotNoiLuuTru.FieldName = "CotNoiLuuTru";
this.CotNoiLuuTru.Name = "CotNoiLuuTru";
this.CotNoiLuuTru.Width = 63;
//
// CotThanhLy
//
this.CotThanhLy.Caption = "Thanh lý";
this.CotThanhLy.Name = "CotThanhLy";
#endregion
#region Init Band
//
// gridBandThongTinChinh
//
this.gridBandThongTinChinh.AppearanceHeader.Options.UseTextOptions = true;
this.gridBandThongTinChinh.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridBandThongTinChinh.Caption = "Thông tin chính";
this.gridBandThongTinChinh.Columns.Add(this.CotNoiDung);
this.gridBandThongTinChinh.Columns.Add(this.CotTenGoc);
this.gridBandThongTinChinh.Columns.Add(this.CotMaBang);
this.gridBandThongTinChinh.Columns.Add(this.CotTietMuc);
this.gridBandThongTinChinh.Columns.Add(this.CotSoTap);
this.gridBandThongTinChinh.Columns.Add(this.CotTenTap);
this.gridBandThongTinChinh.Columns.Add(this.CotTongTap);
this.gridBandThongTinChinh.Columns.Add(this.CotThoiLuong);
this.gridBandThongTinChinh.Columns.Add(this.CotSoBang);
this.gridBandThongTinChinh.Columns.Add(this.CotLoaiBang);
this.gridBandThongTinChinh.Columns.Add(this.CotThonSoLoaiBang);
this.gridBandThongTinChinh.Columns.Add(this.CotPostMaster);
this.gridBandThongTinChinh.Columns.Add(this.CotPopUp);
this.gridBandThongTinChinh.Columns.Add(this.CotKe);
this.gridBandThongTinChinh.Columns.Add(this.CotNgan);
this.gridBandThongTinChinh.Columns.Add(this.CotTang);
this.gridBandThongTinChinh.Columns.Add(this.CotKHPL);
this.gridBandThongTinChinh.Columns.Add(this.CotKHXK);
this.gridBandThongTinChinh.Columns.Add(this.CotTTDinhKem);
this.gridBandThongTinChinh.Columns.Add(this.CotTuKhoa);
this.gridBandThongTinChinh.Columns.Add(this.CotDoiTuongKhanGia);
this.gridBandThongTinChinh.Columns.Add(this.CotRating);
this.gridBandThongTinChinh.Columns.Add(this.CotNgayNhap);
this.gridBandThongTinChinh.Columns.Add(this.CotNguoiNhap);
this.gridBandThongTinChinh.Columns.Add(this.CotPhongBan);
this.gridBandThongTinChinh.Columns.Add(this.CotGhiChu);
this.gridBandThongTinChinh.Columns.Add(this.CotThanhLy);
this.gridBandThongTinChinh.Name = "gridBandThongTinChinh";
this.gridBandThongTinChinh.Width = 58;
//
// gridBandThongTinMuonTra
//
this.gridBandThongTinMuonTra.AppearanceHeader.Options.UseTextOptions = true;
this.gridBandThongTinMuonTra.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridBandThongTinMuonTra.Caption = "Thông tin mượn trả";
this.gridBandThongTinMuonTra.Columns.Add(this.CotNgayMuon);
this.gridBandThongTinMuonTra.Columns.Add(this.CotNgayTra);
this.gridBandThongTinMuonTra.Columns.Add(this.CotDoiTuongMuon);
this.gridBandThongTinMuonTra.Columns.Add(this.CotThongTinMuon);
this.gridBandThongTinMuonTra.Name = "gridBandThongTinMuonTra";
this.gridBandThongTinMuonTra.Width = 87;
//
// gridBandNguonGoc
//
this.gridBandNguonGoc.AppearanceHeader.Options.UseTextOptions = true;
this.gridBandNguonGoc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridBandNguonGoc.Caption = "Nguồn gốc";
this.gridBandNguonGoc.Columns.Add(this.CotNamSX);
this.gridBandNguonGoc.Columns.Add(this.CotDonViCungCap);
this.gridBandNguonGoc.Columns.Add(this.CotDonViSoHuu);
this.gridBandNguonGoc.Columns.Add(this.CotNuoc);
this.gridBandNguonGoc.Columns.Add(this.CotThoiHanBanQuyen);
this.gridBandNguonGoc.Name = "gridBandNguonGoc";
this.gridBandNguonGoc.Width = 52;
//
// gridBandThongTinPhatSong
//
this.gridBandThongTinPhatSong.AppearanceHeader.Options.UseTextOptions = true;
this.gridBandThongTinPhatSong.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridBandThongTinPhatSong.Caption = "Thông tin phát sóng";
this.gridBandThongTinPhatSong.Columns.Add(this.CotSoLanPhat);
this.gridBandThongTinPhatSong.Columns.Add(this.CotPhatLanDau);
this.gridBandThongTinPhatSong.Name = "gridBandThongTinPhatSong";
this.gridBandThongTinPhatSong.Width = 104;
//
// gridBandThongTinBetacam
//
this.gridBandThongTinBetacam.AppearanceHeader.Options.UseTextOptions = true;
this.gridBandThongTinBetacam.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridBandThongTinBetacam.Caption = "Thông tin Timecode";
//this.gridBandThongTinBetacam.Columns.Add(this.CotTimeCode_Betacam_In);
//this.gridBandThongTinBetacam.Columns.Add(this.CotTimeCode_Beatacam_Out);
//this.gridBandThongTinBetacam.Columns.Add(this.CotTimeCode_Beatacam_Dur);
//this.gridBandThongTinBetacam.Columns.Add(this.CotTimeCode_File_In);
//this.gridBandThongTinBetacam.Columns.Add(this.CotTimeCode_File_Out);
//this.gridBandThongTinBetacam.Columns.Add(this.CotTimeCode_File_Duration);
this.gridBandThongTinBetacam.Name = "gridBandThongTinBetacam";
this.gridBandThongTinBetacam.Width = 95;
//
// gridBandThongTinHD
//
this.gridBandThongTinHD.AppearanceHeader.Options.UseTextOptions = true;
this.gridBandThongTinHD.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.gridBandThongTinHD.Caption = "Thông tin HD (File)";
this.gridBandThongTinHD.Columns.Add(this.CotSDKCBHD);
this.gridBandThongTinHD.Columns.Add(this.CotNoiLuuTru);
this.gridBandThongTinHD.Name = "gridBandThongTinHD";
this.gridBandThongTinHD.Width = 63;
#endregion
}
private void GenColumn(DataTable dtKenh)
{
var showRtg = CheckRate.Checked;
var showNsx = CheckNsx.Checked;
var showCt = CheckCT.Checked;
foreach (DataRow row in dtKenh.Rows)
{
var kenh = row["KENH_PHAT"];
var kenhName = row["KENH_PHAT_NAME"].ToString();
var band = new GridBand
{
Name = string.Format("BandChannel{0}", kenh),
Caption = kenhName,
Tag = "C"
};
band.AppearanceHeader.Font = new System.Drawing.Font(band.AppearanceHeader.Font,
System.Drawing.FontStyle.Bold);
band.AppearanceHeader.Options.UseFont = true;
band.AppearanceHeader.Options.UseTextOptions = true;
band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
var colRate = new BandedGridColumn()
{
Name = string.Format("{0}{1}",CheckRate.Tag, kenh),
Caption = "Rtg%",
CustomizationCaption = string.Format("Rtg% {0}", kenhName),
Visible = showRtg
};
HelpGridColumn.CotCalcEdit(colRate, "RATE" + kenh, 2);
var colNsx = new BandedGridColumn()
{
Name = string.Format("{0}{1}",CheckNsx.Tag, kenh),
Caption = "NSX",
CustomizationCaption = string.Format("NSX {0}", kenhName),
Visible = showNsx
};
HelpGridColumn.CotTextLeft(colNsx, "NSX" + kenh);
var colCT = new BandedGridColumn()
{
Name = string.Format("{0}{1}",CheckCT.Tag, kenh),
Caption = "Chương trình",
CustomizationCaption = string.Format("Chương trình {0}", kenhName),
FieldName = "CT" + kenh,
Visible = showCt
};
HelpGridColumn.CotTextLeft(colCT, "CT" + kenh);
band.Columns.Add(colRate);
band.Columns.Add(colNsx);
band.Columns.Add(colCT);
gridViewDetail.Columns.AddRange(new[] {colRate, colCT, colNsx});
gridViewDetail.Bands.Add(band);
}
}
private void BuildYearlyColumns()
{
try
{
gvAbsencePlanning.BeginDataUpdate();
RemoveColumnsAndBands();
gvAbsencePlanning.OptionsView.ColumnAutoWidth = false;
for (int i = 0; i < 12; i++)
{
GridBand band = gvAbsencePlanning.Bands.AddBand(i.ToString());
band.MinWidth = 100;
band.Name = "band1_" + i;
band.OptionsBand.AllowSize = true;
band.OptionsBand.AllowMove = false;
band.OptionsBand.AllowHotTrack = false;
band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
band.Caption = MonthsName.GetName(i + 1);
band.Tag = new MonthBandInfo(i + 1);
int[] weeks = _yearwrapper.GetWeekNumbersByMonths(i + 1);
band.Width = weeks.Length * YEARLY_COLUMN_WIDTH+4;
BandedGridColumn column = null;
DateTime monday, sunday;
for (int ii = 0; ii < weeks.Length; ii++)
{
_yearwrapper.GetWeekDateRange(weeks[ii], out monday, out sunday);
column = new BandedGridColumn();
column.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.Caption = weeks[ii].ToString();
column.ToolTip = String.Format("{0} - {1}", monday.ToShortDateString(), sunday.ToShortDateString());
column.AutoFillDown = true;
column.Width = YEARLY_COLUMN_WIDTH;
column.MinWidth = YEARLY_COLUMN_WIDTH;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.ReadOnly = true;
column.OptionsFilter.AllowAutoFilter = false;
column.OptionsFilter.AllowFilter = false;
column.OptionsFilter.AllowAutoFilter = false;
column.OptionsColumn.ShowInCustomizationForm = false;
column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
column.OptionsColumn.AllowMove = false;
column.OptionsColumn.AllowSize = true;
column.Visible = true;
band.Columns.Add(column);
column.Tag = new WeekBandInfo(weeks[ii]);
column.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
column.SummaryItem.Tag = column.Tag;
}
}
}
finally
{
gvAbsencePlanning.EndDataUpdate();
}
}
private bool IsFixedColumn(BandedGridColumn column)
{
return _staticColumns.IndexOf(column) >= 0;
}
private void gvAbsencePlanning_MouseDown(object sender, MouseEventArgs e)
{
BandedGridHitInfo info = gvAbsencePlanning.CalcHitInfo(e.Location);
if (info.InColumn)
_clickedColumn = info.Column;
else
_clickedColumn = null;
if (e.Button == MouseButtons.Left && info.InColumn)
{
GridColumn column = info.Column;
if (column == gc_HWGR || column == gc_Employee)
{
column.SortMode = ColumnSortMode.DisplayText;
if (column.SortOrder == ColumnSortOrder.Ascending)
column.SortOrder = ColumnSortOrder.Descending;
else
column.SortOrder = ColumnSortOrder.Ascending;
if (column == gc_HWGR)
gvAbsencePlanning.SortInfo.ClearAndAddRange(new GridColumnSortInfo[]
{
new GridColumnSortInfo(gc_HWGR, gc_HWGR.SortOrder),
new GridColumnSortInfo(gc_Employee, gc_Employee.SortOrder)
});
else
gvAbsencePlanning.SortInfo.ClearAndAddRange(new GridColumnSortInfo[]
{
new GridColumnSortInfo(gc_Employee, gc_Employee.SortOrder),
new GridColumnSortInfo(gc_HWGR, gc_HWGR.SortOrder)
});
}
}
}
private void BuildWeeklyColumns()
{
try
{
gvAbsencePlanning.BeginDataUpdate();
RemoveColumnsAndBands();
DateTime monday = CurrentMondayDate ;
DateTime sunday = DateTimeHelper.GetSunday(monday);
BandedGridColumn column = null;
string caption;
DateTime date;
BandInfo info = null;
for (int i = 0; i < 7; i++)
{
date = monday.AddDays(i);
GridBand band = gvAbsencePlanning.Bands.AddBand(String.Format("{0}", GetLocalized(date.DayOfWeek.ToString())));
band.OptionsBand.AllowSize = true;
band.OptionsBand.AllowMove = false;
band.OptionsBand.AllowHotTrack = false;
band.AppearanceHeader.Options.UseTextOptions = true;
band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
band.Width = 100;
band.MinWidth = 50;
info = new DayBandInfo(date);
caption = GetColumnCaption(info);// String.Format("{0}\n {2}\n {1}", GetLocalized(sd.Date.DayOfWeek.ToString()), DateTimeHelper.ShortTimeRangeToStr(sd.OpenTime, sd.CloseTime), sd.Date.ToShortDateString());
column = new BandedGridColumn();
column.AppearanceHeader.Options.UseTextOptions = true;
column.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.Caption = caption;
column.ToolTip = GetLocalized(date.DayOfWeek.ToString());
column.AutoFillDown = true;
column.Width = 40;
column.MinWidth = 40;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.ReadOnly = true;
column.OptionsFilter.AllowAutoFilter = false;
column.OptionsFilter.AllowFilter = false;
column.OptionsFilter.AllowAutoFilter = false;
column.OptionsColumn.ShowInCustomizationForm = false;
column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
column.OptionsColumn.AllowMove = false;
column.Visible = true;
band.Columns.Add(column);
column.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//column.Width = 100;
column.Tag = info;
column.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
column.SummaryItem.Tag = column.Tag;
}
gvAbsencePlanning.OptionsView.ColumnAutoWidth = true;
}
finally
{
gvAbsencePlanning.EndDataUpdate();
}
}
private void BuildMonthlyColumns()
{
RemoveColumnsAndBands();
gvAbsencePlanning.BeginDataUpdate();
try
{
gvAbsencePlanning.OptionsView.ColumnAutoWidth = false;
GridBand band = gvAbsencePlanning.Bands.AddBand(Year.ToString());
band.OptionsBand.AllowSize = true;
band.OptionsBand.AllowMove = false;
band.OptionsBand.AllowHotTrack = false;
band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
band.Caption = Year.ToString();
band.Width = MONTHLY_COLUMN_WIDTH * 12;
//band.Tag = 100;
string caption;
BandedGridColumn column = null;
BandInfo info = null;
List<BandedGridColumn> columns = new List<BandedGridColumn>();
for (int i = 0; i < 12; i++)
{
info = new MonthBandInfo(i + 1);
caption = GetColumnCaption(info);
column = new BandedGridColumn();
column.AppearanceHeader.Options.UseTextOptions = true;
column.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column.AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
column.Caption = caption;
column.AutoFillDown = true;
column.Width = MONTHLY_COLUMN_WIDTH;
column.MinWidth = 40;
column.OptionsColumn.AllowEdit = false;
column.OptionsColumn.ReadOnly = true;
column.OptionsFilter.AllowAutoFilter = false;
column.OptionsFilter.AllowFilter = false;
column.OptionsFilter.AllowAutoFilter = false;
column.OptionsColumn.ShowInCustomizationForm = false;
column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
column.OptionsColumn.AllowMove = false;
column.Visible = true;
column.Tag = info;
column.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
column.SummaryItem.Tag = column.Tag;
gvAbsencePlanning.Columns.Add(column);
columns.Add(column);
band.Columns.Add(column);
}
foreach (BandedGridColumn c in columns)
c.Width = 80;
}
finally
{
gvAbsencePlanning.EndDataUpdate();
}
}
private void BuildSpotColumns()
{
foreach (var column in _spotColumns)
{
gridBandSpots.Columns.Remove(column);
advBandedGridViewSchedule.Columns.Remove(column);
}
_spotColumns.Clear();
gridBandSpots.Visible = false;
foreach (DataColumn column in _sectionContainer.SectionData.DataSource.Columns)
{
if (!column.ColumnName.Contains(ScheduleSection.ProgramSpotDataColumnNamePrefix)) continue;
var bandedGridColumn = new BandedGridColumn();
bandedGridColumn.AppearanceCell.Font = _spotColumnFont;
bandedGridColumn.AppearanceCell.Options.UseTextOptions = true;
bandedGridColumn.AppearanceCell.Options.UseFont = true;
bandedGridColumn.AppearanceCell.Options.HighPriority = true;
bandedGridColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
bandedGridColumn.AutoFillDown = true;
bandedGridColumn.Caption = column.Caption.ToUpper();
bandedGridColumn.ColumnEdit = repositoryItemSpinEditSpot;
bandedGridColumn.FieldName = column.ColumnName;
bandedGridColumn.ToolTip = column.ExtendedProperties["Tooltip"] as String;
bandedGridColumn.Tag = column.ExtendedProperties["SpotSettings"];
bandedGridColumn.OptionsColumn.FixedWidth = true;
bandedGridColumn.RowCount = 2;
bandedGridColumn.Width = 45;
bandedGridColumn.Visible = true;
bandedGridColumn.SummaryItem.FieldName = column.ColumnName;
bandedGridColumn.SummaryItem.SummaryType = SummaryItemType.Sum;
bandedGridColumn.OptionsColumn.AllowSize = false;
var isFullSpot = (Boolean)((object[])column.ExtendedProperties["SpotSettings"])[2];
if (!isFullSpot)
{
bandedGridColumn.AppearanceHeader.BackColor = Color.Red;
bandedGridColumn.AppearanceHeader.ForeColor = Color.White;
bandedGridColumn.AppearanceHeader.Options.UseBackColor = true;
bandedGridColumn.AppearanceHeader.Options.UseForeColor = true;
}
_spotColumns.Add(bandedGridColumn);
advBandedGridViewSchedule.Columns.Add(bandedGridColumn);
gridBandSpots.Columns.Add(bandedGridColumn);
}
gridBandSpots.Visible = _spotColumns.Count > 0 && _sectionContainer.SectionData.ShowSpots;
}
private void CreateGridMaster()
{
//Xóa lưới đã tạo trước đó (nếu có)
this.gridControlMaster.DataSource = null;
this.gridViewMaster.Columns.Clear();
this.gridViewMaster.Bands.Clear();
//Định nghĩa danh sách cột
List<BandedGridColumn> columns = new List<BandedGridColumn>();
GridBand bID = CreateBand("ID", 0, 10, FixedStyle.None);
BandedGridColumn cID = new BandedGridColumn();
cID.FieldName = "ID";
bID.Columns.Add(cID);
cID.VisibleIndex = 0;
columns.Add(cID);
bID.Visible = false;
GridBand bEmp = CreateBand("Nhân viên", 1, 200, FixedStyle.Left);
BandedGridColumn cEmp = new BandedGridColumn();
HelpBandedGrid.CotCombobox((GridColumn)cEmp, "DM_NHAN_VIEN", "ID", "NAME", "EMP_ID", "1=1");
bEmp.Columns.Add(cEmp);
cEmp.VisibleIndex = 1;
columns.Add(cEmp);
cEmp.OptionsColumn.AllowEdit = false;
cEmp.OptionsColumn.AllowFocus = false;
cEmp.OptionsColumn.ReadOnly = true;
GridBand bNghiCoPhep = CreateBand("Nghỉ có phép", 63, 50, FixedStyle.None);
BandedGridColumn cNghiCoPhep = new BandedGridColumn();
HelpBandedGrid.CotCalcEdit(cNghiCoPhep, "NGHI_CO_PHEP", 2);
bNghiCoPhep.Columns.Add(cNghiCoPhep);
cNghiCoPhep.VisibleIndex = 63;
columns.Add(cNghiCoPhep);
GridBand bNghiKoPhep = CreateBand("Nghỉ không phép", 64, 50, FixedStyle.None);
BandedGridColumn cNghiKoPhep = new BandedGridColumn();
HelpBandedGrid.CotCalcEdit(cNghiKoPhep, "NGHI_KHONG_PHEP", 2);
bNghiKoPhep.Columns.Add(cNghiKoPhep);
cNghiKoPhep.VisibleIndex = 64;
cNghiKoPhep.Caption = "";
columns.Add(cNghiKoPhep);
GridBand bSoNgay = CreateBand("Số ngày làm việc", 65, 50, FixedStyle.None);
BandedGridColumn cSoNgay = new BandedGridColumn();
HelpBandedGrid.CotCalcEdit(cSoNgay, "SO_NGAY_LAM_VIEC", 2);
bSoNgay.Columns.Add(cSoNgay);
cSoNgay.VisibleIndex = 65;
cSoNgay.Caption = "";
columns.Add(cSoNgay);
GridBand bKhongLuong = CreateBand("Số ngày không lương", 66, 50, FixedStyle.None);
BandedGridColumn cKhongLuong = new BandedGridColumn();
HelpBandedGrid.CotCalcEdit(cKhongLuong, "SO_NGAY_KHONG_LUONG", 2);
bKhongLuong.Columns.Add(cKhongLuong);
cKhongLuong.VisibleIndex = 66;
cKhongLuong.Caption = "";
columns.Add(cKhongLuong);
GridBand bTroCap = CreateBand("Số ngày trợ cấp", 67, 50, FixedStyle.None);
BandedGridColumn cTroCap = new BandedGridColumn();
HelpBandedGrid.CotCalcEdit(cTroCap, "SO_NGAY_TRO_CAP", 2);
bTroCap.Columns.Add(cTroCap);
cTroCap.VisibleIndex = 67;
cTroCap.Caption = "";
columns.Add(cTroCap);
GridBand bHuongLuong = CreateBand("Số ngày hưởng lương", 68, 50, FixedStyle.None);
BandedGridColumn cHuongLuong = new BandedGridColumn();
HelpBandedGrid.CotCalcEdit(cHuongLuong, "SO_NGAY_HUONG_LUONG", 2);
bHuongLuong.Columns.Add(cHuongLuong);
cHuongLuong.VisibleIndex = 68;
columns.Add(cHuongLuong);
cHuongLuong.Caption = "";
//Định nghĩa danh sách các ngày trong tháng được chọn
List<GridBand> bNgay = new List<GridBand>();
int cntIndex = 1;
//Lấy ngày đầu tiên của tháng được chọn (Tạm thời chưa có control Filter nên lấy tạm tháng hiện tại)
DateTime dateFirstMonth = HelpDate.GetStartOfMonth(dateThangNam._getMorth(), dateThangNam._getYear());
int daysInMonth = CountDateInMonth(dateThangNam._getMorth(), dateThangNam._getYear());
DevExpress.XtraEditors.Repository.RepositoryItemComboBox rep_cbb = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox();
rep_cbb.Items.AddRange(new object[] { "N", "V", "4" });
for (int i = 1; i <= daysInMonth; i++)
{
//Band thứ
GridBand bItem = new GridBand();
bItem.Caption = GetThuVN(dateFirstMonth.DayOfWeek.ToString());
bItem.Name = "N" + ((i > 9) ? i.ToString() : ("0" + i));
bItem.Width = 100;
bItem.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bItem.AppearanceHeader.Options.UseTextOptions = true;
bItem.OptionsBand.FixedWidth = true;
bItem.OptionsBand.AllowSize = false;
bNgay.Add(bItem);
//Band ngày/tháng/năm
GridBand bDate = new GridBand();
bDate.Caption = dateFirstMonth.Date.ToShortDateString();
bDate.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bDate.AppearanceHeader.Options.UseTextOptions = true;
bItem.Children.Add(bDate);
//Cột sáng, chiều
GridBand bSang = CreateBand("Sáng", 0, 50, FixedStyle.None);
BandedGridColumn cSang = new BandedGridColumn();
cSang.VisibleIndex = ++cntIndex;
cSang.FieldName = "N" + ((i > 9) ? i.ToString() : ("0" + i)) + "_SANG";
cSang.ColumnEdit = rep_cbb;
bSang.Columns.Add(cSang);
columns.Add(cSang);
GridBand bChieu = CreateBand("Chiều", 0, 50, FixedStyle.None);
BandedGridColumn cChieu = new BandedGridColumn();
cChieu.VisibleIndex = ++cntIndex;
cChieu.FieldName = "N" + ((i > 9) ? i.ToString() : ("0" + i)) + "_CHIEU";
cChieu.ColumnEdit = rep_cbb;
bChieu.Columns.Add(cChieu);
columns.Add(cChieu);
bDate.Children.Add(bSang);
bDate.Children.Add(bChieu);
//Tăng ngày lên
dateFirstMonth = dateFirstMonth.AddDays(1);
}
this.gridViewMaster.Bands.Add(bID);
this.gridViewMaster.Bands.Add(bEmp);
this.gridViewMaster.Bands.AddRange(bNgay.ToArray());
this.gridViewMaster.Bands.Add(bNghiCoPhep);
this.gridViewMaster.Bands.Add(bNghiKoPhep);
this.gridViewMaster.Bands.Add(bSoNgay);
this.gridViewMaster.Bands.Add(bKhongLuong);
this.gridViewMaster.Bands.Add(bTroCap);
this.gridViewMaster.Bands.Add(bHuongLuong);
this.gridViewMaster.Columns.AddRange(columns.ToArray());
this.gridViewMaster.OptionsView.ShowColumnHeaders = true;
}
private void BuildSpotColumns()
{
foreach (BandedGridColumn column in _spotColumns)
{
gridBandSpots.Columns.Remove(column);
advBandedGridViewSchedule.Columns.Remove(column);
}
_spotColumns.Clear();
gridBandSpots.Visible = false;
foreach (DataColumn column in _localSchedule.DataSource.Tables[BusinessClasses.Schedule.ProgramDataTableName].Columns)
{
if (column.ColumnName.Contains(BusinessClasses.Schedule.ProgramSpotDataColumnNamePrefix))
{
BandedGridColumn bandedGridColumn = new BandedGridColumn();
bandedGridColumn.AppearanceCell.Options.UseTextOptions = true;
bandedGridColumn.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandedGridColumn.AutoFillDown = true;
bandedGridColumn.Caption = column.Caption;
bandedGridColumn.ColumnEdit = this.repositoryItemSpinEditSpot;
bandedGridColumn.FieldName = column.ColumnName;
bandedGridColumn.OptionsColumn.FixedWidth = true;
bandedGridColumn.RowCount = 1;
bandedGridColumn.Visible = true;
bandedGridColumn.SummaryItem.FieldName = column.ColumnName;
bandedGridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
_spotColumns.Add(bandedGridColumn);
advBandedGridViewSchedule.Columns.Add(bandedGridColumn);
gridBandSpots.Columns.Add(bandedGridColumn);
}
}
gridBandSpots.Visible = _spotColumns.Count > 0;
advBandedGridViewSchedule.OptionsView.ShowFooter = _spotColumns.Count > 0;
}
private void CotPLDong()
{
var repositoryItemButtonEditDEL = new RepositoryItemButtonEdit
{
AutoHeight = false,
BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder
};
repositoryItemButtonEditDEL.Buttons.AddRange(new[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Delete, "", 10, true, true, false, DevExpress.Utils.HorzAlignment.Center, null, new DevExpress.Utils.KeyShortcut((Keys.Control | Keys.Delete)))});
repositoryItemButtonEditDEL.Name = "repositoryItemButtonEditDEL";
repositoryItemButtonEditDEL.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
// repositoryItemButtonEditDEL.KeyUp += delegate(object sender, KeyEventArgs e)
// {
// if (e.KeyData == Keys.Enter)
// Grid.DeleteRow(Grid.FocusedRowHandle);
// };
repositoryItemButtonEditDEL.ButtonClick += delegate
{
DataRow row = gridViewBienMuc.GetFocusedDataRow();
if (row == null) return;
string message = "Bạn có muốn xóa dòng này không ?";
if (_postMaster.IS_DELETE == "Y")
message = "Thực hiện thao tác này sẽ không thể phục hồi lại được!\nBạn có chắc là muốn xóa hẳn biên mục này?";
if (HelpMsgBox.ShowConfirmMessage(message) == DialogResult.No)
return;
if (_postMaster.IS_DELETE != "Y" && row[BIEN_MUC.BM_ID].ToString() != "")
{
row[BIEN_MUC.IS_DELETE] = "Y";
row.Table.DefaultView.RowFilter = BIEN_MUC.IS_DELETE + "<>'Y'";
}
else
{
if (_postMaster.IS_DELETE == "Y")
{
if (DABienMuc.I.Delete(HelpNumber.ParseInt64(row[BIEN_MUC.BM_ID])) == false)
HelpMsgBox.ShowNotificationMessage("Xóa biên mục không thành công!");
else gridViewBienMuc.DeleteRow(gridViewBienMuc.FocusedRowHandle);
}
else
{
gridViewBienMuc.DeleteRow(gridViewBienMuc.FocusedRowHandle);
}
}
};
gridControlBienMuc.RepositoryItems.Add(repositoryItemButtonEditDEL);
_cotXoa = new BandedGridColumn();
_cotXoa.AppearanceHeader.Options.UseTextOptions = true;
_cotXoa.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
_cotXoa.AppearanceCell.Options.UseTextOptions = true;
_cotXoa.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
_cotXoa.Caption = " ";
_cotXoa.ColumnEdit = repositoryItemButtonEditDEL;
_cotXoa.Name = "CotXoa";
_cotXoa.OptionsColumn.AllowSize = false;
_cotXoa.OptionsColumn.FixedWidth = true;
_cotXoa.Visible = true;
_cotXoa.VisibleIndex = 0;
_cotXoa.Width = 25;
var gridBand = new GridBand();
gridBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridBand.Columns.Add(_cotXoa);
gridBand.MinWidth = 10;
gridBand.Name = "gridBandCotXoa";
gridBand.Caption = " ";
gridBand.OptionsBand.AllowSize = false;
gridBand.Width = 10;
gridViewBienMuc.Bands.Add(gridBand);
gridViewBienMuc.Columns.Add(_cotXoa);
}
protected override DataTable UpdateDatasource(DataTable dtSource)
{
dtSource.DefaultView.RowFilter = "timeband='Average CPP'";
var dtAvgView = dtSource.DefaultView.ToTable().DefaultView;
dtAvgView.Sort = "cpp desc";
DataTable dtKenhPhat = dtAvgView.ToTable(true, "kenh_phat","kenh_phat_name");
dtSource.DefaultView.RowFilter = "";
var dtRpt = dtSource.DefaultView.ToTable(true,ColGroupType, ColTimeband);
dtRpt.PrimaryKey = new[] {dtRpt.Columns[ColGroupType], dtRpt.Columns[ColTimeband] };
var minDate = (DateTime)dtSource.Compute("min(ngay_phat)", "");
var maxDate = (DateTime)dtSource.Compute("max(ngay_phat)", "");
var isSameYear = minDate.Year == maxDate.Year;
foreach (DataRow rowKenhPhat in dtKenhPhat.Rows)
{
var idKenh = rowKenhPhat["kenh_phat"];
dtAvgView.RowFilter = "kenh_phat=" + idKenh;
dtAvgView.Sort = "ngay_phat asc";
var band = AddBand(rowKenhPhat["kenh_phat_name"].ToString(), idKenh);
var dtThu = dtAvgView.ToTable(true, "ngay_phat");
int index = 1;
foreach (DataRow row in dtThu.Rows)
{
var date = (DateTime) row["ngay_phat"];
dtSource.DefaultView.RowFilter = string.Format("KENH_PHAT={0} and ngay_phat='{1}'", idKenh, date);
var dtByKenhAndMonth = dtSource.DefaultView.ToTable(true,ColGroupType,ColTimeband, "CPP");
var fiedName = string.Format("CPP_{0}_{1}_{2}", idKenh, date.Year, date.Month);
dtByKenhAndMonth.Columns["CPP"].ColumnName = fiedName;
dtRpt.Merge(dtByKenhAndMonth);
var col = new BandedGridColumn()
{
Name = string.Format("Col{0}",fiedName),
Caption =string.Format("Tháng {0}{1}", date.Month, (isSameYear?"":"/"+date.Year)),
Visible = true,
VisibleIndex = index
};
col.OptionsColumn.AllowMove = false;
col.OptionsColumn.AllowSort = DefaultBoolean.False;
GridViewDetail.Columns.Add(col);
band.Columns.Add(col);
HelpGridColumn.CotCalcEdit(col, fiedName, 0);
index++;
}
}
var dss = new DataSet();
dss.Tables.Add(dtRpt);
return dtRpt;
}
private void InitData()
{
Ps_YearRange py = new Ps_YearRange();
py.Col4 = yearflag;
py.Col5 = projectUID;
IList<Ps_YearRange> li = Itop.Client.Common.Services.BaseService.GetList<Ps_YearRange>("SelectPs_YearRangeByCol5andCol4", py);
if (li.Count > 0)
{
firstyear = li[0].StartYear;
endyear = li[0].FinishYear;
}
else
{
firstyear = 2000;
endyear = 2008;
py.BeginYear = 1990;
py.FinishYear = endyear;
py.StartYear = firstyear;
py.EndYear = 2060;
py.ID = Guid.NewGuid().ToString();
Itop.Client.Common.Services.BaseService.Create<Ps_YearRange>(py);
}
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Title");
Ps_History psp_Type = new Ps_History();
psp_Type.Forecast = pstype;
psp_Type.Col4 = projectUID;
IList<Ps_History> listTypes = Common.Services.BaseService.GetList<Ps_History>("SelectPs_HistoryByForecast", psp_Type);
DataTable dataTable = Itop.Common.DataConverter.ToDataTable((IList)listTypes, typeof(Ps_History));
DataRow[] rows1 = dataTable.Select("Title like 'ȫ����õ���%'");
if (rows1.Length==0)
{
MessageBox.Show("ȱ�١�ȫ����õ����� ����,������ͳ��!");
this.Close();
return;
}
string pid = rows1[0]["ID"].ToString();
string tempTite=rows1[0]["Title"].ToString();
//ȡ�������еĵ�λ
Untis = Historytool.FindUnits(tempTite);
DataRow[] rows3 = dataTable.Select("ParentID='"+pid+"'");
if (rows3.Length==0)
{
MessageBox.Show("ȱ�١�ȫ����õ������µķ���ҵ�õ�����,������ͳ��!");
this.Close();
return;
}
int m=-1;
for (int i = firstyear; i <= endyear; i++)
{
if (!ht.ContainsValue(i))
continue;
m++;
dt.Columns.Add("y" + i, typeof(double));
dt.Columns.Add("n" + i, typeof(double));
GridBand gb = new GridBand();
gb.Caption = i + "��";
gb.AppearanceHeader.Options.UseTextOptions = true;
gb.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.bandedGridView1.Bands.Add(gb);
GridBand gb1 = new GridBand();
if (Untis.Length>0)
{
gb1.Caption = "�õ���("+Untis+")";
}
else
{
gb1.Caption = "�õ���";
}
gb1.AppearanceHeader.Options.UseTextOptions = true;
gb1.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gb.Children.Add(gb1);
GridBand gb2 = new GridBand();
gb2.Caption = "�ٷֱ�";
gb2.AppearanceHeader.Options.UseTextOptions = true;
gb2.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gb.Children.Add(gb2);
BandedGridColumn gridColumn = new BandedGridColumn();
gridColumn.Caption = i+"���õ���";
gridColumn.FieldName = "y" + i;
gridColumn.Visible = true;
gridColumn.VisibleIndex = 2*m+10;
gridColumn.DisplayFormat.FormatString = "n2";
gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridColumn.Width = 95;
gb1.Columns.Add(gridColumn);
BandedGridColumn gridColumn1 = new BandedGridColumn();
gridColumn1.Caption = i+"��ٷֱ�";
gridColumn1.FieldName = "n" + i;
gridColumn1.Visible = true;
gridColumn1.VisibleIndex = 2 * m + 11;
gridColumn1.DisplayFormat.FormatString = "n2";
gridColumn1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridColumn1.Width = 80;
gb2.Columns.Add(gridColumn1);
}
double sum = 0;
try { sum = Convert.ToDouble(rows1[0]["y" + firstyear]); }
catch { }
DataRow row1 = dt.NewRow();
row1["ID"] = Guid.NewGuid().ToString();
row1["Title"] = "�õ����ܼ�";//rows1[0]["Title"].ToString();
for (int k = 0; k < rows3.Length; k++)
{
DataRow row = dt.NewRow();
row["ID"] = Guid.NewGuid().ToString();
row["Title"] = rows3[k]["Title"].ToString();
for (int j = firstyear; j <= endyear; j++)
{
if (!ht.ContainsValue(j))
continue;
sum = 0;
try {
sum = Convert.ToDouble(rows1[0]["y" + j]); }
catch { }
row1["y" + j] = sum;
row1["n" + j] = 1;
double sum1 = 0;
double sum2 = 0;
try { sum1 = Convert.ToDouble(rows3[k]["y" + j]); }
catch { }
row["y" + j] = sum1;
if (sum != 0)
sum2 = sum1 / sum;
row["n" + j] = sum2;
}
dt.Rows.Add(row);
}
dt.Rows.Add(row1);
this.gridControl1.DataSource = dt;
}
private void CheckErrorTimeCode(DataRow row, BandedGridColumn timeCodeIn, BandedGridColumn timeCodeOut)
{
if (row[timeCodeIn.FieldName].ToString() != "" &&
(row[timeCodeOut.FieldName].ToString() == ""))
{
row.SetColumnError(timeCodeOut.FieldName, "Vui lòng vào thông tin \"" + timeCodeOut.Caption + "\"!");
}
else if (row[timeCodeIn.FieldName].ToString() == "" &&
row[timeCodeOut.FieldName].ToString() != "")
{
row.SetColumnError(timeCodeIn.FieldName, "Vui lòng vào thông tin \"" + timeCodeIn.Caption + "\"!");
}
else if (row[timeCodeIn.FieldName].ToString() != "" &&
row[timeCodeOut.FieldName].ToString() != "")
{
var tIn = new TimeCode(row[timeCodeIn.FieldName].ToString());
var tOut = new TimeCode(row[timeCodeOut.FieldName].ToString());
if (tOut < tIn)
row.SetColumnError(timeCodeOut.FieldName, "Vui lòng vào thông tin \"" + timeCodeOut.Caption + "\" lớn hơn \"" + timeCodeIn.Caption + "\"!");
}
}
