private void InitGrid()
{
gridViewDetail._SetPermissionElement(BtnPrint, BtnExport);
gridViewDetail.OptionsView.AllowHtmlDrawHeaders = true;
gridViewDetail.OptionsBehavior.CopyToClipboardWithColumnHeaders = false;
gridViewDetail.IndicatorWidth = 50;
// gridViewDetail.OptionsView.AllowCellMerge = false;
// ColTenCT.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways;
_colDong = InitGrid(gridControlDetail, gridViewDetail, IsAdd);
_colDong.Fixed = FixedStyle.Right;
foreach (GridColumn c in gridViewDetail.Columns)
{
c.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
c.AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
c.AppearanceHeader.Options.UseTextOptions = true;
c.MaxWidth = 0;
c.MinWidth = 0;
}
ColTenCT.MinWidth = 200;
ColTenCT.Width = 200;
ColGioPhat.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
AppCtrl.InitCotTime(ColGioPhat, KE_HOACH_LPS_CT.GIO_PHAT_SONG);
CotCheckEdit(ColChuNhat, KE_HOACH_LPS_CT.CN);
CotCheckEdit(ColThu2, KE_HOACH_LPS_CT.T2);
CotCheckEdit(ColThu3, KE_HOACH_LPS_CT.T3);
CotCheckEdit(ColThu4, KE_HOACH_LPS_CT.T4);
CotCheckEdit(ColThu5, KE_HOACH_LPS_CT.T5);
CotCheckEdit(ColThu6, KE_HOACH_LPS_CT.T6);
CotCheckEdit(ColThu7, KE_HOACH_LPS_CT.T7);
HelpGridColumn.CotTextLeft(ColCategory, KE_HOACH_LPS_CT.CATEGORY);
DMTietMuc.InitCot(ColTietMuc, KE_HOACH_LPS_CT.TIET_MUC, true);
HelpGridColumn.CotTextLeft(ColTenGoc, KE_HOACH_LPS_CT.TEN_GOC);
DMNuocSanXuat.InitCotMulti(ColNuocSX, KE_HOACH_LPS_CT.NUOC_SAN_XUAT, true);
HelpGridColumn.CotCalcEditDec(ColNamSX, KE_HOACH_LPS_CT.NAM_SAN_XUAT, 0, true, false).EditMask = "d";
DMPostMaster.InitCot(ColPostMaster, KE_HOACH_LPS_CT.POST_MASTER_ID);
HelpGridColumn.CotCalcEditDec(ColTongTap, KE_HOACH_LPS_CT.TONG_TAP_CT, 0, 1, true, false);
HelpGridColumn.CotCalcEditDec(ColTongTapPhat, KE_HOACH_LPS_CT.TONG_TAP, 0, 1, true, false);
AppCtrl.InitCotTimecode(ColThoiLuong, KE_HOACH_LPS_CT.THOI_LUONG, KE_HOACH_LPS_CT.THOI_LUONG_NUM);
HelpGridColumn.CotCalcEditDec(ColTapSoNgay, KE_HOACH_LPS_CT.SO_TAP_NGAY, 0, 1, false, false);
HelpGridColumn.CotDateEdit(ColNgayBatDau, KE_HOACH_LPS_CT.NGAY_BAT_DAU, false);
HelpGridColumn.CotDateEdit(ColNgayKetThuc, KE_HOACH_LPS_CT.NGAY_PHAT_CUOI, false);
HelpGridColumn.CotTextLeft(ColGhiChu, KE_HOACH_LPS_CT.GHI_CHU);
HelpGridColumn.CotDateEdit(ColExpiredate, KE_HOACH_LPS_CT.EXPIRE_DATE, false);
// HelpGridColumn.CotMemoExEdit(ColDSNgayPhat, KE_HOACH_LPS_CT.DS_NGAY_PHAT);
CotCheckEdit(ColPhatLai, KE_HOACH_LPS_CT.PHAT_LAI);
HelpGridColumn.CotTextLeft(ColMaCT, CHUONG_TRINH.MA_CT);
HelpGridColumn.CotReadOnlyDate(ColAWB, CHUONG_TRINH.NGAY_AWB);
DMDaoDien.InitCotMulti(ColDaoDien, CHUONG_TRINH.DAO_DIEN, true);
DMDienVien.InitCotMulti(ColDienVien, CHUONG_TRINH.DIEN_VIEN, true);
DMDoiTuongKG.InitCotMulti(ColDTKhanGia, CHUONG_TRINH.DOI_TUONG_KHAN_GIA, true);
HelpGridColumn.CotCalcEditDec(ColRating, CHUONG_TRINH.RATING, 0, true);
DMTuKhoa.InitCotMulti(ColTuKhoa, CHUONG_TRINH.TU_KHOA, true);
HelpGridColumn.CotTextLeft(ColKHPL, CHUONG_TRINH.KY_HIEU_PHAN_LOAI);
HelpGridColumn.CotTextLeft(ColKHXK, CHUONG_TRINH.KY_HIEU_XEP_KHO_ND);
HelpGridColumn.CotMemoExEdit(ColGhiChuCT, "GHI_CHU_CT");
DMRanking.InitCot(ColRanking, CHUONG_TRINH.RANKING, true);
CotCheckEdit(ColScript, CHUONG_TRINH.SCRIPT);
CotCheckEdit(ColPhoTo, CHUONG_TRINH.PHOTOS);
CotCheckEdit(ColTrailerGoc, CHUONG_TRINH.TRAILER_GOC);
DMBanQuyenThuoc.InitCot(ColBanQuyenThuoc, CHUONG_TRINH.BAN_QUYEN_THUOC, true);
DMDaiTruyenHinh.InitCotMulti(ColKenhHanCheBan, CHUONG_TRINH.KENH_HAN_CHE_BAN, true);
HelpGridColumn.CotTextLeft(ColCodeCT, CHUONG_TRINH.CODE_CT);
HelpGridColumn.CotTextLeft(ColCLass, CHUONG_TRINH.CLASS);
HelpGridColumn.CotTextLeft(ColNguonTrading, CHUONG_TRINH.NGUON_TRADING);
HelpGridColumn.CotMemoExEdit(ColNoteBQ, CHUONG_TRINH.NOTE_BQ);
HelpGridColumn.CotCalcEditDec(ColRunThu, CHUONG_TRINH.RUN_THU, 0, true);
DMDaiTruyenHinh.InitCotMulti(ColChanelRight, CHUONG_TRINH.CHANLE_RIGHT, true);
HelpGridColumn.CotTextLeft(ColPeriod, CHUONG_TRINH.PERIOD);
CotCheckEdit(ColIsTrongKho, CHUONG_TRINH.IS_TRONG_KHO);
CotCheckEdit(ColThanhLy, CHUONG_TRINH.IS_THANH_LY);
HelpGridColumn.CotMemoExEdit(ColMuaKem, CHUONG_TRINH.MUA_KEM);
HelpGridColumn.CotCalcEditDec(ColReleaseDay, CHUONG_TRINH.RELEASE_DAYS, 0, true);
HelpGridColumn.CotMemoExEdit(ColTomTat, CHUONG_TRINH.TOM_TAT);
DMTinhTrangBang.InitCot(ColTinhTrangBang, CHUONG_TRINH.TINH_TRANG_BANG, true);
HelpGridColumn.CotCalcEditDec(ColTongSoRun, CHUONG_TRINH.TONG_SO_RUN, 0, true);
CotCheckEdit(ColPopUp, CHUONG_TRINH_POST_MASTER.POP_UP);
DMLoaiBang.InitCot(ColLoaiLuuTru, CHUONG_TRINH_POST_MASTER.LOAI_LUU_TRU, true);
HelpGridColumn.CotCalcEditDec(ColKe, CHUONG_TRINH_POST_MASTER.KE, 0, true);
HelpGridColumn.CotCalcEditDec(ColNgan, CHUONG_TRINH_POST_MASTER.NGAN, 0, true);
HelpGridColumn.CotCalcEditDec(ColTang, CHUONG_TRINH_POST_MASTER.TANG, 0, true);
HelpGridColumn.CotReadOnlyDate(ColNgayNhapKho, CHUONG_TRINH_POST_MASTER.NGAY_NHAP_KHO);
CotCheckEdit(ColTrailerPost, CHUONG_TRINH_POST_MASTER.TRAILER_POST);
HelpGridColumn.CotCalcEditDec(ColTongBang, CHUONG_TRINH_POST_MASTER.TONG_BANG, 0, true);
CotCheckEdit(ColMoiThiTruong, CHUONG_TRINH.MOI_THI_TRUONG);
HelpGridColumn.CotTextLeft(ColPhanLoaiDrama, CHUONG_TRINH.PHAN_LOAI_DRAMA);
HelpGridColumn.CotDateEdit(ColReleaseDate, CHUONG_TRINH.RELEASE_DATE);
HelpGridColumn.CotSpinEditInt(ColReleaseRun, CHUONG_TRINH.RELEASE_RUN, true);
HelpGridColumn.CotTextLeft(ColReleaseRule, CHUONG_TRINH.RELEASE_RULE);
HelpGridColumn.CotTextLeft(ColDonViHauKy, CHUONG_TRINH.DON_VI_HAU_KY);
DMDonViCungCap.InitCot(ColDonViCungCap, CHUONG_TRINH.DON_VI_CUNG_CAP, true);
dtLoaiGhiChu = DMLoaiGhiChu.GetUsingLoaiGhiChu();
if (dtLoaiGhiChu != null)
{
foreach (DataRow row in dtLoaiGhiChu.Rows)
{
var id = row["ID"].ToString();
var alias = "ctlgc" + id;
sqlColumn += "," + alias + ".noi_dung NOI_DUNG_GC" + id;
sqlLeftJoin += " left join chuong_trinh_ghi_chu " + alias + " on KHLPSCT.ct_id=" + alias + ".ct_id and " + alias + ".loai_ghi_chu=" + id + Environment.NewLine;
var colGhiChuKhac = gridViewDetail.Columns.Add();
colGhiChuKhac.Name = "Col_CT_GhiChuKhac" + id;
colGhiChuKhac.Caption = row["NAME"].ToString();
colGhiChuKhac.OptionsColumn.ReadOnly = true;
colGhiChuKhac.OptionsColumn.AllowMerge = DefaultBoolean.False;
colGhiChuKhac.AppearanceHeader.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
colGhiChuKhac.AppearanceHeader.Options.UseTextOptions = true;
colGhiChuKhac.MaxWidth = 0;
colGhiChuKhac.MinWidth = 0;
colGhiChuKhac.Visible = true;
HelpGridColumn.CotTextLeft(colGhiChuKhac, "NOI_DUNG_GC" + id);
}
}
_repCT = InitCotTenCtrinh(ColTenCT, KE_HOACH_LPS_CT.CTPM_ID);
ColPostMaster.Visible = false;
ColTongTap.Visible = true;
gridViewDetail.OptionsCustomization.AllowColumnMoving = true;
gridViewDetail.OptionsView.NewItemRowPosition = NewItemRowPosition.Top;
gridViewDetail.DefaultNewRow += newRow;
_repCT.ButtonClick += repCT_ButtonClick;
//this.gridViewDetail.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
//new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Sum,KE_HOACH_LPS_CT.TONG_TAP, null, "(Tổng tập phát: {0})")});
// gridViewDetail.OptionsPrint.
gridViewDetail.OptionsBehavior.Editable = false;
// gridViewDetail.GroupSummary.Clear();
gridViewDetail.CustomSummaryCalculate += gridViewDetail_CustomSummaryCalculate;
summarySoTapCan = new GridGroupSummaryItem(SummaryItemType.Custom,
KE_HOACH_LPS_CT.SO_TAP_NGAY, null, "(Số tập cần: {0}") {Tag = 1};
summarySoTapPhat = new GridGroupSummaryItem(SummaryItemType.Custom,
KE_HOACH_LPS_CT.TONG_TAP, null, " Số tập phát: {0}")
{Tag = 2};
summarySoTapThieu = new GridGroupSummaryItem(SummaryItemType.Custom,
KE_HOACH_LPS_CT.TONG_TAP_CT, null, " Số tập thiếu: {0})") { Tag = 3 };
gridViewDetail.GroupSummary.Add(summarySoTapCan);
gridViewDetail.GroupSummary.Add(summarySoTapPhat);
gridViewDetail.GroupSummary.Add(summarySoTapThieu);
}
public static void InitGridView(DevExpress.XtraGrid.GridControl _GridControl, Boolean CreatSUM)
{
//BandedGridView
DevExpress.XtraGrid.Views.BandedGrid.BandedGridView _BandedGridView = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridView();
Boolean isBandedGridView = true;
try
{
_BandedGridView = _GridControl.MainView as DevExpress.XtraGrid.Views.BandedGrid.BandedGridView;
}
catch
{
isBandedGridView = false;
}
if (isBandedGridView)
{
if (!Object.Equals(_BandedGridView, null))
{
SetTheme(_BandedGridView);
if (CreatSUM)
{
_BandedGridView.GroupSummary.Clear();
for (int i = 0; i < _BandedGridView.Columns.Count; i++)
{
if (_BandedGridView.Columns[i].Visible && _BandedGridView.Columns[i].GroupIndex < 0)
{
if (!Object.Equals(_BandedGridView.GetRowCellValue(0, _BandedGridView.Columns[i]), null))
{
if (SHARED.Libraries.StringHelper.IsNumber(_BandedGridView.GetRowCellValue(0, _BandedGridView.Columns[i]).ToString()))
{
_BandedGridView.Columns[i].SummaryItem.Collection.Clear();
_BandedGridView.Columns[i].Summary.Add(DevExpress.Data.SummaryItemType.Sum, _BandedGridView.Columns[i].FieldName, "{0}");
GridGroupSummaryItem itemTop = new GridGroupSummaryItem();
itemTop.FieldName = _BandedGridView.Columns[i].FieldName;
itemTop.SummaryType = DevExpress.Data.SummaryItemType.Sum;
itemTop.DisplayFormat = "(" + _BandedGridView.Columns[i].Caption + ": {0})";
_BandedGridView.GroupSummary.Add(itemTop);
GridGroupSummaryItem itemDown = new GridGroupSummaryItem();
itemDown.FieldName = _BandedGridView.Columns[i].FieldName;
itemDown.SummaryType = DevExpress.Data.SummaryItemType.Sum;
itemDown.DisplayFormat = "{0}";
itemDown.ShowInGroupColumnFooter = _BandedGridView.Columns[i];
_BandedGridView.GroupSummary.Add(itemDown);
}
}
}
}
}
}
}
//GridView
if (_GridControl.ViewCollection.Count > 0)
{
DevExpress.XtraGrid.Views.Grid.GridView _GridView = new DevExpress.XtraGrid.Views.Grid.GridView();
_GridView = _GridControl.ViewCollection[0] as DevExpress.XtraGrid.Views.Grid.GridView;
SetTheme(_GridView);
if (CreatSUM)
{
_GridView.GroupSummary.Clear();
for (int i = 0; i < _GridView.Columns.Count; i++)
{
if (_GridView.Columns[i].Visible && _GridView.Columns[i].GroupIndex < 0)
{
if (!Object.Equals(_GridView.GetRowCellValue(0, _GridView.Columns[i]), null))
{
if (SHARED.Libraries.StringHelper.IsNumber(_GridView.GetRowCellValue(0, _GridView.Columns[i]).ToString()))
{
_GridView.Columns[i].SummaryItem.Collection.Clear();
_GridView.Columns[i].Summary.Add(DevExpress.Data.SummaryItemType.Sum, _GridView.Columns[i].FieldName, "{0}");
GridGroupSummaryItem itemTop = new GridGroupSummaryItem();
itemTop.FieldName = _GridView.Columns[i].FieldName;
itemTop.SummaryType = DevExpress.Data.SummaryItemType.Sum;
itemTop.DisplayFormat = "(" + _GridView.Columns[i].Caption + ": {0})";
_GridView.GroupSummary.Add(itemTop);
GridGroupSummaryItem itemDown = new GridGroupSummaryItem();
itemDown.FieldName = _GridView.Columns[i].FieldName;
itemDown.SummaryType = DevExpress.Data.SummaryItemType.Sum;
itemDown.DisplayFormat = "{0}";
itemDown.ShowInGroupColumnFooter = _GridView.Columns[i];
_GridView.GroupSummary.Add(itemDown);
}
}
}
}
}
}
}
public override void Sorgula()
{
if (Validate())
{
grdselect = false;
dtrapor = Transaction.Instance.ExecuteSql(Sql());
grdv.Columns.Clear();
grd.DataSource = dtrapor;
if (rbhasta.Checked)
grdv.Columns["hastaId"].Visible = false;
foreach (GridColumn item in grdv.Columns)
item.Width = 90;
grdv.ViewCaption = "Tetkik Dökümü (Bulunan Kayıt Sayısı:" + dtrapor.Rows.Count.ToString() + ")";
grdv.Columns["TetkikAdi"].Width = 250;
if (cbunite.Checked)
grdv.Columns["Unite"].Width = 160;
if (cblab.Checked)
grdv.Columns["Laboratuvar"].Width = 300;
grdv.GroupFooterShowMode = GroupFooterShowMode.VisibleAlways;
grdv.OptionsView.ShowFooter = true;
GridGroupSummaryItem item1 = new GridGroupSummaryItem();
item1.FieldName = "Adet";
item1.SummaryType = DevExpress.Data.SummaryItemType.Sum;
item1.ShowInGroupColumnFooter = grdv.Columns["Adet"];
grdv.GroupSummary.Add(item1);
grdv.Columns["Adet"].SummaryItem.FieldName = "Adet";
grdv.Columns["Adet"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
GridGroupSummaryItem item2 = new GridGroupSummaryItem();
item2.FieldName = "ToplamTutar";
item2.SummaryType = DevExpress.Data.SummaryItemType.Sum;
item2.ShowInGroupColumnFooter = grdv.Columns["ToplamTutar"];
grdv.GroupSummary.Add(item2);
grdv.Columns["ToplamTutar"].SummaryItem.FieldName = "ToplamTutar";
grdv.Columns["ToplamTutar"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdselect = true;
}
}
void FormatearFinanciamiento()
{
grid.ViewCaption = "Financiamientos";
grvFinanciera.ViewCaption = "Creditos Grupales";
if (DtCronos.Rows.Count > 0)
{
grid.Columns[0].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
grid.Columns[1].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
//grid.Columns[2].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
grid.Columns[3].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
grid.Columns[4].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
grid.Columns[5].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
grid.Columns[6].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
grid.Columns[7].Width = 200;
grid.Columns[2].Width = 150;
grid.Columns[0].DisplayFormat.FormatType = FormatType.Numeric;
grid.Columns[3].DisplayFormat.FormatType = FormatType.Numeric;
grid.Columns[3].DisplayFormat.FormatString = "$ #,##0.00";
grid.Columns[4].DisplayFormat.FormatType = FormatType.Numeric;
grid.Columns[4].DisplayFormat.FormatString = "$ #,##0.00";
grid.Columns[5].DisplayFormat.FormatType = FormatType.Numeric;
grid.Columns[5].DisplayFormat.FormatString = "$ #,##0.00";
grid.Columns[6].DisplayFormat.FormatType = FormatType.Numeric;
gpoContenedor.Text = "Historial de Pagos";
grid.Columns[1].Group();
grid.SetGroupLevelExpanded(0, true, true);
GridGroupSummaryItem item = new GridGroupSummaryItem();
item.FieldName = "Prestamo";
item.SummaryType = DevExpress.Data.SummaryItemType.Sum;
item.DisplayFormat = "Total: {0:c2}";
grid.GroupSummary.Add(item);
}
if (DtFinanciera.Rows.Count > 0)
{
gridFinanciera.DataSource = DtFinanciera;
grvFinanciera.Columns[3].DisplayFormat.FormatType = FormatType.Numeric;
grvFinanciera.Columns[3].DisplayFormat.FormatString = "$ #,##0.00";
grvFinanciera.Columns[2].DisplayFormat.FormatType = FormatType.Numeric;
grvFinanciera.Columns[2].DisplayFormat.FormatString = "$ #,##0.00";
grvFinanciera.Columns[2].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
grvFinanciera.Columns[3].AppearanceCell.TextOptions.HAlignment = HorzAlignment.Far;
// Create and setup the second summary item.
}
}
private Rectangle GetColumnBounds(GridView view, GridGroupSummaryItem item)
{
GridColumn column = view.Columns[item.FieldName];
return GetColumnBounds(column);
}
/// <summary>
/// 设置表格列属性
/// </summary>
private void SetColumns()
{
Grid.EndEdit();
gvSource.BeginUpdate();
gvSource.OptionsView.ShowFooter = cbSum.Checked;
gvSource.OptionsView.ShowGroupPanel = cbGroup.Checked;
gvSource.OptionsView.ColumnAutoWidth = cbAuto.Checked;
gvSource.OptionsCustomization.AllowFilter = cbFilter.Checked;
gvSource.OptionsView.AllowCellMerge = ckMerge.Checked;
gvSource.GroupSummary.Clear();
foreach (DataGridViewRow dvRow in Grid.Rows)
{
DevExpress.XtraGrid.Columns.GridColumn gc = gvSource.Columns.ColumnByFieldName(dvRow.Cells["F_ColumnName"].Value.ToString());
if (gc != null)
{
gc.Visible = Convert.ToBoolean(dvRow.Cells["F_Visible"].Value);
if (Convert.ToBoolean(dvRow.Cells["F_Merge"].Value) == true)
{
gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
}
else
{
gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
}
gc.Caption = dvRow.Cells["F_ColumnCaption"].Value.ToString();
if (!dvRow.Cells["F_Format"].Value.Equals(DBNull.Value))
{
gc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gc.DisplayFormat.FormatString = dvRow.Cells["F_Format"].Value.ToString();
}
switch (dvRow.Cells["F_SumType"].Value.ToString())
{
case "合计":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "统计":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
case "平均":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "最大值":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "最小值":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
case "自定义":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
break;
case "(无)":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.None;
break;
}
if (dvRow.Cells["F_FootFormat"].Value != DBNull.Value)
{
gc.SummaryItem.DisplayFormat = dvRow.Cells["F_FootFormat"].Value.ToString();
}
if (dvRow.Cells["F_GroupType"].Value.ToString() != "(无)")
{
GridGroupSummaryItem Gi = new GridGroupSummaryItem();
switch (dvRow.Cells["F_GroupType"].Value.ToString())
{
case "合计":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "统计":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
case "平均":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "最大值":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "最小值":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
case "自定义":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Custom;
break;
case "(无)":
Gi.SummaryType = DevExpress.Data.SummaryItemType.None;
break;
}
Gi.DisplayFormat = dvRow.Cells["F_GroupFormat"].Value.ToString();
Gi.ShowInGroupColumnFooterName = dvRow.Cells["F_ColumnName"].Value.ToString();
Gi.FieldName = dvRow.Cells["F_ColumnName"].Value.ToString();
gvSource.GroupSummary.Add(Gi);
}
}
}
gvSource.EndUpdate();
}
/// <summary>
/// 获取表格列属性
/// </summary>
private void GetColumns()
{
cbFilter.Checked = gvSource.OptionsCustomization.AllowFilter;
cbAuto.Checked = gvSource.OptionsView.ColumnAutoWidth;
cbGroup.Checked = gvSource.OptionsView.ShowGroupPanel;
cbSum.Checked = gvSource.OptionsView.ShowFooter;
ckMerge.Checked = gvSource.OptionsView.AllowCellMerge;
int intRow;
foreach (DevExpress.XtraGrid.Columns.GridColumn gc in gvSource.Columns)
{
if (gc.Tag != null)
{
continue;
}
if (gc.Tag == "0")
{
continue;
}
intRow = Grid.Rows.Add();
Grid.Rows[intRow].Cells["F_ColumnName"].Value = gc.FieldName;
Grid.Rows[intRow].Cells["F_ColumnCaption"].Value = gc.Caption;
Grid.Rows[intRow].Cells["F_Visible"].Value = gc.Visible;
if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True)
{
Grid.Rows[intRow].Cells["F_Merge"].Value = true;
}
else
{
Grid.Rows[intRow].Cells["F_Merge"].Value = false;
}
Grid.Rows[intRow].Cells["F_Format"].Value = gc.DisplayFormat.FormatString;
switch (gc.SummaryItem.SummaryType)
{
case DevExpress.Data.SummaryItemType.Sum:
Grid.Rows[intRow].Cells["F_SumType"].Value = "合计";
break;
case DevExpress.Data.SummaryItemType.Count:
Grid.Rows[intRow].Cells["F_SumType"].Value = "统计";
break;
case DevExpress.Data.SummaryItemType.Average:
Grid.Rows[intRow].Cells["F_SumType"].Value = "平均";
break;
case DevExpress.Data.SummaryItemType.Max:
Grid.Rows[intRow].Cells["F_SumType"].Value = "最大值";
break;
case DevExpress.Data.SummaryItemType.Min:
Grid.Rows[intRow].Cells["F_SumType"].Value = "最小值";
break;
case DevExpress.Data.SummaryItemType.Custom:
Grid.Rows[intRow].Cells["F_SumType"].Value = "自定义";
break;
case DevExpress.Data.SummaryItemType.None:
Grid.Rows[intRow].Cells["F_SumType"].Value = "(无)";
break;
}
Grid.Rows[intRow].Cells["F_FootFormat"].Value = gc.SummaryItem.DisplayFormat;
Grid.Rows[intRow].Cells["F_GroupType"].Value = "(无)";
Grid.Rows[intRow].Cells["F_GroupFormat"].Value = "";
GridGroupSummaryItem Gi = GetGroupType(gc.FieldName);
if (Gi != null)
{
switch (Gi.SummaryType)
{
case DevExpress.Data.SummaryItemType.Sum:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "合计";
break;
case DevExpress.Data.SummaryItemType.Count:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "统计";
break;
case DevExpress.Data.SummaryItemType.Average:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "平均";
break;
case DevExpress.Data.SummaryItemType.Max:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "最大值";
break;
case DevExpress.Data.SummaryItemType.Min:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "最小值";
break;
case DevExpress.Data.SummaryItemType.Custom:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "自定义";
break;
case DevExpress.Data.SummaryItemType.None:
Grid.Rows[intRow].Cells["F_GroupType"].Value = "(无)";
break;
}
Grid.Rows[intRow].Cells["F_GroupFormat"].Value = Gi.DisplayFormat;
}
}
}
/// <summary>
/// 그리드의 밴드에 컬럼을 추가한다.
/// </summary>
/// <param name="column">XGridColumn</param>
public void AddBandColumn(XGridColumn column)
{
//Caption
if (string.IsNullOrEmpty(column.Caption))
{
if (!string.IsNullOrEmpty(column.CaptionCode))
{
column.Caption = DomainUtils.GetFieldName(column.CaptionCode);
}
else
{
column.Caption = DomainUtils.GetFieldName(column.FieldName);
}
}
var bandedColumn = new BandedGridColumn()
{
Caption = column.Caption,
FieldName = column.FieldName,
UnboundType = column.ColumnType
};
bandedColumn.OptionsColumn.AllowMerge = DefaultBoolean.False;
bandedColumn.OptionsFilter.FilterPopupMode = FilterPopupMode.CheckedList;
bandedColumn.CustomizationCaption = bandedColumn.Caption;
bandedColumn.AppearanceHeader.Options.UseTextOptions = true;
bandedColumn.AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center;
bandedColumn.AppearanceCell.Options.UseTextOptions = true;
switch (column.FieldName)
{
case "ROW_NO":
case "INS_TIME":
case "INS_USER":
case "INS_USER_NAME":
case "UPD_TIME":
case "UPD_USER":
case "UPD_USER_NAME":
bandedColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
break;
default:
if (column.FieldName.EndsWith("_DATE"))
{
bandedColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;
}
else
{
bandedColumn.AppearanceCell.TextOptions.HAlignment = column.HorzAlignment;
}
break;
}
bandedColumn.DisplayFormat.FormatType =
bandedColumn.GroupFormat.FormatType = column.FormatType;
if (!string.IsNullOrEmpty(column.FormatString))
{
bandedColumn.DisplayFormat.FormatString = column.FormatString;
bandedColumn.GroupFormat.FormatString = column.FormatString;
}
if (column.RepositoryItem != null)
{
bandedColumn.ColumnEdit = column.RepositoryItem;
}
if ((column.IsSummary) &&
(MainView.GetType() == typeof(GridView) || MainView.GetType() == typeof(BandedGridView) || MainView.GetType() == typeof(AdvBandedGridView)))
{
bandedColumn.SummaryItem.SummaryType = column.SummaryItemType;
bandedColumn.SummaryItem.FieldName = column.FieldName;
if (!string.IsNullOrEmpty(column.FormatString))
{
bandedColumn.SummaryItem.DisplayFormat = string.Format("{{0:{0}}}", column.FormatString);
}
if (column.IsSummaryGroup)
{
var item = new GridGroupSummaryItem()
{
FieldName = column.FieldName,
ShowInGroupColumnFooter = bandedColumn,
ShowInGroupColumnFooterName = column.FieldName,
SummaryType = column.SummaryItemType
};
if (!string.IsNullOrEmpty(column.FormatString))
{
item.DisplayFormat = string.Format("{{0:{0}}}", column.FormatString);
}
GroupSummaryAdd(item);
bandedColumn.OptionsColumn.AllowGroup = DefaultBoolean.True;
}
}
if (column.ReadOnly || MainView.OptionsBehavior.Editable == false)
{
bandedColumn.OptionsColumn.ReadOnly = true;
bandedColumn.OptionsColumn.AllowEdit = false;
bandedColumn.OptionsColumn.AllowFocus = false;
}
else
{
bandedColumn.OptionsColumn.ReadOnly = false;
bandedColumn.OptionsColumn.AllowEdit = true;
bandedColumn.OptionsColumn.AllowFocus = true;
}
if (column.Width > 0)
{
bandedColumn.Width = column.Width;
bandedColumn.MinWidth = column.Width;
}
else
{
switch (column.FieldName)
{
case "ROW_NO":
bandedColumn.Width = 50;
bandedColumn.MinWidth = 50;
break;
case "INS_TIME":
case "UPD_TIME":
bandedColumn.Width = 150;
bandedColumn.MinWidth = 150;
break;
case "INS_USER":
case "UPD_USER":
bandedColumn.Width = 100;
bandedColumn.MinWidth = 100;
break;
case "INS_USER_NAME":
case "UPD_USER_NAME":
bandedColumn.Width = 100;
bandedColumn.MinWidth = 100;
break;
default:
if (column.FieldName.EndsWith("_DATE"))
{
bandedColumn.Width = 100;
bandedColumn.MinWidth = 100;
}
else
{
bandedColumn.BestFit();
}
break;
}
}
bandedColumn.Visible = column.Visible;
if (column.Visible)
{
bandedColumn.VisibleIndex = MainView.Columns.Count;
}
MainView.Columns.Add(bandedColumn);
}
void GenerateTable()
{
SplashScreenManager.ShowForm(typeof(WaitScreen));
if (gridControl1.DataSource != null)
{
gridControl1.DataSource = null;
}
gridControl1.DataSource = CreateColumns();
gridView1.Columns["SubsistemaTipo"].OptionsColumn.AllowEdit = false;
gridView1.Columns["SubsistemaArea"].OptionsColumn.AllowEdit = false;
gridView1.Columns["LocalTipo"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Cod1"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Cod1"].Width = 45;
gridView1.Columns["Cod2"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Cod2"].Width = 40;
gridView1.Columns["Cod3"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Cod3"].Width = 40;
gridView1.Columns["Local"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Local"].Width = 200;
//gridView1.Columns["Hab"].OptionsColumn.AllowEdit = false;
//gridView1.Columns["Coef/Area"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Coef/Num.Habitaciones"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Área Útil [m²]"].OptionsColumn.AllowEdit = false;
//gridView1.Columns["Promedio de % Base Diseño"].OptionsColumn.AllowEdit = false;
gridView1.Columns["Áreas De Cálculo [m²]"].OptionsColumn.AllowEdit = false;
RepositoryItemComboBox _repository = new RepositoryItemComboBox();
var _allPorcientos = new DB_PLANTILLA().GetAllRecords <T_Porciento_BD>();
foreach (var item in _allPorcientos)
{
_repository.Items.Add(item.Value);
}
gridView1.Columns["Promedio de % Base Diseño"].ColumnEdit = _repository;
gridView1.Columns["RoomID"].OptionsColumn.AllowEdit = false;
gridView1.Columns["RoomID"].Visible = false;
gridView1.Columns["ID"].OptionsColumn.AllowEdit = false;
gridView1.Columns["ID"].Visible = false;
gridView1.Columns["Obj. Obra"].GroupIndex = 1;
gridView1.Columns["LocalTipo"].GroupIndex = 2;
gridView1.GroupLevelStyle += (s, e) => {
if (e.Level == 0)
{
e.LevelAppearance.ForeColor = Color.WhiteSmoke;
e.LevelAppearance.BackColor = Color.Gray;
}
if (e.Level == 1)
{
e.LevelAppearance.ForeColor = Color.Black;
e.LevelAppearance.BackColor = Color.LightGray;
}
};
GridGroupSummaryItem _summaryAreaLocal = new GridGroupSummaryItem
{
FieldName = "Área Útil [m²]",
SummaryType = SummaryItemType.Sum,
DisplayFormat = "Total: {0:0.00}",
ShowInGroupColumnFooter = gridView1.Columns["Área Útil [m²]"]
};
gridView1.GroupSummary.Add(_summaryAreaLocal);
GridGroupSummaryItem _summaryAreaCalculo = new GridGroupSummaryItem
{
FieldName = "Áreas De Cálculo [m²]",
SummaryType = SummaryItemType.Sum,
DisplayFormat = "Total: {0:0.00}",
ShowInGroupColumnFooter = gridView1.Columns["Áreas De Cálculo [m²]"]
};
gridView1.GroupSummary.Add(_summaryAreaCalculo);
GridGroupSummaryItem _summaryHabitaciones = new GridGroupSummaryItem
{
FieldName = "Hab",
SummaryType = SummaryItemType.Sum,
DisplayFormat = "Total: {0}",
ShowInGroupColumnFooter = gridView1.Columns["Hab"]
};
gridView1.GroupSummary.Add(_summaryHabitaciones);
_localesByProject = new DB_BIM().GetElements <Locales_Proyecto>(x => x.Proyecto == _proyecto.Id);
foreach (var item in _localesByProject)
{
AddGridViewRow(item);
}
SplashScreenManager.CloseForm();
}
private void InitAllowanceColumn()
{
// BandedGridColumn column = null;
List <BandedGridColumn> bandedGridColumns = new List <BandedGridColumn>();
foreach (BandedGridColumn column in this.bandAllowance.Columns)
{
if ((column == this.colAllowance ? false : column != this.colTotalSalary))
{
bandedGridColumns.Add(column);
}
}
foreach (BandedGridColumn bandedGridColumn in bandedGridColumns)
{
this.gbList.Columns.Remove(bandedGridColumn);
}
List <BandedGridColumn> bandedGridColumns1 = new List <BandedGridColumn>();
foreach (BandedGridColumn column1 in this.bandTaxAllowance.Columns)
{
if ((column1 == this.colNumberDepend || column1 == this.colDependMoney || column1 == this.colTaxYourSelfMoney || column1 == this.colTaxOvertime150Money || column1 == this.colTaxOvertime200Money || column1 == this.colTaxOvertime300Money || column1 == this.colTaxOvertime195Money || column1 == this.colTaxOvertime260Money ? false : column1 != this.colTaxOvertime390Money))
{
bandedGridColumns1.Add(column1);
}
}
foreach (BandedGridColumn bandedGridColumn1 in bandedGridColumns1)
{
this.gbList.Columns.Remove(bandedGridColumn1);
}
foreach (DataRow row in (new DIC_ALLOWANCE()).GetList().Rows)
{
BandedGridColumn brown = new BandedGridColumn()
{
FieldName = row["AllowanceCode"].ToString(),
Caption = string.Concat(row["AllowanceName"].ToString().Remove(1).ToUpper(), row["AllowanceName"].ToString().Remove(0, 1).ToLower()),
ColumnEdit = this.repCalculator,
Name = string.Concat("colAllowance", row["AllowanceCode"].ToString())
};
brown.AppearanceHeader.Options.UseForeColor = true;
brown.AppearanceHeader.ForeColor = Color.Brown;
brown.AppearanceCell.Options.UseBackColor = true;
brown.AppearanceCell.BackColor = Color.Ivory;
brown.OptionsColumn.ReadOnly = true;
brown.SummaryItem.DisplayFormat = "{0:##,##0}";
brown.SummaryItem.SummaryType = SummaryItemType.Sum;
brown.Visible = true;
brown.Width = 76;
this.bandAllowance.Columns.Add(brown);
GridSummaryItem gridGroupSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, brown.FieldName, brown, "{0:##,##0}");
this.gbList.GroupSummary.Add(gridGroupSummaryItem);
brown.Width = 76;
if (bool.Parse(row["IsShowInSalaryTableList"].ToString()))
{
BandedGridColumn red = new BandedGridColumn()
{
FieldName = string.Concat("Tax", row["AllowanceCode"].ToString()),
Caption = string.Concat(row["AllowanceName"].ToString().Remove(1).ToUpper(), row["AllowanceName"].ToString().Remove(0, 1).ToLower()),
ColumnEdit = this.repCalculator,
Name = string.Concat("colTaxAllowance", row["AllowanceCode"].ToString())
};
red.AppearanceHeader.Options.UseForeColor = true;
red.AppearanceHeader.ForeColor = Color.Red;
red.AppearanceCell.Options.UseBackColor = true;
red.AppearanceCell.BackColor = Color.Ivory;
red.OptionsColumn.ReadOnly = true;
red.SummaryItem.DisplayFormat = "{0:##,##0}";
red.SummaryItem.SummaryType = SummaryItemType.Sum;
red.Visible = true;
red.Width = 76;
this.bandTaxAllowance.Columns.Add(red);
GridSummaryItem gridSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, red.FieldName, red, "{0:##,##0}");
this.gbList.GroupSummary.Add(gridSummaryItem);
red.Width = 76;
}
}
this.colEmployeeCode.Width = 65;
this.colFirstName.Width = 121;
this.colLastName.Width = 56;
this.colCoefficientSalary.Width = 54;
this.colBasicSalary.Width = 76;
this.colInsuranceSalary.Width = 76;
this.colAllowanceInsurance.Width = 76;
this.colAllowance.Width = 64;
this.colTotalSalary.Width = 76;
this.colTaxYourSelfMoney.Width = 75;
this.colNumberDepend.Width = 66;
this.colDependMoney.Width = 77;
this.colTaxOvertime150Money.Width = 75;
this.colTaxOvertime200Money.Width = 75;
this.colTaxOvertime300Money.Width = 75;
this.colTaxOvertime195Money.Width = 75;
this.colTaxOvertime260Money.Width = 75;
this.colTaxOvertime390Money.Width = 75;
}
private object CreateObject(XmlElement xmlElement, bool suspend)
{
Type type = GetTypeByName(xmlElement.Name);
if (xmlElement.Attributes["value"] != null)
{
try
{
return(Convert.ChangeType(xmlElement.Attributes["value"].InnerText, type));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
if (type == null)
{
return(null);
}
object newObj;
if (type.FullName == "System.Windows.Forms.Form")
{
newObj = this.mainPanel;
}
else if (type.FullName == "System.Windows.Forms.DataGridView")
{
GridControl grdEntity = new GridControl();
grdEntity.Name = "grdEntity";
grdEntity.Dock = DockStyle.Fill;
grdEntity.LookAndFeel.UseWindowsXPTheme = true;
XmlNode nodeTmp = xmlElement.SelectSingleNode("DataMember");
if (nodeTmp != null)
{
grdEntity.Text = nodeTmp.Attributes["value"].Value;
}
GridView viewEntity = new GridView();
viewEntity.Appearance.GroupPanel.Options.UseBackColor = true;
viewEntity.Appearance.GroupPanel.BackColor = Color.SkyBlue;
viewEntity.Appearance.GroupPanel.BackColor2 = Color.White;
viewEntity.Appearance.FocusedRow.Options.UseBackColor = true;
viewEntity.Appearance.FocusedRow.BackColor = Color.FromArgb(51, 153, 255);
viewEntity.Appearance.HideSelectionRow.Options.UseBackColor = true;
viewEntity.Appearance.HideSelectionRow.BackColor = Color.FromArgb(51, 153, 255);
viewEntity.Appearance.HideSelectionRow.Options.UseForeColor = true;
viewEntity.Appearance.HideSelectionRow.ForeColor = Color.White;
viewEntity.OptionsView.ColumnAutoWidth = false;
//viewEntity.OptionsView.ShowGroupPanel = false;
//viewEntity.OptionsCustomization.AllowFilter = false;
viewEntity.GroupPanelText = "查询结果";
viewEntity.OptionsBehavior.Editable = false;
viewEntity.GroupFooterShowMode = GroupFooterShowMode.VisibleIfExpanded;
viewEntity.OptionsView.ShowDetailButtons = false;
viewEntity.OptionsView.ShowFooter = true;
viewEntity.FocusRectStyle = DrawFocusRectStyle.None;
viewEntity.GridControl = grdEntity;
viewEntity.Name = "GirdView";
viewEntity.OptionsSelection.EnableAppearanceFocusedCell = false;
viewEntity.PaintStyleName = "WindowsXP";
viewEntity.RowHeight = 25;
viewEntity.ColumnPanelRowHeight = 30;
viewEntity.GroupFooterShowMode = GroupFooterShowMode.VisibleAlways;
GridGroupSummaryItem summaryItem;
IEnumerator enumerator = _solution.DataSetList.GetEnumerator();
SnDataSet temp = null;
while (enumerator.MoveNext())
{
temp = enumerator.Current as SnDataSet;
if (temp.DataSetID != grdEntity.Text && !string.IsNullOrEmpty(grdEntity.Text))
{
continue;
}
for (int i = 0; i < temp.FieldsList.Count; i++)
{
GridColumn gridColumn = new GridColumn();
gridColumn.FieldName = temp.FieldsList[i].FieldName;
gridColumn.Caption = temp.FieldsList[i].FieldChineseName;
gridColumn.Width = temp.FieldsList[i].DisplayWidth > 0 ? temp.FieldsList[i].DisplayWidth : 90;
if (!temp.FieldsList[i].ColumnVisible)
{
gridColumn.Visible = false;
gridColumn.VisibleIndex = -1;
}
else
{
gridColumn.VisibleIndex = i;
}
switch (temp.FieldsList[i].CalcType)
{
case "Sum":
summaryItem = new GridGroupSummaryItem();
summaryItem.FieldName = temp.FieldsList[i].FieldChineseName;
summaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
summaryItem.DisplayFormat = "合计：{0:0.00}";
summaryItem.ShowInGroupColumnFooter = gridColumn;
viewEntity.GroupSummary.Add(summaryItem);
gridColumn.SummaryItem.DisplayFormat = "合计：{0:0.00}";
gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "Average":
summaryItem = new GridGroupSummaryItem();
summaryItem.FieldName = temp.FieldsList[i].FieldChineseName;
summaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
summaryItem.DisplayFormat = "均值：{0:c2}";
summaryItem.ShowInGroupColumnFooter = gridColumn;
viewEntity.GroupSummary.Add(summaryItem);
gridColumn.SummaryItem.DisplayFormat = "均值：{0:c}";
gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "Max":
gridColumn.SummaryItem.DisplayFormat = "最大:{0:c}";
gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "Min":
gridColumn.SummaryItem.DisplayFormat = "最小:{0:c}";
gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
case "Count":
gridColumn.SummaryItem.DisplayFormat = "行数:{0:d}";
gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
default:
gridColumn.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.None;
break;
}
foreach (StyleFormat s in temp.FieldsList[i].StyleFormat)
{
DevExpress.XtraGrid.StyleFormatCondition styleFormatCondition = new DevExpress.XtraGrid.StyleFormatCondition();
styleFormatCondition.Column = gridColumn;
styleFormatCondition.Appearance.Options.UseForeColor = true;
styleFormatCondition.Appearance.Options.UseBackColor = true;
styleFormatCondition.Appearance.BackColor =
System.Drawing.Color.FromArgb(s.BackColorRed, s.BackColorGreen, s.BackColorBlue);
styleFormatCondition.Appearance.ForeColor =
System.Drawing.Color.FromArgb(s.ForeColorRed, s.ForeColorGreen, s.ForeColorBlue);
styleFormatCondition.ApplyToRow = s.ApplyToRow;
styleFormatCondition.Condition = s.Condition;
if (s.Value1 != null)
{
styleFormatCondition.Value1 = s.Value1.ToString() != "<Null>"
? GetValueByTypeName(s.Type1, s.Value1) : "<Null>";
}
if (s.Value2 != null)
{
styleFormatCondition.Value2 = s.Value2.ToString() != "<Null>"
? GetValueByTypeName(s.Type2, s.Value2) : "<Null>";
}
viewEntity.FormatConditions.Add(styleFormatCondition);
}
switch (temp.FieldsList[i].FieldType.ToUpper())
{
case "TIMESTAMP":
case "DATETIME":
gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
break;
case "DECIMAL":
if (temp.FieldsList[i].DecimalDigits == 0 && temp.FieldsList[i].DecimalDigits > 6)
{
temp.FieldsList[i].DecimalDigits = 2;
}
string tempstr = "0.";
for (int j = 0; j < temp.FieldsList[i].DecimalDigits; j++)
{
tempstr += "0";
}
gridColumn.DisplayFormat.FormatString = tempstr;
gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
break;
case "INT":
gridColumn.DisplayFormat.FormatString = "0";
gridColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
break;
}
viewEntity.Columns.Add(gridColumn);
}
if (File.Exists(FileName + grdEntity.Text + ".xml"))
{
viewEntity.RestoreLayoutFromXml(FileName + grdEntity.Text + ".xml");
}
}
grdEntity.MainView = viewEntity;
newObj = grdEntity;
_componentContainer.Add(newObj);
}
else
{
newObj = type.Assembly.CreateInstance(type.FullName);
_componentContainer.Add(newObj);
}
string componentName = null;
if (xmlElement["Name"] != null && xmlElement["Name"].Attributes["value"] != null)
{
componentName = xmlElement["Name"].Attributes["value"].InnerText;
}
bool hasSuspended = false;
if (suspend && newObj is ContainerControl)
{
hasSuspended = true;
((Control)newObj).SuspendLayout();
}
foreach (XmlNode subNode in xmlElement.ChildNodes)
{
if (subNode is XmlElement)
{
XmlElement subElement = (XmlElement)subNode;
if (subElement.Attributes["value"] != null)
{
try
{
SetValue(newObj, subElement.Name, subElement.Attributes["value"].InnerText);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
PropertyInfo propertyInfo = newObj.GetType().GetProperty(subElement.Name);
object pList = propertyInfo.GetValue(newObj, null);
if (pList is IList)
{
foreach (XmlNode node in subElement.ChildNodes)
{
if (node is XmlElement)
{
XmlElement cNode = node as XmlElement;
object collectionObj = CreateObject(cNode, false);
if (collectionObj != null)
{
try
{
((IList)pList).Add(collectionObj);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
}
}
if (_acceptButton != null && newObj is Form)
{
((Form)newObj).AcceptButton = (IButtonControl)Container.Components[_acceptButton];
_acceptButton = null;
}
if (_cancelButton != null && newObj is Form)
{
((Form)newObj).CancelButton = (IButtonControl)Container.Components[_cancelButton];
_cancelButton = null;
}
if (hasSuspended)
{
((Control)newObj).ResumeLayout(false);
}
return(newObj);
}
private void InitSalaryPlusMinus()
{
//BandedGridColumn column = null;
// DataRow row = null;
BandedGridColumn bandedGridColumn;
GridSummaryItem gridGroupSummaryItem;
BandedGridColumn blue;
GridSummaryItem gridSummaryItem;
List <BandedGridColumn> bandedGridColumns = new List <BandedGridColumn>();
foreach (BandedGridColumn column in this.bandPlusMinusBefore.Columns)
{
bandedGridColumns.Add(column);
}
foreach (BandedGridColumn bandedGridColumn1 in bandedGridColumns)
{
this.gbList.Columns.Remove(bandedGridColumn1);
}
List <BandedGridColumn> bandedGridColumns1 = new List <BandedGridColumn>();
foreach (BandedGridColumn column1 in this.bandPlusMinusAfter.Columns)
{
bandedGridColumns1.Add(column1);
}
foreach (BandedGridColumn bandedGridColumn2 in bandedGridColumns1)
{
this.gbList.Columns.Remove(bandedGridColumn2);
}
if (!(this.m_SalaryTableListID == Guid.Empty))
{
HRM_SALARY_DEDUCTION hRMSALARYDEDUCTION = new HRM_SALARY_DEDUCTION();
DataTable list = hRMSALARYDEDUCTION.GetList(this.m_SalaryTableListID, true);
foreach (DataRow row in list.Rows)
{
bandedGridColumn = new BandedGridColumn()
{
FieldName = string.Concat("Deduction", row["DeductionCode"].ToString()),
Caption = string.Concat(row["DeductionName"].ToString().Remove(1).ToUpper(), row["DeductionName"].ToString().Remove(0, 1).ToLower()),
ColumnEdit = this.repCalculator,
Name = string.Concat("colDeductionCode", row["DeductionCode"].ToString())
};
bandedGridColumn.AppearanceHeader.Options.UseForeColor = true;
bandedGridColumn.AppearanceHeader.ForeColor = Color.Blue;
bandedGridColumn.AppearanceCell.Options.UseBackColor = true;
bandedGridColumn.AppearanceCell.BackColor = Color.Azure;
bandedGridColumn.OptionsColumn.ReadOnly = true;
bandedGridColumn.SummaryItem.DisplayFormat = "{0:##,##0}";
bandedGridColumn.SummaryItem.SummaryType = SummaryItemType.Sum;
bandedGridColumn.Visible = true;
bandedGridColumn.Width = 76;
this.bandPlusMinusBefore.Columns.Add(bandedGridColumn);
gridGroupSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, bandedGridColumn.FieldName, bandedGridColumn, "{0:##,##0}");
this.gbList.GroupSummary.Add(gridGroupSummaryItem);
bandedGridColumn.Width = 76;
}
HRM_SALARY_INCOME hRMSALARYINCOME = new HRM_SALARY_INCOME();
DataTable dataTable = hRMSALARYINCOME.GetList(this.m_SalaryTableListID, true);
if (dataTable.Rows.Count + list.Rows.Count <= 0)
{
this.bandPlusMinusBefore.Visible = false;
}
foreach (DataRow dataRow in dataTable.Rows)
{
blue = new BandedGridColumn()
{
FieldName = string.Concat("Income", dataRow["IncomeCode"].ToString()),
Caption = string.Concat(dataRow["IncomeName"].ToString().Remove(1).ToUpper(), dataRow["IncomeName"].ToString().Remove(0, 1).ToLower()),
ColumnEdit = this.repCalculator,
Name = string.Concat("colIncomeCode", dataRow["IncomeCode"].ToString())
};
blue.AppearanceHeader.Options.UseForeColor = true;
blue.AppearanceHeader.ForeColor = Color.Blue;
blue.AppearanceCell.Options.UseBackColor = true;
blue.AppearanceCell.BackColor = Color.Azure;
blue.OptionsColumn.ReadOnly = true;
blue.SummaryItem.DisplayFormat = "{0:##,##0}";
blue.SummaryItem.SummaryType = SummaryItemType.Sum;
blue.Visible = true;
blue.Width = 76;
this.bandPlusMinusBefore.Columns.Add(blue);
gridSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, blue.FieldName, blue, "{0:##,##0}");
this.gbList.GroupSummary.Add(gridSummaryItem);
blue.Width = 76;
}
list = hRMSALARYDEDUCTION.GetList(this.m_SalaryTableListID, false);
foreach (DataRow row1 in list.Rows)
{
bandedGridColumn = new BandedGridColumn()
{
FieldName = string.Concat("Deduction", row1["DeductionCode"].ToString()),
Caption = string.Concat(row1["DeductionName"].ToString().Remove(1).ToUpper(), row1["DeductionName"].ToString().Remove(0, 1).ToLower()),
ColumnEdit = this.repCalculator,
Name = string.Concat("colDeductionCode", row1["DeductionCode"].ToString())
};
bandedGridColumn.AppearanceHeader.Options.UseForeColor = true;
bandedGridColumn.AppearanceHeader.ForeColor = Color.Blue;
bandedGridColumn.AppearanceCell.Options.UseBackColor = true;
bandedGridColumn.AppearanceCell.BackColor = Color.Azure;
bandedGridColumn.OptionsColumn.ReadOnly = true;
bandedGridColumn.SummaryItem.DisplayFormat = "{0:##,##0}";
bandedGridColumn.SummaryItem.SummaryType = SummaryItemType.Sum;
bandedGridColumn.Visible = true;
bandedGridColumn.Width = 76;
this.bandPlusMinusAfter.Columns.Add(bandedGridColumn);
gridGroupSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, bandedGridColumn.FieldName, bandedGridColumn, "{0:##,##0}");
this.gbList.GroupSummary.Add(gridGroupSummaryItem);
bandedGridColumn.Width = 76;
}
dataTable = hRMSALARYINCOME.GetList(this.m_SalaryTableListID, false);
if (dataTable.Rows.Count + list.Rows.Count <= 0)
{
this.bandPlusMinusAfter.Visible = false;
}
foreach (DataRow dataRow1 in dataTable.Rows)
{
blue = new BandedGridColumn()
{
FieldName = string.Concat("Income", dataRow1["IncomeCode"].ToString()),
Caption = string.Concat(dataRow1["IncomeName"].ToString().Remove(1).ToUpper(), dataRow1["IncomeName"].ToString().Remove(0, 1).ToLower()),
ColumnEdit = this.repCalculator,
Name = string.Concat("colIncomeCode", dataRow1["IncomeCode"].ToString())
};
blue.AppearanceHeader.Options.UseForeColor = true;
blue.AppearanceHeader.ForeColor = Color.Blue;
blue.AppearanceCell.Options.UseBackColor = true;
blue.AppearanceCell.BackColor = Color.Azure;
blue.OptionsColumn.ReadOnly = true;
blue.SummaryItem.DisplayFormat = "{0:##,##0}";
blue.SummaryItem.SummaryType = SummaryItemType.Sum;
blue.Visible = true;
blue.Width = 76;
this.bandPlusMinusAfter.Columns.Add(blue);
gridSummaryItem = new GridGroupSummaryItem(SummaryItemType.Sum, blue.FieldName, blue, "{0:##,##0}");
this.gbList.GroupSummary.Add(gridSummaryItem);
blue.Width = 76;
}
this.colEmployeeCode.Width = 65;
this.colFirstName.Width = 121;
this.colLastName.Width = 56;
this.colCoefficientSalary.Width = 54;
this.colBasicSalary.Width = 76;
this.colInsuranceSalary.Width = 76;
this.colAllowanceInsurance.Width = 76;
this.colAllowance.Width = 64;
this.colTotalSalary.Width = 76;
this.colTaxYourSelfMoney.Width = 75;
this.colNumberDepend.Width = 66;
this.colDependMoney.Width = 77;
this.colTaxOvertime150Money.Width = 75;
this.colTaxOvertime200Money.Width = 75;
this.colTaxOvertime300Money.Width = 75;
this.colTaxOvertime195Money.Width = 75;
this.colTaxOvertime260Money.Width = 75;
this.colTaxOvertime390Money.Width = 75;
}
}
protected override void AssignField()
{
DevExpress.XtraGrid.Views.Grid.GridView gvFormat = null;
switch (intIndex)
{
case -1:
gvFormat = gvReport;
break;
case 1:
gvFormat = gvStockIn;
break;
case 2:
gvFormat = gvPay;
break;
case 3:
gvFormat = gvStockBack;
break;
case 4:
gvFormat = gvStockIn;
break;
case 5:
gvFormat = gvPay;
break;
case 6:
gvFormat = gvStockBack;
break;
}
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "' order by F_Order");
DataTable dtGroup = ds.Tables[0];
if (ds.Tables[0].Rows.Count == 0)
{
return;
}
gvFormat.GroupSummary.Clear();
foreach (GridColumn gc in gvFormat.Columns)
{
DataRow[] drTmp = dtGroup.Select("F_Field = '" + gc.FieldName + "'");
if (drTmp.Length > 0)
{
DataRow dr = drTmp[0];
gc.Caption = dr["F_Caption"].ToString();
gc.Width = Convert.ToInt32(dr["F_Width"]);
gc.Visible = Convert.ToBoolean(dr["F_Visible"]);
gc.VisibleIndex = Convert.ToInt32(dr["F_Order"]);
if (dr["F_Format"].ToString().Length > 0)
{
gc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
gc.DisplayFormat.FormatString = dr["F_Format"].ToString();
}
switch (dr["F_SumType"].ToString())
{
case "sum":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "avg":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "count":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
case "max":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "min":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
}
if (dr["F_FootFormat"].ToString().Length > 0)
{
gc.SummaryItem.DisplayFormat = dr["F_FootFormat"].ToString();
}
if (Convert.ToBoolean(dr["F_Edit"]) == false)
{
//gc.AppearanceCell.BackColor = System.Drawing.Color.FromArgb(192, 255, 192);
gc.OptionsColumn.AllowFocus = false;
gc.OptionsColumn.AllowEdit = false;
}
if (Convert.ToBoolean(dr["F_Merge"]) == true)
{
gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
}
else
{
gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
}
gc.AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
gc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (gc.FieldName == "Aid")
{
gc.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
gc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
if (dr["F_GroupType"].ToString().Length > 0)
{
GridGroupSummaryItem Gi = new GridGroupSummaryItem();
switch (dr["F_GroupType"].ToString())
{
case "sum":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "avg":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "count":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
case "max":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "min":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
}
Gi.FieldName = dr["F_Field"].ToString();
Gi.ShowInGroupColumnFooterName = dr["F_Field"].ToString();
Gi.DisplayFormat = dr["F_GroupFormat"].ToString();
//Gi.ShowInGroupColumnFooter = gc;
gvFormat.GroupSummary.Add(Gi);
}
}
}
}
protected override void SaveFieldFormat()
{
string strSumType = "";
DataRow drColumn;
DevExpress.XtraGrid.Views.Grid.GridView gvFormat = null;
switch (intIndex)
{
case -1:
gvFormat = gvReport;
break;
case 1:
gvFormat = gvStockIn;
break;
case 2:
gvFormat = gvPay;
break;
case 3:
gvFormat = gvStockBack;
break;
case 4:
gvFormat = gvStockIn;
break;
case 5:
gvFormat = gvPay;
break;
case 6:
gvFormat = gvStockBack;
break;
}
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "'");
foreach (GridColumn gc in gvFormat.Columns)
{
string strField = gc.FieldName;
string strCapiton = gc.Caption;
int intWith = gc.Width;
bool blnVisible = gc.Visible;
drColumn = ds.Tables[0].NewRow();
drColumn["F_Class"] = ReportTag;
drColumn["F_Tag"] = intIndex;
drColumn["F_Field"] = gc.FieldName;
drColumn["F_Caption"] = strCapiton;
drColumn["F_Width"] = intWith;
drColumn["F_Visible"] = blnVisible;
drColumn["F_Edit"] = 0;
drColumn["F_Format"] = gc.DisplayFormat.FormatString;
drColumn["F_FootFormat"] = gc.SummaryItem.DisplayFormat;
drColumn["F_Order"] = gc.VisibleIndex;
if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True)
{
drColumn["F_Merge"] = true;
}
else
{
drColumn["F_Merge"] = false;
}
strSumType = "";
switch (gc.SummaryItem.SummaryType)
{
case DevExpress.Data.SummaryItemType.Sum:
strSumType = "sum";
break;
case DevExpress.Data.SummaryItemType.Average:
strSumType = "avg";
break;
case DevExpress.Data.SummaryItemType.Count:
strSumType = "count";
break;
case DevExpress.Data.SummaryItemType.Max:
strSumType = "max";
break;
case DevExpress.Data.SummaryItemType.Min:
strSumType = "min";
break;
}
drColumn["F_SumType"] = strSumType;
GridGroupSummaryItem Gi = GetGroupType(strField);
if (Gi != null)
{
strSumType = "";
switch (Gi.SummaryType)
{
case DevExpress.Data.SummaryItemType.Sum:
strSumType = "sum";
break;
case DevExpress.Data.SummaryItemType.Average:
strSumType = "avg";
break;
case DevExpress.Data.SummaryItemType.Count:
strSumType = "count";
break;
case DevExpress.Data.SummaryItemType.Max:
strSumType = "max";
break;
case DevExpress.Data.SummaryItemType.Min:
strSumType = "min";
break;
}
drColumn["F_GroupType"] = strSumType;
drColumn["F_GroupFormat"] = Gi.DisplayFormat;
}
ds.Tables[0].Rows.Add(drColumn);
}
myHelper.ExecuteSQL("delete from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "'");
myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + intIndex.ToString() + "'");
}
/// <summary>
/// 保存字段格式
/// </summary>
private void SaveFieldFormat()
{
string strSumType = "";
DataRow drColumn;
bool blnFlag = false, blnTag = false;
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + this.Name + "' and F_Tag = '0' order by F_Order");
if (ds.Tables[0].Rows.Count == 0)
{
blnTag = false;
}
else
{
blnTag = true;
}
foreach (GridColumn gc in gvBase.Columns)
{
string strField = gc.FieldName;
string strCapiton = gc.Caption;
int intWith = gc.Width;
bool blnVisible = gc.Visible;
if (blnTag == false)
{
drColumn = ds.Tables[0].NewRow();
blnFlag = true;
}
else
{
DataRow[] dr = ds.Tables[0].Select("F_Field = '" + strField + "'");
drColumn = dr[0];
}
drColumn["F_Class"] = this.Name;
drColumn["F_Tag"] = "0";
drColumn["F_Field"] = gc.FieldName;
drColumn["F_Caption"] = strCapiton;
drColumn["F_Width"] = intWith;
drColumn["F_Visible"] = blnVisible;
drColumn["F_Edit"] = 0;
drColumn["F_Format"] = "";
drColumn["F_FootFormat"] = "";
drColumn["F_Order"] = gc.VisibleIndex;
if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True)
{
drColumn["F_Merge"] = true;
}
else
{
drColumn["F_Merge"] = false;
}
strSumType = "";
switch (gc.SummaryItem.SummaryType)
{
case DevExpress.Data.SummaryItemType.Sum:
strSumType = "sum";
break;
case DevExpress.Data.SummaryItemType.Average:
strSumType = "avg";
break;
case DevExpress.Data.SummaryItemType.Count:
strSumType = "count";
break;
case DevExpress.Data.SummaryItemType.Max:
strSumType = "max";
break;
case DevExpress.Data.SummaryItemType.Min:
strSumType = "min";
break;
}
drColumn["F_SumType"] = strSumType;
GridGroupSummaryItem Gi = GetGroupType(strField);
if (Gi != null)
{
strSumType = "";
switch (Gi.SummaryType)
{
case DevExpress.Data.SummaryItemType.Sum:
strSumType = "sum";
break;
case DevExpress.Data.SummaryItemType.Average:
strSumType = "avg";
break;
case DevExpress.Data.SummaryItemType.Count:
strSumType = "count";
break;
case DevExpress.Data.SummaryItemType.Max:
strSumType = "max";
break;
case DevExpress.Data.SummaryItemType.Min:
strSumType = "min";
break;
}
drColumn["F_GroupType"] = strSumType;
drColumn["F_GroupFormat"] = Gi.DisplayFormat;
}
if (blnFlag == false)
{
drColumn.EndEdit();
}
else
{
ds.Tables[0].Rows.Add(drColumn);
}
}
myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + this.Name + "' and F_Tag = '0'");
DataSet dsGrid = myHelper.GetDs("select * from t_GridFormat where F_Class = '" + this.Name + "' and F_Tag = '0'");
DataRow drGrid = null;
if (dsGrid.Tables[0].Rows.Count == 0)
{
blnFlag = true;
drGrid = dsGrid.Tables[0].NewRow();
}
else
{
blnFlag = false;
drGrid = dsGrid.Tables[0].Rows[0];
drGrid.BeginEdit();
}
drGrid["F_Class"] = this.Name;
drGrid["F_Tag"] = "0";
drGrid["F_AllowMerge"] = gvBase.OptionsView.AllowCellMerge;
drGrid["F_AllowFilter"] = gvBase.OptionsCustomization.AllowFilter;
drGrid["F_AllowPanel"] = gvBase.OptionsView.ShowGroupPanel;
drGrid["F_AllowSum"] = gvBase.OptionsView.ShowFooter;
drGrid["F_AutoWidth"] = gvBase.OptionsView.ColumnAutoWidth;
if (blnFlag == true)
{
dsGrid.Tables[0].Rows.Add(drGrid);
}
else
{
drGrid.EndEdit();
}
myHelper.SaveData(dsGrid, "select * from t_GridFormat where F_Class = '" + this.Name + "' and F_Tag = '0'");
}
/// <summary>
/// 设置单据明细字段
/// </summary>
private void AssignField()
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsGrid = myHelper.GetDs("select * from t_GridFormat where F_Class = '" + this.Name + "' and F_Tag = '0'");
if (dsGrid.Tables[0].Rows.Count > 0)
{
gvBase.OptionsCustomization.AllowFilter = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowFilter"]);
gvBase.OptionsView.AllowCellMerge = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowMerge"]);
gvBase.OptionsView.ShowFooter = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowSum"]);
gvBase.OptionsView.ShowGroupPanel = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AllowPanel"]);
gvBase.OptionsView.ColumnAutoWidth = Convert.ToBoolean(dsGrid.Tables[0].Rows[0]["F_AutoWidth"]);
}
dsGrid.Dispose();
DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + this.Name + "' and F_Tag = '0' order by F_Order");
if (ds.Tables[0].Rows.Count == 0)
{
return;
}
gvBase.GroupSummary.Clear();
gvBase.Columns.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
GridColumn gc = gvBase.Columns.AddField(dr["F_Field"].ToString());
gc.Caption = dr["F_Caption"].ToString();
gc.Width = Convert.ToInt32(dr["F_Width"]);
gc.Visible = Convert.ToBoolean(dr["F_Visible"]);
switch (dr["F_SumType"].ToString())
{
case "sum":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "avg":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "count":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
case "max":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "min":
gc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
}
if (Convert.ToBoolean(dr["F_Edit"]) == false)
{
//gc.AppearanceCell.BackColor = System.Drawing.Color.FromArgb(192, 255, 192);
gc.OptionsColumn.AllowFocus = false;
gc.OptionsColumn.AllowEdit = false;
}
if (Convert.ToBoolean(dr["F_Merge"]) == true)
{
gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
}
else
{
gc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
}
gc.AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
gc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (gc.FieldName == "Aid")
{
gc.AppearanceCell.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
gc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
if (dr["F_GroupType"].ToString().Length > 0)
{
GridGroupSummaryItem Gi = new GridGroupSummaryItem();
switch (dr["F_GroupType"].ToString())
{
case "sum":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Sum;
break;
case "avg":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Average;
break;
case "count":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Count;
break;
case "max":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Max;
break;
case "min":
Gi.SummaryType = DevExpress.Data.SummaryItemType.Min;
break;
}
Gi.FieldName = dr["F_Field"].ToString();
Gi.ShowInGroupColumnFooterName = dr["F_Field"].ToString();
Gi.DisplayFormat = dr["F_GroupFormat"].ToString();
//Gi.ShowInGroupColumnFooter = gc;
gvBase.GroupSummary.Add(Gi);
}
}
}
