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