/// <summary>Phương thức cho phép thêm chức năng vào cho Cột
/// Khi thay đổi giá trị của cột nó làm ảnh hưởng giá trị của các
/// cột khác
/// </summary>
/// <param name="Column">Cột mã hàng</param>
/// <param name="FieldName">FieldName của Tên hàng hóa, đơn giá, giảm giá ...</param>
/// <param name="func">Hàm gán giá trị cho các field</param>
public static void AddCalcGridColum(GridView Grid, GridColumn Column, string[] FieldNames, GetInfo Func)
{
Grid.CellValueChanged += delegate(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
GridView grid = (GridView)sender;
DataRow row = grid.GetDataRow(grid.FocusedRowHandle);
if (e.Column.FieldName.Equals(Column.FieldName))
{
object[] Values = Func(row[Column.FieldName]);
if (Values != null)
{
for (int i = 0; i < FieldNames.Length; i++)
{
grid.SetRowCellValue(grid.FocusedRowHandle, FieldNames[i], Values[i]);
}
}
else
{
grid.DeleteRow(grid.FocusedRowHandle);
}
}
}
catch (Exception ex)
{
PLException.AddException(ex);
}
};
}
public GridViewQuickColumnCustomization(GridView view)
{
this.view = view;
View.CustomDrawRowIndicator += new RowIndicatorCustomDrawEventHandler(View_CustomDrawRowIndicator);
View.MouseDown += new System.Windows.Forms.MouseEventHandler(View_MouseDown);
View.MouseUp += new System.Windows.Forms.MouseEventHandler(View_MouseUp);
}
/// <summary>
/// 合并GridView中某列相同信息的行（单元格）
/// </summary>
/// <param name="GridView1">GridView</param>
/// <param name="cellNum">第几列</param>
public static void GroupRows(GridView grv, int cellNum)
{
// i行控制器
int i = 0, rowSpanNum = 1;
while (i < grv.Rows.Count - 1)
{
GridViewRow gvr = grv.Rows[i];
for (++i; i < grv.Rows.Count; i++)
{
GridViewRow gvrNext = grv.Rows[i];
if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text)
{
gvrNext.Cells[cellNum].Visible = false;
rowSpanNum++;
}
else
{
gvr.Cells[cellNum].RowSpan = rowSpanNum;
rowSpanNum = 1;
break;
}
if (i == grv.Rows.Count - 1)
{
gvr.Cells[cellNum].RowSpan = rowSpanNum;
}
}
}
}
public static XtraGridControl Create(string name = null, DockStyle dockStyle = DockStyle.None, int? x = null, int? y = null, int? width = null, int? height = null)
{
XtraGridControl grid = new XtraGridControl();
GridView gridView = new GridView();
((ISupportInitialize)grid).BeginInit();
((ISupportInitialize)gridView).BeginInit();
grid.MainView = gridView;
grid.Name = name;
grid.Dock = dockStyle;
grid.Font = new Font("Courier New", 8.25F, FontStyle.Regular, GraphicsUnit.Point, 0);
Point? point = zForm.GetPoint(x, y);
if (point != null)
grid.Location = (Point)point;
Size? size = zForm.GetSize(width, height);
if (size != null)
grid.Size = (Size)size;
//grid.TabIndex = 0;
gridView.GridControl = grid;
((ISupportInitialize)grid).EndInit();
((ISupportInitialize)gridView).EndInit();
return grid;
}
public GridViewPrinter(GridControl aGrid, PrintDocument aPrintDocument, GridView aTable)
{
TheDataGrid = aGrid;
ThePrintDocument = aPrintDocument;
TheTable = aTable;
if (aPrintDocument.DefaultPageSettings.Landscape)
{
PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Height;
PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Width;
TopMargin = ThePrintDocument.DefaultPageSettings.Margins.Right;
BottomMargin = ThePrintDocument.DefaultPageSettings.Margins.Left;
LeftMargin = ThePrintDocument.DefaultPageSettings.Margins.Top;
RightMargin = ThePrintDocument.DefaultPageSettings.Margins.Bottom;
}
else
{
PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Width;
PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Height;
TopMargin = ThePrintDocument.DefaultPageSettings.Margins.Top;
BottomMargin = ThePrintDocument.DefaultPageSettings.Margins.Bottom;
}
}
public frmClipboardItem(string entity, GridView dgv)
{
InitializeComponent();
ds = ((DataView)dgv.DataSource).Table.DataSet;
gridControlDetails.DataSource = ClipboardMan.Instance.clipboard[entity].Data.Tables[0];
Entity = entity;
}
public override void onResume()
{
base.onResume();
// Load from file "cities.json" first time
if (mAdapter == null)
{
IList<City> cities = null;
try
{
cities = loadCities();
}
catch (IOException e)
{
Console.WriteLine(e.ToString());
Console.Write(e.StackTrace);
}
//This is the GridView adapter
mAdapter = new CityAdapter(this);
mAdapter.Data = cities;
//This is the GridView which will display the list of cities
mGridView = (GridView) findViewById(R.id.cities_list);
mGridView.Adapter = mAdapter;
mAdapter.notifyDataSetChanged();
mGridView.invalidate();
}
}
public GameView(Game game, TextWriter output)
{
if (game == null)
throw new ArgumentNullException("game", "[GameView.Constructor] Game must not be null.");
if (output == null)
throw new ArgumentNullException("output", "[GameView.Constructor] Output must not be null.");
this.game = game;
this.output = output;
grid = new GridView<Entity>(output)
{
Descriptor = entity => entity.Symbol,
PositionGetter = entity => entity.Position,
ItemSource = () => game.AllEntities,
GridWidth = game.Map.Width,
GridHeight = game.Map.Height,
DisplayWidth = 10,
DisplayHeight = 10,
};
if (output == System.Console.Out)
{
//grid.PreWrite = entity => System.Console.ForegroundColor = entity.Owner.Color.Value.ToConsoleColor();
//grid.PostWrite = entity => System.Console.ResetColor();
}
game.TurnStarted += _ => Draw();
}
public SortSerializer(
GridView gridView,
IPersistentPairStorage storage,
string key) :
base(gridView, storage, key)
{
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
public static void Export(StringWriter sw, GridView gv)
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a table to contain the grid
Table table = new Table();
// include the gridline settings
table.GridLines = gv.GridLines;
// add the header row to the table
if (gv.HeaderRow != null)
{
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
}
}
protected void btn1_Click(object sender, EventArgs e)
{
ControlClass d = new ControlClass(txtAspContent.Text);
List<p1> lst = new List<p1>();
lst.Add(new p1 { Name = "hi1" });
lst.Add(new p1 { Name = "hi2" });
lst.Add(new p1 { Name = "hi3" });
lst.Add(new p1 { Name = "hi4" });
GridView ss = new GridView();
ss = ((GridView)d.ControlGenerated);
ss.DataSource = lst;
ss.DataBind();
foreach (GridViewRow row in ss.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
Label myHyperLink = row.FindControl("lbl1") as Label;
Label myHyperLnk1 = row.FindControl("Name2") as Label;
}
}
foreach (GridViewRow row in gg1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
Label myHyperLink = row.FindControl("lbl1") as Label;
}
}
plcHolder1.Controls.Add(ss);
}
public void FormatColumns(GridView view)
{
foreach (GridColumn col in view.Columns)
{
switch (col.ColumnType.Name)
{
case "Boolean":
col.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
break;
case "Int":
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "#,##0";
break;
case "Float":
case "Double":
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "#,##0.00";
break;
case "DateTime":
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
col.DisplayFormat.FormatString = "dd-MMM-yyyy";
break;
}
}
}
/// <summary>
/// Thêm danh sách menu ngữ cảnh vào trong GridView.
/// Menu này áp dụng khi click phải trên phần nội dung của lưới
/// </summary>
public static void AddContextMenu(GridView grid, List<ItemInfo> items)
{
BarManager manager = new BarManager(); ;
PopupMenu menu = new PopupMenu();
if (items == null) return;
for (int i = 0; i < items.Count; i++)
{
if (items[i].Per != null)
if (ApplyPermissionAction.checkPermission(items[i].Per) == null ||
ApplyPermissionAction.checkPermission(items[i].Per) == false)
{
continue;
}
Image image = ResourceMan.getImage16(items[i].Image);
BarItem item = new BarButtonItem();
item.Caption = items[i].Caption;
item.Name = i.ToString();
item.Glyph = image;
manager.Items.Add(item);
menu.ItemLinks.Add(manager.Items[i]);
DelegationLib.CallFunction_MulIn_NoOut del = items[i].Delegates;
item.ItemClick += delegate(object sender, ItemClickEventArgs e)
{
string name = item.Name;
List<object> objs = new List<object>();
int[] a = grid.GetSelectedRows();
DataRow dr = grid.GetDataRow(a[0]);
objs.Add(dr);
del(objs);
};
}
grid.MouseUp += delegate(object sender, MouseEventArgs e)
{
if ((e.Button & MouseButtons.Right) != 0 && grid.GridControl.ClientRectangle.Contains(e.X, e.Y))
{
menu.ShowPopup(manager, Control.MousePosition);
}
else
{
menu.HidePopup();
}
};
grid.MouseMove += delegate(object sender, MouseEventArgs e)
{
if ((e.Button & MouseButtons.Right) != 0 && grid.GridControl.ClientRectangle.Contains(e.X, e.Y))
{
menu.ShowPopup(manager, Control.MousePosition);
}
else
{
menu.HidePopup();
}
};
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate (bundle);
// set our layout to be the home screen
SetContentView(Resource.Layout.DataGridExampleScreen);
gridView = FindViewById<GridView> (Resource.Id.offerGridView);
var txtTitle = FindViewById<TextView> (Resource.Id.txtTitle);
var txtAddColumn = FindViewById<TextView> (Resource.Id.txtAddColumn);
var txtAddRow = FindViewById<TextView> (Resource.Id.txtAddRow);
txtTitle.SetText ("Data Grid Example", TextView.BufferType.Normal);
txtAddColumn.Click += (sender, e) => {
dataTable.Columns.Add("New Col " + (dataTable.Columns.Count + 1));
gridView.NumColumns = dataTable.Columns.Count;
gridView.InvalidateViews();
};
txtAddRow.Click += (sender, e) => {
var row = dataTable.NewRow();
dataTable.Rows.Add(row);
gridView.InvalidateViews();
};
}
public override void UpdateTempSub(GridView dgv)
{
DataTable dt1 = (DataTable)ViewState[FormID + "_Edit_" + dgv.ID];
if (dt1.Rows.Count == 0)
{
return;
}
DataRow dr;
for (int i = 0; i < dgv.Rows.Count; i++)
{
dr = dt1.Rows[i + dgv.PageSize * dgv.PageIndex];
dr.BeginEdit();
dr["BillID"] = this.txtID.Text.Trim();
dr["RowID"] = ((Label)dgv.Rows[i].FindControl("RowID")).Text;
dr["ProductCode"] = ((TextBox)dgv.Rows[i].FindControl("ProductCode")).Text;
dr["ProductName"] = ((TextBox)dgv.Rows[i].FindControl("ProductName")).Text;
dr["Quantity"] = ((TextBox)dgv.Rows[i].FindControl("Quantity")).Text;
dr["Weight"] = ((TextBox)dgv.Rows[i].FindControl("Weight")).Text.Trim() == "" ? 0 : decimal.Parse(((TextBox)dgv.Rows[i].FindControl("Weight")).Text.Trim());
dr["Barcode"] = ((TextBox)dgv.Rows[i].FindControl("Barcode")).Text;
dr["Memo"] = ((TextBox)dgv.Rows[i].FindControl("SubMemo")).Text;
dr.EndEdit();
}
dt1.AcceptChanges();
object o = dt1.Compute("SUM(Quantity)", "");
this.txtTotalQty.Text = o.ToString();
ViewState[FormID + "_Edit_" + dgv.ID] = dt1;
}
public GridColumn[] CreateDM_DANH_BA(GridControl gridControl, GridView gridView)
{
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "ID", -1, -1), "ID");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Tên tài liệu", 0, 150), "NAME");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Địa chỉ", 1, 150), "DIA_CHI");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Số điện thoại", 2, 150), "SO_DIEN_THOAI");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Di động", 3, 150), "DI_DONG");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Fax", 4, 150), "SO_FAX");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Người đại diện", 5, 150), "NGUOI_DAI_DIEN");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Chức vụ", 6, 150), "CHUC_VU");
HelpGridColumn.CotTextLeft(
HelpGridColumn.ThemCot(gridView, "Số tài khoản", 7, 150), "TAI_KHOAN");
XtraGridSupportExt.ComboboxGridColumn(HelpGridColumn.ThemCot(gridView, "Ngân hàng", 1, 150), " DM_BANK", "ID", "NAME", "TEN_NGAN_HANG").NullText = string.Empty;
gridView.OptionsView.ColumnAutoWidth = false;
gridView.OptionsView.ShowAutoFilterRow = false;
gridView.OptionsView.ShowGroupedColumns = false;
gridView.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Never;
((PLGridView)gridView).DefaultNewRow = ProtocolVN.Framework.Win.HelpGrid.CheckVisibleDefault;
((PLGridView)gridView)._SetUserLayout();
return null;
}
public GridColumn[] CreateDM_NHAN_VIEN(GridControl gridControl, GridView gridView)
{
XtraGridSupportExt.TextLeftColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "ID", -1, -1), "ID");
XtraGridSupportExt.TextLeftColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "Mã nhân viên", 0, 150), "MA_NV");
GridColumn Ten = XtraGridSupportExt.CreateGridColumn(gridView, "Tên nhân viên", 1, 150);
XtraGridSupportExt.TextLeftColumn(
Ten, "NAME");
GridColumn ColPhongBan = XtraGridSupportExt.CreateGridColumn(gridView, "Tên phòng ban", 2, 150);
ColPhongBan.FieldName = "DEPARTMENT_ID";
//XtraGridSupportExt.IDGridColumn(ColPhongBan, "ID", "NAME", "DEPARTMENT", "DEPARTMENT_ID");
HelpGridColumn.CotCombobox(ColPhongBan, HelpDB.getDatabase().LoadDataSet(@"SELECT *
FROM DEPARTMENT WHERE PARENT_ID IS NOT NULL"), "ID", "NAME", "DEPARTMENT_ID");
ColPhongBan.OptionsColumn.AllowEdit = true;
ColPhongBan.OptionsColumn.AllowFocus = false;
ColPhongBan.OptionsColumn.ReadOnly = true;
Ten.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
XtraGridSupportExt.TextLeftColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "CMND", 3, 150), "CMND");
XtraGridSupportExt.DateTimeGridColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "Ngày sinh", 4, 150), "NGAY_SINH");
XtraGridSupportExt.TextLeftColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "Điện thoại", 5, 150), "DIEN_THOAI");
XtraGridSupportExt.TextLeftColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "Địa chỉ", 6, 150), "DIA_CHI");
XtraGridSupportExt.TextLeftColumn(
XtraGridSupportExt.CreateGridColumn(gridView, "Email", 7, 150), "EMAIL");
HelpGridColumn.CotCheckEdit(
XtraGridSupportExt.CreateGridColumn(gridView, "Hiển thị", 8, 100), "VISIBLE_BIT");
gridView.OptionsView.ShowGroupedColumns = false;
gridView.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;
gridView.OptionsView.ColumnAutoWidth = true;
return null;
}
//private GridControl _gridResult1;
//private GridView _gridView1;
private void CreateXtraGrid()
{
_gridResult1 = new GridControl();
_gridView1 = new GridView();
((ISupportInitialize)(_gridResult1)).BeginInit();
((ISupportInitialize)(_gridView1)).BeginInit();
//tab_result.Controls.Add(_gridResult1);
//
// _gridResult1
//
_gridResult1.Dock = DockStyle.Fill;
_gridResult1.EmbeddedNavigator.Name = "";
_gridResult1.Font = new Font("Courier New", 8.25F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0)));
_gridResult1.Location = new Point(3, 3);
_gridResult1.MainView = _gridView1;
_gridResult1.Name = "_gridResult1";
_gridResult1.Size = new Size(1042, 358);
_gridResult1.TabIndex = 0;
//_gridResult1.Text = "gridControl1";
//
// gridView1
//
_gridView1.GridControl = _gridResult1;
_gridView1.Name = "_gridView1";
((ISupportInitialize)(_gridResult1)).EndInit();
((ISupportInitialize)(_gridView1)).EndInit();
tab_result1.Controls.Add(_gridResult1);
}
/// <summary>
/// 輸出為Excel
/// </summary>
/// <param name="webpage">傳入目前網頁Page變數</param>
/// <param name="Dt">需要匯出的內容</param>
/// <param name="FilePath">輸出的檔名</param>
public void OutputExcel(Page webpage,
DataTable Dt,
string FilePath
)
{
GridView gvExport = new GridView();
gvExport.DataSource = Dt;
gvExport.DataBind();
string UTF8FileName = HttpUtility.UrlEncode(FilePath,
System.Text.Encoding.UTF8
);
webpage.Response.Clear();
webpage.Response.AddHeader("content-disposition",
string.Format("attachment;filename={0}",
UTF8FileName)
);
webpage.Response.Cache.SetCacheability(HttpCacheability.NoCache);
webpage.Response.ContentType = "application/vnd.ms-excel";
webpage.Response.Charset = "big5";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvExport.RenderControl(htmlWrite);
webpage.Response.Write(stringWrite.ToString().Replace("<div>", "").Replace("</div>", ""));
webpage.Response.End();
}
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
{
var root = inflater.Inflate(Resource.Layout.trakked_shows_gridview_layout, container, false);
_gridView = root.FindViewById<GridView>(Resource.Id.trakkedGrid);
_gridView.ItemClick += (object sender, AdapterView.ItemClickEventArgs e) =>
{
var intent = new Intent(this.Activity, typeof (OverviewShowActivity));
//Change to show
intent.PutExtra("TMDBID", "" + _myShowList[e.Position].TMDBID);
StartActivity(intent);
};
var fab = root.FindViewById<FloatingActionButton>(Resource.Id.fab);
fab.AttachToListView(_gridView);
fab.ColorNormal =new Color(255, 255, 0);
fab.ColorPressed = new Color(255, 0, 255);
fab.Click += delegate
{
var intent = new Intent(Activity, typeof(AddShowsTabActivity));
StartActivity(intent);
};
BuildView();
return root;
}
/// <summary>Chỉnh độ rộng của cột theo dạng đẹp nhất có thể
/// </summary>
public static void BestFitMasterColumns(GridView gridView)
{
gridView.GridControl.Load += delegate(object sender, EventArgs e)
{
gridView.BestFitColumns();
};
}
public void GanDuLieu(GridView tmpGrid)
{
tblTaskList = TaskOBJ.DBConnectionTaskList("SP_TASK_VIEW", Convert.ToInt32(Session["logedUser"]), Convert.ToInt32(Session["TaskType"]));
if (tblTaskList.Rows.Count > 0)
{
dgrTaskList.Caption = "Danh sách công việc";//tblTaskList.Rows[0]["Danh sách hình ảnh đăng tải"].ToString();
tblTaskList.Columns.Add("Số TT", typeof(Int32));
// Add thứ tự công việc vào lưới
for (int i = 0; i < tblTaskList.Rows.Count; i++)
{
tblTaskList.Rows[i]["Số TT"] = i + 1;
}
tmpGrid.DataSource = tblTaskList;
tmpGrid.DataBind();
}
else
{
}
}
private void layout(ref GridView grid)
{
grid.ItemsSource = null;
items = new ObservableCollection<Grid>();
index = 0;
numbers = select(1, 90, 90);
}
protected void ddlBind(GridView gv)
{
if (gv.BottomPagerRow != null)
{
//讓下拉式選單顯示頁數
DropDownList ddlSelectPage = (DropDownList)gv.BottomPagerRow.FindControl("ddlSelectPage");
for (int i = 0; i < GD_CATE.PageCount; i++)
{
ddlSelectPage.Items.Add(new ListItem("第" + (i + 1).ToString() + "頁", i.ToString()));
}
//顯示目前頁數
ddlSelectPage.SelectedIndex = gv.PageIndex;
//下拉選單顯示頁面資料列數
/*DropDownList ddlSelectPageSize = (DropDownList)gv.BottomPagerRow.FindControl("ddlSelectPageSize");
if (ddlSelectPageSize.Items.Count <= 0)
{
ddlSelectPageSize.Items.Add(new ListItem("每頁1筆", "1"));
ddlSelectPageSize.Items.Add(new ListItem("每頁2筆", "2"));
ddlSelectPageSize.Items.Add(new ListItem("每頁3筆", "3"));
}*/
//顯示目前列數
//ddlSelectPageSize.SelectedValue = gv.PageSize.ToString();
}
}
/// <summary>
/// 绑定数据到GridView，当表格数据为空时显示表头
/// </summary>
/// <param name="gridview"></param>
/// <param name="table">not null</param>
public static void GridViewDataBind(GridView gridview, DataTable table)
{
if (table == null)
throw new NullReferenceException();
//记录为空重新构造Gridview
if (table.Rows.Count == 0)
{
table = table.Clone();
table.Rows.Add(table.NewRow());
gridview.DataSource = table;
gridview.DataBind();
int columnCount = table.Columns.Count;
gridview.Rows[0].Cells.Clear();
gridview.Rows[0].Cells.Add(new TableCell());
gridview.Rows[0].Cells[0].ColumnSpan = columnCount;
gridview.Rows[0].Cells[0].Text = EmptyText;
gridview.Rows[0].Cells[0].Style.Add("text-align", "center");
}
else
{
//数据不为空直接绑定
gridview.DataSource = table;
gridview.DataBind();
}
//重新绑定取消选择
gridview.SelectedIndex = -1;
}
protected void Page_Load(object sender, EventArgs e)
{
List<Event> events = Event.GetAllEvents();
foreach (Event ev in events)
{
Panel pnlEvent = new Panel();
pnlEvent.ID = ev.ID.ToString();
Label lblEventName = new Label();
lblEventName.Text = ev.Name;
Label lblNumberOfParticipants = new Label();
pnlEvent.Controls.Add(lblEventName);
pnlEvent.Controls.Add(lblNumberOfParticipants);
GridView grdvwParticipation = new GridView();
grdvwParticipation.DataSource = Event.GetRegisteredParticipants(ev, 0);
grdvwParticipation.DataBind();
pnlEvent.Controls.Add(grdvwParticipation);
pnlDetails.Controls.Add(pnlEvent);
if (ev.IsSinglePlayer)
{
foreach (GridViewRow row in grdvwParticipation.Rows)
{
row.Cells[0].Text = "TT" + row.Cells[0].Text;
}
lblNumberOfParticipants.Text = "Total Participants: " + grdvwParticipation.Rows.Count.ToString();
}
else
{
var numberOfTeams = (from i in grdvwParticipation.Rows.Cast<GridViewRow>() select new { Teamid = i.Cells[0].Text }).Distinct().Count();
lblNumberOfParticipants.Text = "Total Teams: " + numberOfTeams.ToString();
}
}
}
///<summary>
///绑定数据到GridView，当表格数据为空时显示表头
///</summary>
///<param name="gridview"></param>
///<param name="table"></param>
public static void GridViewDataBind(GridView gridview, DataTable table)
{
//记录为空重新构造Gridview
EmptyText = Resources.MyGlobal.NoDataText;
if (table.Rows.Count == 0)
{
table = table.Clone();
table.Rows.Add(table.NewRow());
int columnCount = table.Columns.Count;
gridview.DataSource = table;
gridview.DataBind();
gridview.Rows[0].Cells.Clear();
gridview.Rows[0].Cells.Add(new TableCell());
gridview.Rows[0].Cells[0].ColumnSpan = columnCount;
gridview.Rows[0].Cells[0].Text = EmptyText;
gridview.Rows[0].Cells[0].Style.Add("text-align", "center");
gridview.Rows[0].Cells[0].Style.Add("color", "red");
gridview.Rows[0].Style.Add("height", "24px");
//gridview.HeaderRow.Enabled = false;
}
else
{
//数据不为空直接绑定
gridview.DataSource = table;
gridview.DataBind();
}
//重新绑定取消选择
gridview.SelectedIndex = -1;
}
public void CheckDuplicateDIEM_THEO_DOI_NOP_BAI(GridView grid, DataSet GridDataSet, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
DataRow row = grid.GetDataRow(e.RowHandle);
int count = 0;
foreach (DataRow r in GridDataSet.Tables[0].Rows)
{
if (r.RowState != DataRowState.Deleted)
{
if (r["NHAN_SU"].ToString() == row["NHAN_SU"].ToString() && r["NGUOI_GIAO"].ToString() == row["NGUOI_GIAO"].ToString() && r["NGAY_GIAO"].ToString() == row["NGAY_GIAO"].ToString())
{
if (grid.IsNewItemRow(grid.FocusedRowHandle))
{
r.RowError = "Dữ liệu bị trùng, xin vui lòng kiểm tra lại.";
grid.SetColumnError(grid.Columns["NHAN_SU"], "Nhân sự, người giao và ngày giao bị trùng, xin vui lòng kiểm tra lại.");
e.Valid = false;
return;
}
else
{
count++;
if (count == 2)
{
r.RowError = "Dữ liệu bị trùng, xin vui lòng kiểm tra lại.";
grid.SetColumnError(grid.Columns["NHAN_SU"], "Nhân sự, người giao và ngày giao bị trùng, xin vui lòng kiểm tra lại.");
e.Valid = false;
return;
}
}
}
}
}
}
public static ArrayList ExtractSummaryItems(GridView view)
{
var items = new ArrayList();
foreach (GridSummaryItem si in view.GroupSummary.Cast<GridSummaryItem>().Where(si => si is GridGroupSummaryItem && si.SummaryType != SummaryItemType.None))
items.Add(si);
return items;
}
public void ExportExcel(DataTable dt, string title, string from_time, string to_time, string User)
{
GridView GridView8 = new GridView();
GridView8.AllowPaging = false;
DataTable dt_Header = new DataTable();
dt_Header.Columns.Add("Thong_Tin", typeof(string));
dt_Header.Rows.Add("");
dt_Header.Rows.Add("" + title);
dt_Header.Rows.Add("");
dt_Header.Rows.Add("User: "******"");
dt_Header.Rows.Add("Tu ngay: " + from_time);
dt_Header.Rows.Add("Den ngay: " + to_time);
dt_Header.Rows.Add("");
GridView GridView7 = new GridView();
GridView7.AllowPaging = false;
GridView7.DataSource = dt_Header;
GridView7.BorderStyle = BorderStyle.None;
GridView7.DataBind();
//Add row if no data found
//if (dt.Rows.Count <= 0)
//{
// int num_col = dt.Columns.Count;
// dt.Rows.Add();
//}
GridView8.DataSource = dt;
GridView8.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + User + "_Report.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView7.Rows.Count; i++)
{
//Apply text style to each Row
GridView7.Rows[i].Attributes.Add("class", "textmode");
}
GridView7.RenderControl(hw);
for (int i = 0; i < GridView8.Rows.Count; i++)
{
//Apply text style to each Row
GridView8.Rows[i].Attributes.Add("class", "textmode");
}
GridView8.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
private DynamicLayout Init(out GridView gd)
{
var layout = new DynamicLayout();
layout.DefaultPadding = new Padding(5);
layout.DefaultSpacing = new Size(5, 5);
var addNew = new Button {
Text = "Add"
};
addNew.Command = _vm.AddCommand;
var duplicate = new Button {
Text = "Duplicate"
};
duplicate.Command = _vm.DuplicateCommand;
var edit = new Button {
Text = "Edit"
};
edit.Command = _vm.EditCommand;
var remove = new Button {
Text = "Remove"
};
remove.Command = _vm.RemoveCommand;
layout.AddSeparateRow("Materials:", null, addNew, duplicate, edit, remove);
// search bar
var filter = new TextBox()
{
PlaceholderText = "Filter"
};
filter.TextBinding.Bind(_vm, _ => _.FilterKey);
layout.AddSeparateRow(filter);
gd = GenGridView();
layout.AddSeparateRow(controls: new[] { gd }, xscale: true, yscale: true);
// counts
var counts = new Label();
counts.TextBinding.Bind(_vm, _ => _.Counts);
// unit switchs
var unit = new RadioButtonList();
unit.Items.Add("Metric");
unit.Items.Add("Imperial");
unit.SelectedIndex = 0;
unit.Spacing = new Size(5, 0);
unit.SelectedIndexChanged += (s, e) => _vm.UseIPUnit = unit.SelectedIndex == 1;
layout.AddSeparateRow(counts, null, unit);
var OKButton = new Button {
Text = "OK"
};
OKButton.Click += (sender, e) => OkCommand.Execute(null);
AbortButton = new Button {
Text = "Cancel"
};
AbortButton.Click += (sender, e) => Close();
layout.AddSeparateRow(null, OKButton, AbortButton, null);
gd.CellDoubleClick += (s, e) => _vm.EditCommand.Execute(null);
return(layout);
}
protected void drop_page_size_DataBinding(object sender, EventArgs e)
{
GridView gridData = fnGetNowGridView();
DropDownList dropData = ((DropDownList)sender);
GridViewEvent.fnDropPageSizeDataBinding(ref gridData, ref dropData);
}
protected void drop_page_size_SelectedIndexChanged(object sender, EventArgs e)
{
GridView gridData = fnGetNowGridView();
DropDownList dropData = ((DropDownList)sender);
GridViewEvent.fnDropPageSizeSelectedIndexChanged(ref gridData, ref dropData);
}
protected void linkbtn_previous_Click(object sender, EventArgs e)
{
GridView gridData = fnGetNowGridView();
GridViewEvent.fnPreviousPageEvent(ref gridData);
}
protected void linkbtn_next_Click(object sender, EventArgs e)
{
GridView gridData = fnGetNowGridView();
GridViewEvent.fnNextPageEvent(ref gridData);
}
private GridView GenGridView()
{
var gd = new GridView();
gd.Bind(_ => _.DataStore, _vm, _ => _.GridViewDataCollection);
gd.SelectedItemsChanged += (s, e) => {
_vm.SelectedData = gd.SelectedItem as MaterialViewData;
};
gd.Height = 250;
gd.Columns.Add(new GridColumn {
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.Name)
},
HeaderText = "Name",
Sortable = true,
Width = 200
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.CType)
},
HeaderText = "Type",
Sortable = true,
Width = 100
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.RValue)
},
HeaderText = "RValue",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.UValue)
},
HeaderText = "UValue",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.UFactor)
},
HeaderText = "UFactor",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.SHGC)
},
HeaderText = "SHGC",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.TSolar)
},
HeaderText = "TSolar",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.TVis)
},
HeaderText = "TVis",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new CheckBoxCell {
Binding = Binding.Delegate <MaterialViewData, bool?>(r => r.Locked)
},
HeaderText = "Locked",
Sortable = true
});
gd.Columns.Add(new GridColumn
{
DataCell = new TextBoxCell {
Binding = Binding.Delegate <MaterialViewData, string>(r => r.Source)
},
HeaderText = "Source",
Sortable = true
});
// sorting by header
gd.ColumnHeaderClick += OnColumnHeaderClick;
return(gd);
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Init"/> event.
/// </summary>
/// <param name="e">An <see cref="T:System.EventArgs"/> object that contains the event data.</param>
protected override void OnInit(EventArgs e)
{
//
// We have to have a ToolkitScriptManager on the page but, we can't require that the
// developer add one to the page because this might be a SharePoint environment
// so, we added this code to Page.Init to add a ToolkitScriptManager if there isn't one.
//
Page.Init += delegate(object sender, EventArgs e_Init)
{
if (ToolkitScriptManager.GetCurrent(Page) == null)
{
ToolkitScriptManager sMgr = new ToolkitScriptManager();
if (Page.Form == null)
{
throw new HttpException("Control must be located inside of a <form> tag.");
}
Page.Form.Controls.AddAt(0, sMgr);
}
};
// if (!Page.IsCallback)
{
m_GridView = new GridView();
m_MonitorData = new MonitorDataSource();
m_GridView.DataSource = m_MonitorData;
m_GridView.AutoGenerateColumns = false;
}
if (!DesignMode)
{
//
// Add our stylesheet
//
HtmlLink link = new HtmlLink();
link.Href = Page.ClientScript.GetWebResourceUrl(this.GetType(),
"MVPSI.JAMSWeb.Controls.Resources.JAMSLoadingStyles.css");
link.Attributes.Add("type", "text/css");
link.Attributes.Add("rel", "stylesheet");
Page.Header.Controls.Add(link);
HtmlLink link2 = new HtmlLink();
link2.Href = Page.ClientScript.GetWebResourceUrl(this.GetType(), "MVPSI.JAMSWeb.Controls.SubmitDialog.JAMSSubmitStyles.css");
link2.Attributes.Add("type", "text/css");
link2.Attributes.Add("rel", "stylesheet");
Page.Header.Controls.Add(link2);
}
m_GridView.CssClass = "monitorControl";
UpdatePanel = new UpdatePanel {
ID = GetChildControlID("UpdatePanel")
};
UpdatePanel.ChildrenAsTriggers = true;
UpdatePanel.RenderMode = UpdatePanelRenderMode.Block;
//Setup loading dialog
var popup = new ModalPopupExtender();
popup.PopupControlID = GetChildControlID("LoadingDialog");
popup.DropShadow = false;
popup.RepositionMode = ModalPopupRepositionMode.RepositionOnWindowResize;
popup.TargetControlID = GetChildControlID("DummyButton");
popup.ID = GetChildControlID("PopupExtender");
popup.BehaviorID = GetChildControlID("PopupExtender");
Button button = new Button();
button.ID = GetChildControlID("DummyButton");
button.Style["display"] = "none";
button.Height = 0;
button.Width = 0;
button.UseSubmitBehavior = false;
Panel loadingDialog = new Panel();
Label loadingLabel = new Label();
Image img = new Image();
loadingLabel.Style["width"] = "auto";
loadingLabel.Style["margin"] = "4%";
loadingLabel.Text = "Loading...";
img.ImageUrl = Page.ClientScript.GetWebResourceUrl(this.GetType(), "MVPSI.JAMSWeb.Controls.Resources.LoadIcon.gif");
loadingDialog.Controls.Add(img);
loadingDialog.Controls.Add(loadingLabel);
loadingDialog.ID = GetChildControlID("LoadingDialog");
loadingDialog.Style["height"] = "50px";
loadingDialog.HorizontalAlign = HorizontalAlign.Left;
loadingDialog.CssClass = "loadingPopup";
Panel noResultsPanel = new Panel();
Label noResultsLabel = new Label();
noResultsLabel.Text = "No results found";
noResultsLabel.Style["width"] = "auto";
noResultsLabel.Style["margin"] = "4%";
noResultsPanel.ID = GetChildControlID("NoResultsPanel");
noResultsPanel.Controls.Add(noResultsLabel);
m_NoResultsPanel = noResultsPanel;
m_MonitorDialog.ID = GetChildControlID("MonitorDetail");
m_MonitorDialog.ServerName = this.ServerName;
var dialogPopup = new ModalPopupExtender();
dialogPopup.PopupControlID = m_MonitorDialog.ClientID;
dialogPopup.DropShadow = false;
dialogPopup.RepositionMode = ModalPopupRepositionMode.RepositionOnWindowResize;
dialogPopup.TargetControlID = GetChildControlID("DummyButton2");
dialogPopup.ID = GetChildControlID("DialogPopupExtender");
dialogPopup.BackgroundCssClass = "modalBackground";
m_MonitorDialog.Extender = dialogPopup;
m_MonitorDialog.ParentMonitor = this;
var dummyButton2 = new Button();
dummyButton2.ID = GetChildControlID("DummyButton2");
dummyButton2.Style["display"] = "none";
dummyButton2.Height = 0;
dummyButton2.Width = 0;
dummyButton2.UseSubmitBehavior = false;
var errorDummyButton = new Button {
ID = GetChildControlID("ErrorDummyButton"), UseSubmitBehavior = false
};
errorDummyButton.Style["Display"] = "None";
m_ErrorPanel = new Panel {
ID = GetChildControlID("ErrorDialogPanel")
};
m_ErrorPanel.Controls.Add(new Label {
Text = "Error", CssClass = "tabContents"
});
m_ErrorPanel.Controls.Add(new Button {
Text = "OK", ID = GetChildControlID("ErrorOk")
});
m_ErrorPanel.CssClass = "modalPopup";
m_ErrorPanel.Style["Display"] = "None";
m_ErrorDialog = new ModalPopupExtender {
ID = GetChildControlID("ErrorDialog")
};
m_ErrorDialog.PopupControlID = m_ErrorPanel.ClientID;
m_ErrorDialog.DropShadow = false;
m_ErrorDialog.RepositionMode = ModalPopupRepositionMode.RepositionOnWindowResize;
m_ErrorDialog.TargetControlID = errorDummyButton.ClientID;
m_ErrorDialog.BackgroundCssClass = "modalBackground";
m_ErrorDialog.CancelControlID = GetChildControlID("ErrorOk");
m_ErrorDialog.BehaviorID = m_ErrorDialog.ID;
Control controlContainer = UpdatePanel.ContentTemplateContainer;
controlContainer.Controls.Add(m_GridView);
controlContainer.Controls.Add(m_MonitorData);
controlContainer.Controls.Add(m_MonitorDialog);
controlContainer.Controls.Add(m_MonitorDialog.Extender);
controlContainer.Controls.Add(dummyButton2);
controlContainer.Controls.Add(loadingDialog);
controlContainer.Controls.Add(button);
controlContainer.Controls.Add(popup);
controlContainer.Controls.Add(noResultsPanel);
controlContainer.Controls.Add(m_ErrorPanel);
controlContainer.Controls.Add(m_ErrorDialog);
controlContainer.Controls.Add(errorDummyButton);
SubPanel = new Panel();
controlContainer.Controls.Add(SubPanel);
base.OnInit(e);
}
public LibraryGridViewHandler(GridView view)
: base(view)
{
}
public virtual void HandleExport(HttpContext context, string response)
{
string exportType = context.Request.Params["exportType"];
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + GetFileName(context) + ";");
if (string.IsNullOrEmpty(exportType))
{
context.Response.ContentType = "application/csv";
context.Response.Write(response);
}
else
{
GridView gv = CSVtoGridView(response);
if (exportType.Equals("excel", StringComparison.CurrentCultureIgnoreCase))
{
context.Response.Clear();
context.Response.Buffer = true;
context.Response.Charset = "";
context.Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < gv.Rows.Count; i++)
{
//Apply text style to each Row
gv.Rows[i].Attributes.Add("class", "textmode");
}
gv.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
context.Response.Write(style);
context.Response.Output.Write(sw.ToString());
context.Response.Flush();
}
else if (exportType.Equals("word", StringComparison.CurrentCultureIgnoreCase))
{
context.Response.Clear();
context.Response.Buffer = true;
context.Response.Charset = "";
context.Response.ContentType = "application/vnd.ms-word ";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gv.RenderControl(hw);
context.Response.Output.Write(sw.ToString());
context.Response.Flush();
}
else if (exportType.Equals("pdf", StringComparison.CurrentCultureIgnoreCase))
{
context.Response.ContentType = "application/pdf";
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gv.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4.Rotate(), 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, context.Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
context.Response.Write(pdfDoc);
}
}
context.Response.End();
}
private void FocusNewRow(GridView childView)
{
gridControl1.FocusedView = childView;
childView.ShowEditor();
}
private void ExpandNewRow(GridView view)
{
view.MasterRowExpanded += new CustomMasterRowEventHandler(OnGridViewMasterRowExpanded);
view.SetMasterRowExpanded(view.GetRowHandle(((IList)view.DataSource).Count - 1), true);
}
protected void gvrBitacoraPLD_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
GridView gridView = (GridView)sender;
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (((BitacoraPLD)(e.Row.DataItem)).datFechaRespuesta != null)
{
e.Row.ForeColor = System.Drawing.Color.Red;
}
}
// gridView.Columns[8].Visible = !chkMuestraHist.Checked;
if (gridView.SortExpression.Length > 0)
{
int cellIndex = -1;
//foreach (DataControlField field in gridView.Columns)
//{
// if (field.SortExpression == gridView.SortExpression)
// {
// cellIndex = gridView.Columns.IndexOf(field);
// break;
// }
//}
if (((BitacoraPLD)(e.Row.DataItem)).datFechaRespuesta == null)
{
if (cellIndex > -1)
{
if (e.Row.RowType == DataControlRowType.Header)
{
if (gridView.SortDirection == SortDirection.Ascending)
{
e.Row.Cells[cellIndex].CssClass = "sortascheaderstyle";
}
else
{
e.Row.Cells[cellIndex].CssClass = "sortdescheaderstyle";
}
}
else if (e.Row.RowType == DataControlRowType.DataRow)
{
if ((e.Row.RowIndex % 2) == 0)
{
e.Row.Cells[cellIndex].CssClass = "sortalternatingrowstyle";
}
else
{
e.Row.Cells[cellIndex].CssClass = "sortrowstyle";
}
}
}
}
}
if (e.Row.RowIndex != -1)
{
if (((BitacoraPLD)(e.Row.DataItem)).datFechaRespuesta == null)
{
e.Row.Attributes.Add("onmouseover", "javascript:this.style.color='#FF8000';");
e.Row.Attributes.Add("onmouseout", "javascript:this.style.color='#284775';");
}
}
if (e.Row.RowType == DataControlRowType.Pager)
{
Label lblTotalNumberOfPages = (Label)e.Row.FindControl("lblTotalNumberOfPages");
lblTotalNumberOfPages.Text = gridView.PageCount.ToString();
TextBox txtGoToPage = (TextBox)e.Row.FindControl("txtGoToPage");
txtGoToPage.Text = (gridView.PageIndex + 1).ToString();
DropDownList ddlPageSize = (DropDownList)e.Row.FindControl("ddlPageSize");
ddlPageSize.SelectedValue = gridView.PageSize.ToString();
}
}
catch (Exception ex)
{
this.wucMensajeSistema.setMensaje(ex.Message, 2);
}
}
public static void ExportToExcel1(DataTable table)
{
GridView grid = new GridView {
DataSource = table
};
grid.DataBind();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Write(@"<!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN"">");
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=Reports.xls");
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1250");
//sets font
HttpContext.Current.Response.Write("<font style='font-size:10.0pt; font-family:Calibri;'>");
HttpContext.Current.Response.Write("<BR><BR><BR>");
//sets the table border, cell spacing, border color, font of the text, background, foreground, font height
HttpContext.Current.Response.Write("<Table border='1' bgColor='#ffffff' " +
"borderColor='#000000' cellSpacing='0' cellPadding='0' " +
"style='font-size:10.0pt; font-family:Calibri; background:white;'> <TR>");
//am getting my grid's column headers
int columnscount = grid.Columns.Count;
if (columnscount > 0)
{
for (int j = 0; j < columnscount; j++)
{ //write in new column
HttpContext.Current.Response.Write("<Td>");
//Get column headers and make it as bold in excel columns
HttpContext.Current.Response.Write("<B>");
HttpContext.Current.Response.Write(grid.Columns[j].HeaderText.ToString());
HttpContext.Current.Response.Write("</B>");
HttpContext.Current.Response.Write("</Td>");
}
}
else
{
foreach (DataColumn column in table.Columns)
{
HttpContext.Current.Response.Write("<Td>");
HttpContext.Current.Response.Write("<B>");
HttpContext.Current.Response.Write(column.ColumnName);
HttpContext.Current.Response.Write("</B>");
HttpContext.Current.Response.Write("</Td>");
}
}
HttpContext.Current.Response.Write("</TR>");
foreach (DataRow row in table.Rows)
{//write in new row
HttpContext.Current.Response.Write("<TR>");
for (int i = 0; i < table.Columns.Count; i++)
{
//HttpContext.Current.Response.Write("<Td>");
HttpContext.Current.Response.Write("<style> .txt " + "\r\n" + " {mso-style-parent:style0;mso-number-format:\"" + @"\@" + "\"" + ";} " + "\r\n" + "</style>");
HttpContext.Current.Response.Write("<Td class='txt'>");
HttpContext.Current.Response.Write(row[i].ToString());
HttpContext.Current.Response.Write("</Td>");
}
HttpContext.Current.Response.Write("</TR>");
}
HttpContext.Current.Response.Write("</Table>");
HttpContext.Current.Response.Write("</font>");
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
protected void Load_ICC(int measureID)
{
SQL_utils sql = new SQL_utils();
if (print_jminfo)
{
jminfo.Text += " ==>Load_ICC..<br/>";
}
TestICC();
string sqlcode3 = "select measname from uwautism_research_backend..tblMeasure where measureID = " + measureID.ToString();
string measname = sql.StringScalar_from_SQLstring(sqlcode3);
//lblPctCoded.Text = ddl.SelectedItem + "<br/>" + x;
lblPctCoded.Text = measname;
//Pct Agree
string sqlcode_pctagree = "exec spRELv2_GET_PCTAgree_by_measure " + _content_studyID.ToString() + ", " + measureID.ToString();
if (print_jminfo)
{
jminfo.Text += " ==> " + sqlcode_pctagree + "<br/>";
}
DataTable dt_pctagree = sql.DataTable_from_SQLstring(sqlcode_pctagree);
GridView gv_PctAgree_by_subscale = (GridView)UpdatePanel_ICC.FindControl("gv_PctAgree_by_subscale");
gv_PctAgree_by_subscale.DataSource = dt_pctagree;
gv_PctAgree_by_subscale.DataBind();
//PLOTS
//UpdatePanel_plots.ContentTemplateContainer.Controls.Clear();
UpdatePanel_ICC.Visible = true;
UpdatePanel_ICC.Update();
#region Scatterplots & ICC
DataTable dt_score_vars = sql.DataTable_from_SQLstring(" select fldname, minval, maxval, fieldlabel from def.vwFld where measureID=" + measureID.ToString() + " and relitem = 2 ");
List <string> vars = dt_score_vars.AsEnumerable().Select(f => f.Field <string>("fldname")).ToList();
//foreach (string v in vars)
foreach (DataRow var_row in dt_score_vars.Rows)
{
string v = var_row["fldname"].ToString();
int minval = utilStats.MakeInt(var_row["minval"].ToString(), 0);
int maxval = utilStats.MakeInt(var_row["maxval"].ToString(), 999);
Label lbl = new Label();
lbl.Text = v + "</br>" + var_row["fieldlabel"].ToString();;
lbl.Font.Bold = true;
lbl.Font.Size = 12;
// UpdatePanel_plots.ContentTemplateContainer.Controls.Add(lbl);
UpdatePanel_plots.Controls.Add(lbl);
string x = "exec spRELv2_Get_Scores_for_var '" + v + "', " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + ", 'exclude missing', 2";
string x_missing = "exec spRELv2_Get_Scores_for_var '" + v + "', " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + ", 'missing only', 2";
DataTable dt_scatter = sql.DataTable_from_SQLstring(x);
DataTable dt_scatter_missing = sql.DataTable_from_SQLstring(x_missing);
if (dt_scatter_missing.Rows.Count > 0)
{
//show the missing cases here
}
if (dt_scatter.Rows.Count > 0)
{
foreach (DataColumn dc in dt_scatter.Columns)
{
dc.ReadOnly = false;
}
//var scat1 = utilCharts.ScatterPlots(dt_scatter, "orig_val_float", "rel_val_float", 400, 400);
//UpdatePanel_plots.ContentTemplateContainer.Controls.Add(scat1);
var data_minval_o = dt_scatter.AsEnumerable().Select(f => f.Field <double>("orig_val_float")).Min();
var data_minval_r = dt_scatter.AsEnumerable().Select(f => f.Field <double>("rel_val_float")).Min();
var data_maxval_o = dt_scatter.AsEnumerable().Select(f => f.Field <double>("orig_val_float")).Max();
var data_maxval_r = dt_scatter.AsEnumerable().Select(f => f.Field <double>("rel_val_float")).Max();
int data_minval = Convert.ToInt32((data_minval_o < data_minval_r) ? data_minval_o : data_minval_r);
int data_maxval = Convert.ToInt32((data_maxval_o < data_maxval_r) ? data_maxval_o : data_maxval_r) + 1;
//Scatterplot
string scat = utilCharts.Highcharts_Scatter("scat2" + v, dt_scatter, "orig_val_float", "rel_val_float", "series_label", "numeric", "Scatterplot of " + v, "Original value", "REL value"
, 500, 350, "pointurl", "", "", data_minval, data_maxval, data_minval, data_maxval, true, "x=y");
Literal lit_scat = new Literal();
lit_scat.Text = scat;
//F statitics
string datatype = dt_scatter.AsEnumerable().Select(f => f.Field <string>("data_type")).First();
double[] orig = utilStats.DataColumn_to_ArrayDouble(dt_scatter, "orig_val", datatype);
double[] rel = utilStats.DataColumn_to_ArrayDouble(dt_scatter, "rel_val", datatype);
utilStats.ICCstats icc = utilStats.ShroutFleissICC(dt_scatter, "orig_val", "rel_val", datatype);
Literal lit_data = new Literal();
lit_data.Text += "<br/><br/><b><i>Reproduce this in R with the following code:</i></b><br/>";
lit_data.Text += "library(psych)<br/>";
lit_data.Text += "Orig <- c( " + String.Join(",", orig.Select(p => p.ToString()).ToArray()) + ")<br/>";
lit_data.Text += "Rel <- c(" + String.Join(",", rel.Select(p => p.ToString()).ToArray()) + ")<br/>";
lit_data.Text += "d <- data.frame(cbind(Orig, Rel))<br/>";
lit_data.Text += "ICC(d, alpha=.05)";
Table tbl = new Table();
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.VerticalAlign = VerticalAlign.Top;
cell1.Controls.Add(lbl);
cell1.Controls.Add(lit_scat);
TableCell cell2 = new TableCell();
cell2.VerticalAlign = VerticalAlign.Top;
cell2.Controls.Add(utilStats.ICCstats_ToHTML(icc));
cell2.Controls.Add(lit_data);
row.Cells.Add(cell1);
row.Cells.Add(cell2);
tbl.Rows.Add(row);
//UpdatePanel_plots.ContentTemplateContainer.Controls.Add(tbl);
UpdatePanel_plots.Controls.Add(tbl);
}
else
{
//No rows returns
Label l = new Label();
l.Text = "<br/>No records returned from spRELv2_Get_Scores_for_var for measureID = " + measureID.ToString() +
"<br/>Consider updating data via: exec spRELv2_step_0b__loop_thru_meas_byStudy " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + " <br/><br/>";
l.ForeColor = Color.DarkRed;
//UpdatePanel_plots.ContentTemplateContainer.Controls.Add(l);
UpdatePanel_plots.Controls.Add(l);
}
}
//UpdatePanel_plots.Update();
UpdatePanel_plots.Visible = true;
#endregion Scatterplots & ICC
sql.Close();
}
// create proc spdatRELv2_items__for_coderpair
//(@id varchar(15), @orig_studymeasID int, @rel_studymeasID int, @rel_pkval int, @type int)
protected void gv_coderpairs_list_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "coderpair_details")
{
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int rowIndex = gvr.RowIndex;
// The sql_getdetails field is contained in this proc:
//spRELv2_GET_RelTracking_CoderPairs_by_measure
if (print_jminfo)
{
jminfo.Text += " (btn)gv_coderpairs_list_RowCommand [coderpair_details]..<br/>";
}
//Note that the SQL command text is present in the originating datasource:
string sql = e.CommandArgument.ToString();
///////////////////////////////
// Items = 1
// Scores = 2
// Text vars = 3
SqlCommand cmd = new SqlCommand();
cmd.Connection = oConnData;
cmd.CommandType = CommandType.Text;
DataTable dt = new DataTable();
for (int i = 1; i < 4; i++)
{
string s = sql + ", " + i.ToString();
cmd.CommandText = s;
SqlDataReader dr = cmd.ExecuteReader();
dt.Load(dr);
GridView gv_coderpair_details = (GridView)UpdatePanel_coderpair_single.ContentTemplateContainer.FindControl("gv_coderpair_details" + i.ToString());
gv_coderpair_details.DataSource = dt;
gv_coderpair_details.DataBind();
//dt.Dispose();
dt.Clear();
dr.Close();
}
//////////////////////////////////////////////////
//Hide other rows in the main gridview
int counter = 0;
foreach (GridViewRow row in gv_coderpairs_list.Rows)
{
if (counter == rowIndex)
{
row.Visible = true;
}
else
{
row.Visible = false;
}
counter++;
}
UpdatePanel_coderpair_single.Visible = true;
UpdatePanel_coderpair_single.Update();
}
}
protected void ImgbtnArchivo_Click(object sender, ImageClickEventArgs e)
{
string Hora = DateTime.Now.ToString("dd_MM_yyy_HH_mm");
grid = new GridView();
cn.Open();
string cmd2 = "SELECT Distinct(Usuario.UsuarioID) as UsuarioID, " +
" (Usuario.UsuarioNombre+' '+Usuario.UsuarioApellido) as UsuarioNombres, Usuario.UsuarioCedula as UsuarioCedula, " +
" PlanEmpresa.TotalClases as TotalClases, " +
" Cliente.ClienteNombre as ClienteNombre, " +
" CONVERT(VARCHAR(11),PlanEmpresa.fechaUltimo,103) as fechaUltima " +
" FROM PlanEmpresa INNER JOIN Usuario ON PlanEmpresa.UsuarioID = " +
" Usuario.UsuarioID INNER JOIN UsuarioRol ON Usuario.UsuarioID = " +
" UsuarioRol.UsuarioID INNER JOIN Cliente ON UsuarioRol.ClienteID = Cliente.ClienteID " +
" WHERE (PlanEmpresa.PlanActivo = 1) AND Cliente.ClienteID > 1 " + ViewState["sWhere"] + " ORDER BY Cliente.ClienteNombre, Usuario.UsuarioCedula ASC ";
SqlDataAdapter dAdapter = new SqlDataAdapter(cmd2, cn);
ds = new DataSet();
dAdapter.Fill(ds);
dt = ds.Tables[0];
string[] TablaID = new string[1];
TablaID[0] = "UsuarioCedula";
try
{
//Usuarios No Activos
string Inactivos = "SELECT Usuario.UsuarioID as UsuarioId, " +
" (Usuario.UsuarioNombre+' '+Usuario.UsuarioApellido) as UsuarioNombres, Usuario.UsuarioCedula as UsuarioCedula, " +
" Cliente.ClienteNombre as ClienteNombre, Cliente.ClienteID as ClienteID, " +
" PlanEmpresa.PlanActivo as PlanActivo, " +
" CONVERT(VARCHAR(11),PlanEmpresa.fechaUltimo,103) as fechaUltima, " +
" PlanEmpresa.TotalClases as TotalClases " +
" FROM PlanEmpresa INNER JOIN Usuario ON PlanEmpresa.UsuarioID = " +
" Usuario.UsuarioID INNER JOIN UsuarioRol ON Usuario.UsuarioID = " +
" UsuarioRol.UsuarioID INNER JOIN Cliente ON UsuarioRol.ClienteID = Cliente.ClienteID " +
" WHERE (PlanEmpresa.PlanActivo = 0) AND Cliente.ClienteID > 1 " + ViewState["sWhere"] + " ORDER BY PlanEmpresa.fechaUltimo DESC";
string InactivosCant = "SELECT COUNT(Usuario.UsuarioID) as UsuarioId " +
" FROM PlanEmpresa INNER JOIN Usuario ON PlanEmpresa.UsuarioID = " +
" Usuario.UsuarioID INNER JOIN UsuarioRol ON Usuario.UsuarioID = " +
" UsuarioRol.UsuarioID INNER JOIN Cliente ON UsuarioRol.ClienteID = Cliente.ClienteID " +
" WHERE (PlanEmpresa.PlanActivo = 0) AND Cliente.ClienteID > 1 " + ViewState["sWhere"];
string[] usuarioIn = new string[int.Parse(Utilidades.EjeSQL(InactivosCant, cn, ref Err, true))];
cn.Open();
SqlCommand cmd3 = new SqlCommand(Inactivos, cn);
SqlDataReader dr3 = cmd3.ExecuteReader();
int contador = 0;
while (dr3.Read())
{
usuarioIn[contador] = dr3["UsuarioId"].ToString();
contador++;
}
cn.Close();
//Comparar cada ID con los inactivos en PlanEmpresaHistorial
for (int i = 0; i < usuarioIn.Length; i++)
{
string query = "SELECT fechaUltimo FROM PlanEmpresa WHERE UsuarioID =" + usuarioIn[i];
MostrarMsjModal(query, "");
int valido = CompararFechas(query);
if (valido == 1)
{
//Usuario Valido y se ingresa al reporte
DataRow datos = dt.NewRow();
datos["UsuarioCedula"] = Utilidades.EjeSQL("SELECT UsuarioCedula as UsuarioCedula FROM Usuario WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true);
datos["UsuarioID"] = Utilidades.EjeSQL("SELECT UsuarioID as UsuarioID FROM Usuario WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true);
datos["UsuarioNombres"] = Utilidades.EjeSQL("SELECT (Usuario.UsuarioNombre+' '+Usuario.UsuarioApellido) as UsuarioNombres FROM Usuario WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true);
datos["ClienteNombre"] = Utilidades.EjeSQL("SELECT dbo.Cliente.ClienteNombre FROM dbo.Cliente " +
" INNER JOIN dbo.UsuarioRol ON dbo.Cliente.ClienteID = dbo.UsuarioRol.ClienteID INNER JOIN " +
" dbo.Usuario ON dbo.UsuarioRol.UsuarioID = dbo.Usuario.UsuarioID " +
" WHERE (dbo.Usuario.UsuarioID = " + usuarioIn[i] + ")", cn, ref Err, true);
datos["fechaUltima"] = Utilidades.EjeSQL("SELECT TOP 1 CONVERT(VARCHAR(11),PlanEmpresaFecha,103) as PlanEmpresaFecha FROM PlanEmpresaHistorial WHERE PlanEmpresaUsuarioID = " + usuarioIn[i], cn, ref Err, true);
datos["TotalClases"] = Utilidades.EjeSQL("SELECT TotalClases FROM PlanEmpresa WHERE UsuarioID = " + usuarioIn[i], cn, ref Err, true);
//ds.Tables["dt"].Rows.Add(datos);
dt.Rows.Add(datos);
}
}
GridView1.DataKeyNames = TablaID;
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception ex)
{
cn.Close();
MostrarMsjModal(ex.Message, "ERR");
}
grid.DataKeyNames = TablaID;
grid.DataSource = dt;
grid.DataBind();
cn.Close();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
System.Web.UI.HtmlControls.HtmlForm form = new System.Web.UI.HtmlControls.HtmlForm();
GridView Grid = new GridView();
grid.AllowPaging = false;
grid.DataBind();
grid.EnableViewState = false;
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(grid);
page.RenderControl(htw);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=Usuarios_Activos_" + Hora + ".xls");
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.Write(sb.ToString());
Response.End();
}
protected internal void SetOwner(GridView owner)
{
_owner = owner;
}
public void RegisterGridView(GridView view)
{
_View = view;
view.TopRowChanged += new EventHandler(view_TopRowChanged);
view.LeftCoordChanged += new EventHandler(view_LeftCoordChanged);
}
public static void BindGridViewList(IList list, GridView grid)
{
grid.DataSource = list;
grid.DataBind();
}
private void AddPlayerMinionAndEventToGridView(GridView gridView, Minion minion)
{
MinionManager.AddMinionToGridView(gridView, minion);
(gridView.Items.Last() as Grid).DragStarting += Minion_DragStarting;
}
protected void grid_data_SelectedIndexChanged(object sender, EventArgs e)
{
GridView gridData = fnGetNowGridView();
GridViewEvent.fnGridViewSelectedIndexChanged(ref gridData, "#89BBFE");
}
/// <summary>
/// Initializes the grid layout.
/// </summary>
/// <param name="grdView">The GRD view.</param>
/// <param name="columnsCollection">The columns collection.</param>
public static void InitGridLayout(this GridView grdView, List <XtraColumn> columnsCollection)
{
foreach (GridColumn grd in grdView.Columns)
{
//Check column có tồn tại k nếu k thì add thêm -KienNT
var columnCheckExits = columnsCollection.FirstOrDefault(r => r.ColumnName == grd.FieldName);
if (columnCheckExits == null)
{
columnsCollection.Add(new XtraColumn {
ColumnName = grd.FieldName, ColumnVisible = false
});
}
//check lại so sánh grid với columnsCollection nếu có thì mới cho bin template -KienNT
var column = columnsCollection.FirstOrDefault(r => r.ColumnName == grd.FieldName);
if (column != null)
{
if (grdView.Columns[column.ColumnName] != null)
{
if (column.ColumnVisible)
{
try
{
grdView.Columns[column.ColumnName].Caption = column.ColumnCaption;
grdView.Columns[column.ColumnName].VisibleIndex = column.ColumnPosition;
grdView.Columns[column.ColumnName].Width = column.ColumnWith;
grdView.Columns[column.ColumnName].UnboundType = column.ColumnType;
//grdView.Columns[column.ColumnName].Fixed = column.FixedColumn;
grdView.Columns[column.ColumnName].OptionsColumn.AllowEdit = column.AllowEdit;
grdView.Columns[column.ColumnName].ToolTip = column.ToolTip;
grdView.Columns[column.ColumnName].ColumnEdit = column.RepositoryControl;
grdView.Columns[column.ColumnName].OptionsColumn.AllowSort = DefaultBoolean.False;
if (column.IsSummnary)
{
grdView.Columns[column.ColumnName].SummaryItem.SummaryType = column.SummaryType;
grdView.Columns[column.ColumnName].SummaryItem.DisplayFormat = column.DisplayFormat;
}
//default summary in some below cases
if (column.ColumnName.Contains("AmountOC") || column.ColumnName.Contains("Amount"))
{
grdView.Columns[column.ColumnName].SummaryItem.SummaryType = SummaryItemType.Sum;
grdView.Columns[column.ColumnName].SummaryItem.DisplayFormat =
GlobalVariable.CurrencyDisplayString;
grdView.Columns[column.ColumnName].SummaryItem.Format =
Thread.CurrentThread.CurrentCulture;
}
if (column.ColumnPosition == 1)
{
grdView.Columns[column.ColumnName].SummaryItem.SummaryType = SummaryItemType.Count;
grdView.Columns[column.ColumnName].SummaryItem.DisplayFormat = @"Số dòng = {0:n0}";
}
//if (column.ColumnName.Contains("Amount") || column.ColumnName.Contains("Quantity"))
//{
// grdView.Columns[column.ColumnName].DisplayFormat.FormatString = column.DisplayFormat;
//}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, column.ColumnName,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
try
{
grdView.Columns[column.ColumnName].Visible = false;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, column.ColumnName,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
protected void grid_data_RowDataBound(object sender, GridViewRowEventArgs e)
{
GridView gridData = fnGetNowGridView();
GridViewEvent.fnGridViewRowDataBound(this, ref gridData, e.Row, 40, "#89BBFE", "#FFFFFF");
}
protected void grid_data_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
GridView gridData = fnGetNowGridView();
GridViewEvent.fnGridViewSelectedIndexChanging(this, ref gridData, "#FFFFFF", "#000000");
}
bool Cal(Int32 _Width, GridView view)
{
view.IndicatorWidth = view.IndicatorWidth < _Width ? _Width : view.IndicatorWidth;
return(true);
}
/// <summary>
/// Sets the numeric format control.
/// LinhMC bo sung them dieu kien:
/// repositoryCurrencyCalcEdit.Precision = int.Parse(DBOptionHelper.ExchangeRateDecimalDigits)/ int.Parse(DBOptionHelper.CurrencyDecimalDigits);
/// mục đích của thằng này là để làm tròn đúng số thập phân như định dạng khi người dùng nhấn công cụ tính toán
/// </summary>
/// <param name="gridView">The grid view.</param>
/// <param name="isSummary">if set to <c>true</c> [is summary].</param>
public static void SetNumericFormatControl(this GridView gridView, bool isSummary)
{
//Get format data from db to format grid control
var repositoryCurrencyCalcEdit = new RepositoryItemCalcEdit {
AllowMouseWheel = false
};
var repositoryNumberCalcEdit = new RepositoryItemCalcEdit {
AllowMouseWheel = false
};
var repositoryDateEdit = new RepositoryItemDateEdit()
{
AllowMouseWheel = false
};
foreach (GridColumn oCol in gridView.Columns)
{
if (!oCol.Visible)
{
continue;
}
switch (oCol.UnboundType)
{
case UnboundColumnType.Decimal:
repositoryCurrencyCalcEdit.Mask.MaskType = MaskType.Numeric;
if (oCol.Name == "ExchangeRate")
{
repositoryCurrencyCalcEdit.Mask.EditMask = @"c" + GlobalVariable.ExchangeRateDecimalDigits;
repositoryCurrencyCalcEdit.Precision = int.Parse(GlobalVariable.ExchangeRateDecimalDigits);
}
else
{
repositoryCurrencyCalcEdit.Mask.EditMask = @"c" + GlobalVariable.CurrencyDecimalDigits;
repositoryCurrencyCalcEdit.Precision = GlobalVariable.CurrencyDecimalDigits;
}
repositoryCurrencyCalcEdit.Mask.Culture = Thread.CurrentThread.CurrentCulture;
repositoryCurrencyCalcEdit.Mask.UseMaskAsDisplayFormat = true;
oCol.ColumnEdit = repositoryCurrencyCalcEdit;
if (isSummary)
{
oCol.SummaryItem.SummaryType = SummaryItemType.Sum;
oCol.SummaryItem.DisplayFormat = GlobalVariable.CurrencyDisplayString;
oCol.SummaryItem.Format = Thread.CurrentThread.CurrentCulture;
}
break;
case UnboundColumnType.Integer:
repositoryNumberCalcEdit.Mask.MaskType = MaskType.Numeric;
repositoryNumberCalcEdit.Mask.EditMask = @"n0";
repositoryNumberCalcEdit.Mask.UseMaskAsDisplayFormat = true;
repositoryNumberCalcEdit.Mask.Culture = Thread.CurrentThread.CurrentCulture;
oCol.ColumnEdit = repositoryNumberCalcEdit;
if (oCol.Name.ToLower().Contains("quantity"))
{
var _numberDecimalDigits = string.IsNullOrEmpty(GlobalVariable.NumberDecimalDigits) ? "0" : GlobalVariable.NumberDecimalDigits;
repositoryCurrencyCalcEdit.Mask.EditMask = @"n" + _numberDecimalDigits;
repositoryCurrencyCalcEdit.Precision = int.Parse(_numberDecimalDigits);
}
if (isSummary)
{
oCol.SummaryItem.SummaryType = SummaryItemType.Sum;
oCol.SummaryItem.DisplayFormat = GlobalVariable.NumericDisplayString;
oCol.SummaryItem.Format = Thread.CurrentThread.CurrentCulture;
}
break;
case UnboundColumnType.DateTime:
//oCol.DisplayFormat.FormatString =
// Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern;
repositoryDateEdit.Mask.MaskType = MaskType.DateTimeAdvancingCaret;
repositoryDateEdit.Mask.EditMask = @"dd/MM/yyyy";
repositoryDateEdit.DisplayFormat.FormatType = FormatType.DateTime;
repositoryDateEdit.Mask.UseMaskAsDisplayFormat = true;
oCol.ColumnEdit = repositoryDateEdit;
//oCol.DisplayFormat.FormatString = "dd/MM/yyyy";
//oCol.DisplayFormat.FormatType = FormatType.DateTime;
//oCol.DisplayFormat.Format = Thread.CurrentThread.CurrentCulture.DateTimeFormat;
break;
}
}
}
/// <summary>
/// 空数据提醒
/// </summary>
/// <param name="gv"></param>
private void SetViewEmpDataText(GridView gv)
{
gv.CustomDrawEmptyForeground += new CustomDrawEventHandler(gv_CustomDrawEmptyForeground);
}
/// <summary>
/// Indicator显示行号
/// </summary>
/// <param name="gv"></param>
private void SetViewIndicatorRowNum(GridView gv)
{
gv.IndicatorWidth = 35;
gv.CustomDrawRowIndicator += new RowIndicatorCustomDrawEventHandler(gv_CustomDrawRowIndicator);
}
public LibraryGridViewInfo(GridView view)
: base(view)
{
}
private bool cal(int _Width, GridView _View)
{
_View.IndicatorWidth = _View.IndicatorWidth < _Width ? _Width : _View.IndicatorWidth;
return(true);
}
