/// <summary> /// Executes the query and binds the results to a gridview. /// </summary> public void DataBind(SPGridView gridView, SPList list, bool initColumns) { var query = CreateSiteDataQuery(CAML.QueryScope.WebOnly); query.Lists = CAML.Lists(CAML.List(list.ID)); BindToGridView(list.ParentWeb, gridView, query, initColumns); }
private void InitializeCustomControls() { InitBar(); btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); txtOpinion = (TextBox)GetControltByMaster("txtOpinion"); chbAgree = (CheckBox)GetControltByMaster("chbAgree"); chbAgree.CheckedChanged += new EventHandler(chbAgree_CheckedChanged); spgvMaterial = new SPGridView(); spgvMaterial.AutoGenerateColumns = false; spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } if (smra != null)//已审核的情况 { btnOK.Text = "修改审核表单"; } }
protected void Page_Load(object sender, EventArgs e) { _taskID = Request.QueryString["TaskStorageID"]; this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; initControl(); BindGridView(); //添加按钮到toolbar ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness"); //新建 //ToolBarButton tbarbtnAdd = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); //tbarbtnAdd.ID = "AddNewRow"; //tbarbtnAdd.Text = "新建"; //tbarbtnAdd.ImageUrl = "/_layouts/images/newitem.gif"; //tbarbtnAdd.Click += new EventHandler(tbarbtnAdd_Click); //tbarTop.Buttons.Controls.Add(tbarbtnAdd); //修改 ToolBarButton tbarbtnEdit = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); tbarbtnEdit.ID = "EditRow"; tbarbtnEdit.Text = "修改"; tbarbtnEdit.ImageUrl = "/_layouts/images/edit.gif"; tbarbtnEdit.Click += new EventHandler(tbarbtnEdit_Click); tbarTop.Buttons.Controls.Add(tbarbtnEdit); //发送审核 //ToolBarButton tbarbtncheck = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); //tbarbtncheck.ID = "sendRow"; //tbarbtncheck.Text = "发送审核"; //tbarbtncheck.ImageUrl = "/_layouts/images/32316.GIF"; //tbarbtncheck.Click += new EventHandler(tbarbtncheck_Click); //tbarTop.Buttons.Controls.Add(tbarbtncheck); //删除 //ToolBarButton tbarbtnDelte = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); //tbarbtnDelte.ID = "DeleteRow"; //tbarbtnDelte.Text = "删除"; //tbarbtnDelte.ImageUrl = "/_layouts/images/delete.gif"; //tbarbtnDelte.Click += new EventHandler(tbarbtnDelte_Click); //StringBuilder sbScript = new StringBuilder(); //sbScript.Append("var aa= window.confirm('确认删除所选项?');"); //sbScript.Append("if(aa == false){"); //sbScript.Append("return false;}"); //tbarbtnDelte.OnClientClick = sbScript.ToString(); //tbarTop.Buttons.Controls.Add(tbarbtnDelte); ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); btnRefresh.ID = "btnRefresh"; btnRefresh.Text = "刷新"; btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF"; btnRefresh.Padding = "0,5,0,0"; btnRefresh.Click += new EventHandler(btnRefresh_Click); tbarTop.RightButtons.Controls.Add(btnRefresh); }
private void PopulateSummaryGrid() { gvPJSummary = new SPGridView { AutoGenerateColumns = false }; var colTitle = new BoundField { DataField = "name", HeaderText = "Project Name", HtmlEncode = false }; gvPJSummary.Columns.Add(colTitle); AddField("pctcomplete", "% Complete", HorizontalAlign.Center); AddField("latetasks", "# of Late Tasks", HorizontalAlign.Center); AddField("schedulestatus", "Schedule Status", HorizontalAlign.Center, false); AddField("issuestatus", "Issue Status", HorizontalAlign.Center, false); AddField("riskstatus", "Risk Status", HorizontalAlign.Center, false, "ms-vh"); gvPJSummary.AllowGrouping = false; gvPJSummary.ID = "gvPJSummary"; gvPJSummary.Width = Unit.Percentage(100); gvPJSummary.HeaderStyle.CssClass = "ms-vh"; }
protected void Page_Load(object sender, EventArgs e) { try { _storageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); _taskID = Convert.ToInt32(Request.QueryString["TaskStorageID"]); _QCbatch = Request.QueryString["QCBatch"]; control(); taskState(); initControl(); this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; BindGridView(); if (!IsPostBack) { ViewState["Temp"] = false; } saveState(); } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_LOADERROR)); } }
private void InitializeCustomControls() { InitToolBar(); //初始化物资列表 this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; switch (_type) { case "维修保养": foreach (var kvp in ShowRepairTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } break; case "回收检验": foreach (var kvp in ShowVerifyTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } break; } }
protected void Page_Load(object sender, EventArgs e) { this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; try { BindGridView(); //添加按钮到toolbar ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness"); //新建 ToolBarButton tbarbtnAdd = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); tbarbtnAdd.ID = "AddNewRow"; tbarbtnAdd.Text = "新建"; tbarbtnAdd.ImageUrl = "/_layouts/images/newitem.gif"; tbarbtnAdd.Click += new EventHandler(tbarbtnAdd_Click); tbarTop.Buttons.Controls.Add(tbarbtnAdd); //修改 ToolBarButton tbarbtnEdit = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); tbarbtnEdit.ID = "EditRow"; tbarbtnEdit.Text = "修改"; tbarbtnEdit.ImageUrl = "/_layouts/images/edit.gif"; tbarbtnEdit.Click += new EventHandler(tbarbtnEdit_Click); tbarTop.Buttons.Controls.Add(tbarbtnEdit); //删除 ToolBarButton tbarbtnDelte = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); tbarbtnDelte.ID = "DeleteRow"; tbarbtnDelte.Text = "删除"; tbarbtnDelte.ImageUrl = "/_layouts/images/delete.gif"; tbarbtnDelte.Click += new EventHandler(tbarbtnDelte_Click); StringBuilder sbScript = new StringBuilder(); sbScript.Append("var aa= window.confirm('确认删除所选项?');"); sbScript.Append("if(aa == false){"); sbScript.Append("return false;}"); tbarbtnDelte.OnClientClick = sbScript.ToString(); tbarTop.Buttons.Controls.Add(tbarbtnDelte); ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); btnRefresh.ID = "btnRefresh"; btnRefresh.Text = "刷新"; btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF"; btnRefresh.Padding = "0,5,0,0"; btnRefresh.Click += new EventHandler(btnRefresh_Click); tbarTop.RightButtons.Controls.Add(btnRefresh); } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_LOADERROR)); } }
protected void Page_Load(object sender, EventArgs e) { this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; try { toolbarInit(); initControl(); BindGridView(); LoadDefaultData(); if (!IsPostBack) { BindStorage(); } } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_LOADERROR)); } }
// end of method private void PopulateDisplayNames(ListReportView wp, ref SPGridView grv) { if (!string.IsNullOrEmpty(wp.DisplayListNames)) { _hashedNames = wp.GetListNamesInHashtable(wp.DisplayListNames); } if (!string.IsNullOrEmpty(wp.SelectedListNames)) { _selectedHashNames = wp.GetListNamesInHashtable(wp.SelectedListNames); } for (int idx = 0; idx < grv.Rows.Count; idx++) { CheckBox selectCtl = (CheckBox)grv.Rows[idx].FindControl("selectedList"); TextBox txtBox = (TextBox)grv.Rows[idx].FindControl("selectDisplayName"); HtmlInputHidden listHiddenName = (HtmlInputHidden)grv.Rows[idx].FindControl("listIdItem"); if (_selectedHashNames != null && _selectedHashNames.Count > 0) { if (_selectedHashNames.ContainsKey(listHiddenName.Value.ToString())) { selectCtl.Checked = true; } } string sDisplayName = listHiddenName.Value.ToString(); if (_hashedNames != null && _hashedNames.Count > 0) { if (_hashedNames.ContainsKey(sDisplayName)) { sDisplayName = _hashedNames[sDisplayName].ToString(); } } txtBox.Text = sDisplayName; } }
private void InitializeCustomControls() { InitToolBar(); btnQualified = GetControltByMaster("btnQualified") as Button; btnQualified.Click += new EventHandler(btnQualified_Click); btnReject = GetControltByMaster("btnReject") as Button; btnReject.Click += new EventHandler(btnReject_Click); btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); btnOK.OnClientClick = "return VerifyBtn()"; (GetControltByMaster("ltrJS") as Literal).Text = JSDialogAid.GetVerifyBtnJS(); BoundField bfColumn; //初始化spgvQualifiedMaterial this.spgvQualifiedMaterial = new SPGridView(); this.spgvQualifiedMaterial.AutoGenerateColumns = false; this.spgvQualifiedMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); this.spgvQualifiedMaterial.RowDataBound += new GridViewRowEventHandler(spgvMaterial_RowDataBound); foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; if (bfColumn.HeaderText.Equals("StorageID")) { break; } this.spgvQualifiedMaterial.Columns.Add(bfColumn); } (this.spgvQualifiedMaterial.Columns[3] as BoundField).DataField = "QualifiedGentaojian"; //初始化spgvRejectMaterial this.spgvRejectMaterial = new SPGridView(); this.spgvRejectMaterial.AutoGenerateColumns = false; this.spgvRejectMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); this.spgvRejectMaterial.RowDataBound += new GridViewRowEventHandler(spgvMaterial_RowDataBound); foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvRejectMaterial.Columns.Add(bfColumn); } spgvRejectMaterial.Columns[3].HeaderText = "待报废数量"; (this.spgvRejectMaterial.Columns[3] as BoundField).DataField = "RejectGentaojian"; //加入上传质检报告号列 HyperLinkField hlfReport = new HyperLinkField(); hlfReport.HeaderText = "上传质检报告"; this.spgvQualifiedMaterial.Columns.Insert(5, hlfReport); this.spgvRejectMaterial.Columns.Insert(5, hlfReport); }
private void InitializeCustomControls() { InitBar(); this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); this.spgvMaterial.AllowGrouping = true; this.spgvMaterial.AllowGroupCollapse = true; this.spgvMaterial.GroupDescriptionField = "Description"; this.spgvMaterial.GroupField = "MaterialName"; this.spgvMaterial.GroupFieldDisplayName = "出库物资"; BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } chbAgree = (CheckBox)GetControltByMaster("chbAgree"); chbAgree.CheckedChanged += new EventHandler(chbAgree_CheckedChanged); txtOpinion = (TextBox)GetControltByMaster("txtOpinion"); btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); }
/// <summary> /// Handles the RowEditing event of the m_AvailableGridView control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="GridViewEditEventArgs" /> instance containing the event data.</param> protected void m_AvailableGridView_RowEditing(object sender, GridViewEditEventArgs e) { SPGridView _sender = sender as SPGridView; if (_sender == null) { return; } if (!_sender.FilterFieldValue.IsNullOrEmpty()) { e.Cancel = true; string _msg = "SplittingEntryIsNotSupportedWhenFiltering".GetLocalizedString(); m_AvailablePanel.Controls.Add(ControlExtensions.CreateMessage(_msg)); return; } Label _idLabel = (Label)_sender.Rows[e.NewEditIndex].FindControlRecursive(m_IDItemLabel); if (Selection.SelectionTableRow.IsDisposal(_idLabel.Text)) { e.Cancel = true; string _msg = "SplittingTheItemForTheSelectedGoodsGroupIsNotAllowed".GetLocalizedString(); m_AvailablePanel.Controls.Add(ControlExtensions.CreateMessage(_msg)); return; } _sender.EditIndex = e.NewEditIndex; //NewEditIndex is index of the selected item in filtering mode, but unfortunately entering editing mode the filter is not active. m_AvailableGridViewSkipBinding = true; }
protected void Page_Load(object sender, EventArgs e) { _stockID = Convert.ToInt32(Request.QueryString["StockID"]); if (!string.IsNullOrEmpty(Request.QueryString["Quantity"].ToString().Trim())) { _quantity = Convert.ToDecimal(Request.QueryString["Quantity"].ToString().Trim()); } _CurUnit = Request.QueryString["CurUnit"]; this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; try { //获取登录用户ID UserLoginId = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); BindGridView(); LoadDate(); autoComplite(); initControls(); } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_LOADERROR)); } }
private void InitializeCustomControls() { InitBar(); this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); this.spgvMaterial.AllowGrouping = true; this.spgvMaterial.AllowGroupCollapse = true; this.spgvMaterial.GroupDescriptionField = "Description"; this.spgvMaterial.GroupField = "MaterialName"; this.spgvMaterial.GroupFieldDisplayName = "调拨物资"; BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); lblAuditTitle = (Label)GetControltByMaster("lblAuditTitle"); ltrInfo = GetControltByMaster("ltrInfo") as Literal; }
private void InitializeCustomControls() { //初始化ToolBar InitToolBar(); //初始化spgvMaterial this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } btnOK = GetControltByMaster("btnOK") as Button; btnOK.Click += new EventHandler(btnOK_Click); ltrInfo = GetControltByMaster("ltrInfo") as Literal; lblResult = GetControltByMaster("lblResult") as Label; lblOpinion = GetControltByMaster("lblOpinion") as Label; }
protected void Page_Load(object sender, EventArgs e) { this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; try { BindGridView(); //添加按钮到toolbar ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness"); ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); btnRefresh.ID = "btnRefresh"; btnRefresh.Text = "刷新"; btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF"; btnRefresh.Padding = "0,5,0,0"; btnRefresh.Click += new EventHandler(btnRefresh_Click); tbarTop.RightButtons.Controls.Add(btnRefresh); } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_LOADERROR)); } }
protected override void CreateChildControls() { errorLiteral = new Literal(); this.Controls.Add(errorLiteral); gridView = new SPGridView(); gridView.AutoGenerateColumns = false; gridView.AllowSorting = true; gridView.Sorting += new GridViewSortEventHandler(gridView_Sorting); gridView.AllowPaging = true; gridView.PageIndex = 0; gridView.PageIndexChanging += new GridViewPageEventHandler(gridView_PageIndexChanging); gridView.PagerSettings.Mode = PagerButtons.NumericFirstLast; gridView.PagerSettings.Position = PagerPosition.Bottom; gridView.PagerSettings.PageButtonCount = 10; gridView.PagerSettings.Visible = true; gridView.PageSize = 10; // this odd statement is required in order to get the pagination to work with an SPGridView! gridView.PagerTemplate = null; Panel gridPanel = new Panel(); gridPanel.Controls.Add(gridView); this.Controls.Add(gridPanel); }
private void InitializeCustomControls() { InitBar(); this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); lblProduceAuditTitle = (Label)GetControltByMaster("lblProduceAuditTitle"); lblProduceResult = (Label)GetControltByMaster("lblProduceResult"); lblProduceOpinion = (Label)GetControltByMaster("lblProduceOpinion"); //添加选择列 TemplateField tfSelect = new TemplateField(); tfSelect.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow); tfSelect.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header); this.spgvMaterial.Columns.Insert(0, tfSelect); //加入调拨数量(根/台/套/件)列 TemplateField tfGentaojian = new TemplateField(); tfGentaojian.HeaderText = "调拨数量(根/台/套/件)"; tfGentaojian.ItemTemplate = new TextBoxTemplate("Gentaojian", "Gentaojian", "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(5, tfGentaojian); //加入调拨数量(米)列 TemplateField tfMetre = new TemplateField(); tfMetre.HeaderText = "调拨数量(米)"; tfMetre.ItemTemplate = new TextBoxTemplate("Metre", "Metre", "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(7, tfMetre); //加入调拨数量(根/台/套/件)列 TemplateField tfTon = new TemplateField(); tfTon.HeaderText = "调拨数量(吨)"; tfTon.ItemTemplate = new TextBoxTemplate("Ton", "Ton", "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(9, tfTon); //加入备注列 TemplateField tfRemark = new TemplateField(); tfRemark.HeaderText = "备注"; tfRemark.ItemTemplate = new TextBoxTemplate("Remark", DataControlRowType.DataRow, "Remark"); this.spgvMaterial.Columns.Insert(10, tfRemark); }
void spgvMaterial_PageIndexChanging(object sender, GridViewPageEventArgs e) { SPGridView spgv = sender as SPGridView; spgv.PageIndex = e.NewPageIndex; spgv.DataBind(); }
/// <summary> /// Binds this query to an SPGridView control. /// </summary> /// <param name="web"></param> /// <param name="gridView"></param> /// <param name="query"></param> /// <param name="initColumns"></param> private void BindToGridView(SPWeb web, SPGridView gridView, SPSiteDataQuery query, bool initColumns) { // Execute the query. DataTable table = web.GetSiteData(query); // Initialize the gridview columns, if requested if (initColumns) { gridView.AutoGenerateColumns = false; gridView.Columns.Clear(); foreach (var col in table.Columns.Cast <DataColumn>() .Where(IsBindableColumn) .Select(column => new BoundField { DataField = column.ColumnName, HeaderText = string.IsNullOrEmpty(column.Caption) ? column.ColumnName : column.Caption })) { gridView.Columns.Add(col); } } // Bind the data to the view. gridView.DataSource = table; gridView.DataBind(); }
private void InitializeCustomControls() { InitToolBar(); dtcVerifyTime = GetControltByMaster("dtcVerifyTime") as DateTimeControl; txtRemark = GetControltByMaster("txtRemark") as TextBox; btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); //初始化spgvMaterial this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } }
private void initControl() { this.spgviewQualityControl = new SPGridView(); this.spgviewQualityControl.Columns.Clear(); this.spgviewQualityControl.AutoGenerateColumns = false; this.spgviewQualityControl.RowCreated += new GridViewRowEventHandler(spgviewSupplierType_RowCreated); BindGridView(); btnOk = new Button(); btnCancel = new Button(); btnEdit = new Button(); btnOk.Text = "生成质检清单"; btnEdit.Text = "修改质检清单"; btnCancel.Text = "取消"; btnCancel.Width = 100; btnOk.Click += new EventHandler(btnOk_Click); btnCancel.Click += new EventHandler(btnCancel_Click); btnEdit.Click += new EventHandler(btnEdit_Click); Panel p1 = (Panel)GetControltByMaster("Panel1"); Panel p2 = (Panel)GetControltByMaster("Panel2"); chbQuickSet = (CheckBox)GetControltByMaster("chbQuickSet"); this.chbQuickSet.CheckedChanged += new EventHandler(chbQuickSet_CheckedChanged); p2.Controls.Add(btnOk); p2.Controls.Add(btnEdit); p2.Controls.Add(btnCancel); }
private void BindToSPGridView(SPGridView gridView, System.Data.DataView childView) { SPBoundField boundField; List<string> fieldsList = new List<string>() { "ExpenseType", "CostCenter", "ItemAmount", "GLAccount" }; foreach (string fieldsName in fieldsList) { boundField = new SPBoundField(); string headerText = fieldsName; //if (fieldsName == "EECWWorkflowNumber") //{ // headerText = "WorkflowNumber"; //} if (fieldsName == "ItemAmount") { headerText = "Amount"; } boundField.HeaderText = headerText; boundField.DataField = fieldsName; gridView.Columns.Add(boundField); } //HiddenField hidWorkflowID = (HiddenField)gridView.Parent.FindControl("hidWorkflowID"); //gridView.NamingContainer.Controls.Add(hidWorkflowID); gridView.DataSource = childView; gridView.PagerTemplate = null; gridView.DataBind(); }
protected override void CreateChildControls() { base.CreateChildControls(); SPWeb web = SPContext.Current.Web; var lists = web.Lists.Cast <SPList>(); webLists = new SPGridView(); webLists.AutoGenerateColumns = false; webLists.DataSource = lists; webLists.Columns.Add(new BoundField() { DataField = "Title", HeaderText = "List Name" }); webLists.Columns.Add(new BoundField() { DataField = "ItemCount", HeaderText = "No Items" }); webLists.Columns.Add(new CommandField() { HeaderText = "Action", ControlStyle = { Width = new Unit(70) }, SelectText = "Show Items", ShowSelectButton = true }); webLists.DataKeyNames = new string[] { "Title" }; webLists.DataBind(); Controls.Add(webLists); webLists.SelectedIndexChanged += new EventHandler(webLists_SelectedIndexChanged); }
private void MovePage(SPGridView gridView, Selection.SelectionTableDataTable destination, Selection.SelectionTableDataTable source) { foreach (GridViewRow _cr in gridView.Rows) { Label _idLabel = (Label)_cr.FindControlRecursive(m_IDItemLabel); Selection.SelectionTableRow _slctdItem = source.FindByID(_idLabel.Text); destination.GetRow(_slctdItem); } }
void BindGridView(string detailsID, string processType, string reportNum) { //throw new NotImplementedException(); this.gviewFiles = new SPGridView();; TemplateField tfCheckbox = new TemplateField(); tfCheckbox.ItemTemplate = new CheckBoxTemplate("选择所有/取消", DataControlRowType.DataRow, "FileID"); tfCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header); this.gviewFiles.Columns.Add(tfCheckbox); BoundField bfFileName = new BoundField(); bfFileName.HeaderText = "质检报告"; bfFileName.DataField = "NameOfFile"; this.gviewFiles.Columns.Add(bfFileName); BoundField bfCreateTime = new BoundField(); bfCreateTime.HeaderText = "创建时间"; bfCreateTime.DataField = "FileCreateTime"; this.gviewFiles.Columns.Add(bfCreateTime); //CommandField cf = new CommandField(); //cf.ButtonType = ButtonType.Link; //cf.ShowDeleteButton = true; //cf.HeaderText = "操作"; //this.gviewFiles.Columns.Add(cf); this.gviewFiles.AutoGenerateColumns = false; this.gviewFiles.GridLines = GridLines.None; this.gviewFiles.CssClass = "ms-vh2 padded headingfont"; //this.gviewFiles.DataKeyNames = new string[] { "FileID" }; //this.gviewFiles.RowDeleting +=new GridViewDeleteEventHandler(gviewFiles_RowDeleting); //this.gviewFiles.RowDataBound += new GridViewRowEventHandler(gviewFiles_RowDataBound); //this.gviewMoreTaskForMyMsg.AllowPaging = true; //this.gviewMoreTaskForMyMsg.PageSize = 1; //this.gviewMoreTaskForMyMsg.PageIndexChanging +=new GridViewPageEventHandler(gviewMoreTaskForMyMsg_PageIndexChanging); //this.gviewMoreTaskForMyMsg.PagerTemplate = new SPGridViewPagerTemplate("{0} - {1}", gviewMoreTaskForMyMsg); using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { this.gviewFiles.DataSource = from fqc in dc.FileOfQC where fqc.Filed1 == detailsID && fqc.Filed2 == processType && fqc.Filed3 == reportNum select new { fqc.NameOfFile, fqc.FileID, fqc.FileCreateTime }; this.gviewFiles.DataBind(); } }
private void InitializeCustomControls() { InitToolBar(); btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); //初始化spgvMaterial this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } //加入合格数量列 TemplateField tfQualified = new TemplateField(); tfQualified.HeaderText = "合格数量"; tfQualified.ItemTemplate = new TextBoxTemplate("Qualified", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(4, tfQualified); //加入待报废列 TemplateField tfReject = new TemplateField(); tfReject.HeaderText = "待报废数量"; tfReject.ItemTemplate = new TextBoxTemplate("Reject", string.Empty, "^(-?\\d+)(\\.\\d+)?$", "0", 80); this.spgvMaterial.Columns.Insert(5, tfReject); //加入质检报告号列 TemplateField tfRetrieveCode = new TemplateField(); tfRetrieveCode.HeaderText = "质检报告号"; tfRetrieveCode.ItemTemplate = new TextBoxTemplate("VerifyCode", DataControlRowType.DataRow); this.spgvMaterial.Columns.Insert(6, tfRetrieveCode); //加入质检日期列 TemplateField tfRealVerifyDate = new TemplateField(); tfRealVerifyDate.HeaderText = "质检日期"; tfRealVerifyDate.ItemTemplate = new DateTimeTemplate(DataControlRowType.DataRow); this.spgvMaterial.Columns.Insert(7, tfRealVerifyDate); //加入备注列 TemplateField tfRemark = new TemplateField(); tfRemark.HeaderText = "备注"; tfRemark.ItemTemplate = new TextBoxTemplate("备注", DataControlRowType.DataRow, "Remark"); this.spgvMaterial.Columns.Insert(8, tfRemark); }
private void InitializeCustomControls() { InitBar(); this.spgvMaterial = new SPGridView(); this.spgvMaterial.AutoGenerateColumns = false; this.spgvMaterial.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); this.spgvMaterial.AllowGrouping = true; this.spgvMaterial.AllowGroupCollapse = true; this.spgvMaterial.GroupDescriptionField = "Description"; this.spgvMaterial.GroupField = "MaterialName"; this.spgvMaterial.GroupFieldDisplayName = "出库物资"; BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvMaterial.Columns.Add(bfColumn); } //加入实际出库数量(根/台/套/件)列 TemplateField tfGentaojian = new TemplateField(); tfGentaojian.HeaderText = "出库(根/台/套/件)"; tfGentaojian.ItemTemplate = new TextBoxTemplate("Gentaojian", "RealGentaojian", "^(-?\\d+)(\\.\\d+)?$", 60); this.spgvMaterial.Columns.Insert(8, tfGentaojian); //加入实际出库数量(米)列 TemplateField tfMetre = new TemplateField(); tfMetre.HeaderText = "出库(米)"; tfMetre.ItemTemplate = new TextBoxTemplate("Metre", "RealMetre", "^(-?\\d+)(\\.\\d+)?$", 60); this.spgvMaterial.Columns.Insert(10, tfMetre); //加入实际出库数量(根/台/套/件)列 TemplateField tfTon = new TemplateField(); tfTon.HeaderText = "出库(吨)"; tfTon.ItemTemplate = new TextBoxTemplate("Ton", "RealTon", "^(-?\\d+)(\\.\\d+)?$", 60); this.spgvMaterial.Columns.Insert(12, tfTon); //加入备注列 TemplateField tfRemark = new TemplateField(); tfRemark.HeaderText = "备注"; tfRemark.ItemTemplate = new TextBoxTemplate("备注", DataControlRowType.DataRow, "Remark"); this.spgvMaterial.Columns.Insert(14, tfRemark); btnOK = (Button)GetControltByMaster("btnOK"); btnOK.Click += new EventHandler(btnOK_Click); lblProduceAuditTitle = (Label)GetControltByMaster("lblProduceAuditTitle"); lblMaterialAuditTitle = (Label)GetControltByMaster("lblMaterialAuditTitle"); }
protected void Page_Load(object sender, EventArgs e) { //if (!string.IsNullOrEmpty(Request.QueryString["StorageOutDetailsID"])) //{ //} this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; init(); BindGridView(); //初始化质检合格表 if (!string.IsNullOrEmpty(Request.QueryString["StorageOutDetailsID"])) { using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { var cg = from u in dc.StorageOutDetails where u.StorageOutDetailsID == Convert.ToInt32(Request.QueryString["StorageOutDetailsID"].ToString()) orderby u.StorageOutDetailsID ascending select new { u.FinanceCode, u.Gentaojian }; var li = cg.ToList(); for (int i = 0; i < this.gv.Rows.Count; i++) { TextBox tb = (TextBox)(this.gv.Rows[i].Cells[5].Controls[0]); tb.Text = li[i].FinanceCode.ToString(); TextBox ti = (TextBox)(this.gv.Rows[i].Cells[6].Controls[0]); ti.Text = li[i].Gentaojian.ToString(); } } } if (!IsPostBack) { } //添加按钮到toolbar ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness"); //返回 ToolBarButton tbarbtnBack = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); tbarbtnBack.ID = "backRow"; tbarbtnBack.Text = "返回"; tbarbtnBack.ImageUrl = "/_layouts/images/BACK.GIF"; tbarbtnBack.Click += new EventHandler(tbarbtnBack_Click); tbarTop.Buttons.Controls.Add(tbarbtnBack); ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); btnRefresh.ID = "btnRefresh"; btnRefresh.Text = "刷新"; btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF"; btnRefresh.Padding = "0,5,0,0"; btnRefresh.Click += new EventHandler(btnRefresh_Click); tbarTop.RightButtons.Controls.Add(btnRefresh); }
protected override void CreateChildControls() { var claimsUser = Page.User as IClaimsPrincipal; if (claimsUser != null) { DataRow dr; DataTable claimsTable = new DataTable(); claimsTable.Columns.Add("Type", typeof(string)); claimsTable.Columns.Add("Value", typeof(string)); IClaimsIdentity ci = (IClaimsIdentity)claimsUser.Identity; foreach (Claim c in ci.Claims) { dr = claimsTable.NewRow(); dr["Type"] = c.ClaimType.ToString(); dr["Value"] = c.Value.ToString(); claimsTable.Rows.Add(dr); } // Standard SPGridView to display our claims table SPGridView claimsGrid = new SPGridView(); // This eventhandler is used to add the word-break style //claimsGrid.RowDataBound += new GridViewRowEventHandler(claimsGrid_RowDataBound); // AutoGenerate must be false for SPGridView claimsGrid.AutoGenerateColumns = false; claimsGrid.DataSource = claimsTable; SPBoundField boundField; boundField = new SPBoundField(); boundField.HeaderText = "Type"; boundField.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; boundField.DataField = "Type"; claimsGrid.Columns.Add(boundField); boundField = new SPBoundField(); boundField.HeaderText = "Value"; boundField.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; boundField.DataField = "Value"; claimsGrid.Columns.Add(boundField); for (int i = 0; i < claimsGrid.Columns.Count; i++) { claimsGrid.Columns[i].ItemStyle.Wrap = true; // Distribute the columns evenly claimsGrid.Columns[i].ItemStyle.Width = Unit.Percentage(100 / claimsGrid.Columns.Count); } claimsGrid.DataBind(); this.Controls.Add(claimsGrid); } }
private void InitializeCustomControls() { InitToolBar(); this.spgvSubDoc = new SPGridView(); this.spgvSubDoc.AutoGenerateColumns = false; this.spgvSubDoc.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); BoundField bfColumn; foreach (var kvp in ShowTlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgvSubDoc.Columns.Add(bfColumn); } //添加选择列 TemplateField tfieldCheckbox = new TemplateField(); tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "SrinSubDocID"); tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header); this.spgvSubDoc.Columns.Insert(0, tfieldCheckbox); SPMenuField colMenu = new SPMenuField(); colMenu.HeaderText = "清点负责人"; colMenu.TextFields = "TakerName"; colMenu.MenuTemplateId = "spmfTaker"; colMenu.NavigateUrlFields = "SrinSubDocID,Taker"; //定义方式:"列名1,列名2..." colMenu.NavigateUrlFormat = "ManageSrinSubDetails.aspx?SubDocID={0}&IsValidate=true"; colMenu.TokenNameAndValueFields = "curID=SrinSubDocID,takerID=Taker"; //定义方式:"别名1=列名1,别名2=列名2...." MenuTemplate menuItemCollection = new MenuTemplate(); menuItemCollection.ID = "spmfTaker"; MenuItemTemplate mitMaterial = new MenuItemTemplate("提交清点", "/_layouts/images/newitem.gif"); mitMaterial.ClientOnClickNavigateUrl = "SrinDispatchCenter.aspx?TaskType=物资组清点&FormID=%curID%&Executor=%takerID%"; menuItemCollection.Controls.Add(mitMaterial); this.Controls.Add(menuItemCollection); this.spgvSubDoc.Columns.Insert(1, colMenu); this.spgvSubDoc.RowDataBound += new GridViewRowEventHandler(spgvSubDoc_RowDataBound); //添加任务详情列 HyperLinkField hlfTask = new HyperLinkField(); hlfTask.HeaderText = "任务详情"; this.spgvSubDoc.Columns.Insert(8, hlfTask); }
private void BindToSPGridView(SPGridView gridView, System.Data.DataView childView) { SPBoundField boundField; List<string> fieldsList = new List<string>() {"ExpenseType", "GLAccount", "CostCenter", "ApprovedRmbAmt" }; foreach (string fieldsName in fieldsList) { boundField = new SPBoundField(); boundField.HeaderText = fieldsName; boundField.DataField = fieldsName; gridView.Columns.Add(boundField); } HiddenField hidWorkflowID = (HiddenField)gridView.Parent.FindControl("hidWorkflowID"); //gridView.NamingContainer.Controls.Add(hidWorkflowID); gridView.DataSource = childView; gridView.PagerTemplate = null; gridView.DataBind(); }
private void BindToSPGridView(SPGridView gridView, System.Data.DataView childView) { SPBoundField boundField; List<string> fieldsList = new List<string>() { "ExpenseType", "CostCenter", "DealAmount", "AmountType", "GLAccount"}; foreach (string fieldsName in fieldsList) { boundField = new SPBoundField(); string headerText = fieldsName; //if (fieldsName == "CCCWWorkflowNumber") //{ // headerText = "WorkflowNumber"; //} if (fieldsName == "DealAmount") { headerText = "Amount"; } if (fieldsName == "AmountType") { headerText = "Currency"; } boundField.HeaderText = headerText; boundField.DataField = fieldsName; gridView.Columns.Add(boundField); } gridView.DataSource = childView; gridView.PagerTemplate = null; gridView.DataBind(); }
public void BindGrid(SPGridView grid) { grid.DataSource = PropertyCollection.DefaultView; grid.DataBind(); }
private void BindToSPGridView(SPGridView gridView, System.Data.DataView childView) { SPBoundField boundField; List<string> fieldsList = new List<string>() { "AssetNo", "ExpenseType", "CostCenter", "ItemAmount", "GLAccount" }; foreach (string fieldsName in fieldsList) { boundField = new SPBoundField(); boundField.HeaderText = fieldsName; boundField.DataField = fieldsName; gridView.Columns.Add(boundField); } gridView.DataSource = childView; gridView.PagerTemplate = null; gridView.DataBind(); }
protected void GenerateBoundFields(SPGridView grid) { ((TemplateField)grid.Columns[1]).HeaderText = ViewFields.FirstOrDefault().Title; foreach (var field in ViewFields.Skip(1)) { var boundField = new SPBoundField() { HeaderText = field.Title, DataField = field.Id.ToString(), }; boundField.HeaderStyle.CssClass = "ms-vh2"; boundField.ItemStyle.CssClass = "ms-cellstyle ms-vb2"; grid.Columns.Add(boundField); } }
/// <summary> /// Create all your controls here for rendering. /// Try to avoid using the RenderWebPart() method. /// </summary> protected override void CreateChildControls() { if (!_error) { try { //Getting the Public URL to handle http & https url issues string _publicURL = GetPublicUrl(); _publicURL = ""; base.CreateChildControls(); gvTaskList = new SPGridView(); gvTaskList.Width = Unit.Percentage(100); gvTaskList.AutoGenerateColumns = false; gvTaskList.BorderStyle = BorderStyle.Dotted; //Adding Title Field SPMenuField nameMenu = new SPMenuField(); nameMenu.HeaderText = "Title"; nameMenu.TextFields = "Title"; nameMenu.MenuTemplateId = "TaskListMenu"; nameMenu.NavigateUrlFields = "Task Ref"; nameMenu.TokenNameAndValueFields = "Task Ref=Task Ref"; //nameMenu.NavigateUrlFormat = _publicURL + "/{0}"; nameMenu.SortExpression = "Due Date"; //Adding Due Date Field BoundField dueDate = new BoundField(); dueDate.DataField = "Due Date"; dueDate.HeaderText = "Due Date"; dueDate.SortExpression = "Due Date"; //Adding Due Date Field BoundField documentAuthor = new BoundField(); documentAuthor.DataField = "Document Author"; documentAuthor.HeaderText = "Document Author"; documentAuthor.SortExpression = "Document Author"; //Adding DropDown Menu for 'Evidence Log' TaskListMenu = new MenuTemplate(); TaskListMenu.ID = "TaskListMenu"; MenuItemTemplate evidenceLogMenu = new MenuItemTemplate("Open", "/_layouts/images/actionseditpage.gif"); evidenceLogMenu.ClientOnClickNavigateUrl = "%Task Ref%"; //Adding Controls to Control Collection TaskListMenu.Controls.Add(evidenceLogMenu); this.Controls.Add(TaskListMenu); gvTaskList.Columns.Add(nameMenu); gvTaskList.Columns.Add(dueDate); gvTaskList.Columns.Add(documentAuthor); this.Controls.Add(gvTaskList); gvTaskList.PagerTemplate = null; } catch (Exception ex) { HandleException(ex); } } }