private void ConfigureImportUsersSearchResultsGridViewColumns()
{
UPSBrowserLogger.LogDebug(loggingCategory, "ConfigureImportUsersSearchResultsGridViewColumns invoked");
HyperLinkField col1 = new HyperLinkField();
col1.HeaderText = "Display Name";
col1.DataTextField = "DisplayName";
col1.SortExpression = "DisplayName";
ImportUsersSearchResultsGridView.Columns.Add(col1);
SPBoundField col2 = new SPBoundField();
col2.HeaderText = "Work Email";
col2.DataField = "WorkEmail";
col2.SortExpression = "WorkEmail";
ImportUsersSearchResultsGridView.Columns.Add(col2);
SPBoundField col3 = new SPBoundField();
col3.HeaderText = "Job title";
col3.DataField = "JobTitle";
col3.SortExpression = "JobTitle";
ImportUsersSearchResultsGridView.Columns.Add(col3);
SPBoundField col4 = new SPBoundField();
col4.HeaderText = "Department";
col4.DataField = "Department";
col4.SortExpression = "Department";
ImportUsersSearchResultsGridView.Columns.Add(col4);
}
/// <summary>
/// 动态绑定项
/// </summary>
private void SetDataGridColumn(GridView GridView1)
{
GridView1.Columns.Clear();
HyperLinkField lnkField = new HyperLinkField();
lnkField.HeaderText = "标题";
lnkField.DataTextField = "Title";
lnkField.DataNavigateUrlFormatString = "{0}";
lnkField.ItemStyle.Wrap = true;
lnkField.DataNavigateUrlFields = new string[] { "Path" };
GridView1.Columns.Add(lnkField);
BoundField bindCol = new BoundField();
bindCol = new BoundField();
bindCol.ReadOnly = true;
bindCol.HeaderText = "作者";
bindCol.DataField = "Author";
GridView1.Columns.Add(bindCol);
bindCol = new BoundField();
bindCol.ReadOnly = true;
bindCol.HeaderText = "创建时间";
bindCol.DataField = "Created";
GridView1.Columns.Add(bindCol);
}
private void BindGrid()
{
SqlCommand cmd = new SqlCommand("select * from tblUser", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
if (i == 0)
{
HyperLinkField b = new HyperLinkField();
b.HeaderText = dt.Columns[i].ColumnName;
b.DataTextField = dt.Columns[i].ColumnName;
b.DataNavigateUrlFormatString = "Default.aspx?Id={0}";
b.DataNavigateUrlFields = new string[] { dt.Columns[i].ColumnName };
b.Target = "_blank";
GridView1.Columns.Add(b);
}
else
{
BoundField b = new BoundField();
b.HeaderText = dt.Columns[i].ColumnName;
b.DataField = dt.Columns[i].ColumnName;
GridView1.Columns.Add(b);
}
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
// reName to better
private void SetHyperLink(DataColumn dataColumn, string[] str, string entity, string tableFolder, bool enableLInk)
{
var hypField = new HyperLinkField();
string imgArrowDown = Application["Branding"] + "/Images/arrow-down.jpg";
string imgArrowUp = Application["Branding"] + "/Images/arrow-up.jpg";
var split = " ";
var strPath = "";
if (dataColumn.ColumnName.Contains("Name"))
{
split = dataColumn.ColumnName.Replace("Name", " Name");
hypField.HeaderText = split;
}
else if (dataColumn.ColumnName.Contains("Id"))
{
split = dataColumn.ColumnName.Replace("Id", " Id");
hypField.HeaderText = split;
}
else
{
hypField.HeaderText = dataColumn.ColumnName;
}
hypField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
hypField.DataTextField = dataColumn.ColumnName;
hypField.DataNavigateUrlFields = new string[] { "SystemEntityType" };
if (!enableLInk)
{
hypField.SortExpression = dataColumn.ColumnName;
hypField.NavigateUrl = "~/{0}/Details.aspx?category=testdata";
}
MainGridView.Columns.Add(hypField);
}
/// <summary>
/// LInk column.
/// </summary>
/// <param name="dataTextFieldName">Column bound field</param>
/// <param name="urlFormatValue">url ; like http://google.ro?asta={0}</param>
public void AddHyperlinkColumn(string dataTextFieldName, string urlFormatValue)
{
ReferenceColumnName = dataTextFieldName;
if (string.IsNullOrEmpty(ReferenceColumnName))
{
return;
}
if (urlFormatValue.ToString().Contains("javascript:"))
{
typeOfLinkColumn = TypeOfLinkColumn.JavaScriptFunction;
urlFormatValue = urlFormatValue.Replace("javascript:", "");
}
if (string.IsNullOrEmpty(urlFormatValue))
{
urlFormatValue = "javascript:return false;";
}
if (!string.IsNullOrEmpty(dataTextFieldName))
{
//increment number of mandatory columns
referenceColumnsNumber++;
HyperLinkField hyperLinkField = new HyperLinkField();
string[] field = new string[1];
field[0] = dataTextFieldName;
hyperLinkField.DataNavigateUrlFields = field;
hyperLinkField.DataNavigateUrlFormatString = urlFormatValue; // "http://google.ro?asta={0}";
hyperLinkField.HeaderText = dataTextFieldName;
hyperLinkField.DataTextField = dataTextFieldName;
hyperLinkField.SortExpression = dataTextFieldName;
hyperLinkField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
this.Columns.Add(hyperLinkField);
}
#region #TemplateBuilder Columns
// Now becomes:
//<asp:TemplateField ItemStyle-HorizontalAlign="Center" HeaderText="Tracking" SortExpression="Tracking">
// <ItemTemplate>
// <asp:HyperLink ID="idTracking" runat="server" NavigateUrl='<%# "ShowMapLocation(" + Eval("Longitude", "{0}") + "," + Eval("Latitude","{0}") + ")" %>' Text='<%# Eval("Tracking") %>'/>
// </ItemTemplate>
//</asp:TemplateField> With a supporting piece of CS:
//protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// HyperLink hl = (HyperLink)e.Row.FindControl("idTracking");
// hl.NavigateUrl = "javascript:" + hl.NavigateUrl;
// }
//}
#endregion
}
protected void OnSearchClicked(object sender, EventArgs e)
{
//Event handler for search button clicked
this.grdImages.Columns.Clear();
this.grdImages.DataSource = null;
this.grdImages.DataBind();
DataSet ds = getSearchData();
if (ds != null && ds.Tables[0] != null)
{
//Configures grid columns based upon new data and sets new data source
DataColumnCollection cols = ds.Tables[0].Columns;
for (int i = 2; i < cols.Count; i++)
{
BoundField bField = new BoundField();
string colName = cols[i].ColumnName;
bField.DataField = colName;
bField.HeaderText = XmlConvert.DecodeName(colName.Substring(colName.IndexOf("_") + 1));
bField.SortExpression = XmlConvert.EncodeName(colName);
bField.ControlStyle.Width = 144;
this.grdImages.Columns.Add(bField);
}
HyperLinkField hlField = new HyperLinkField();
hlField.DataTextField = cols[0].ColumnName;
hlField.DataNavigateUrlFields = new string[] { cols[1].ColumnName };
hlField.HeaderText = "Image Link";
hlField.Target = "_blank";
this.grdImages.Columns.Add(hlField);
this.grdImages.DataSource = ds.Tables[0];
this.grdImages.DataBind();
//this.upnlPage.Update();
}
}
private void AddProcedures(string[] str, string procedureName, string tableName, string tableFolder, bool procedureHide)
{
var hypUpdateField = new HyperLinkField {
HeaderText = procedureName
};
hypUpdateField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
hypUpdateField.Text = procedureName;
hypUpdateField.DataNavigateUrlFields = str;
if (tableFolder == " ")
{
hypUpdateField.DataNavigateUrlFormatString = "~/" + tableName + "/" + procedureName + ".aspx?SetId={0}";
}
else
{
hypUpdateField.DataNavigateUrlFormatString = "~/" + tableFolder + "/" + tableName + "/" + procedureName + ".aspx?SetId={0}";
}
hypUpdateField.Visible = !procedureHide;
MainGridView.Columns.Add(hypUpdateField);
ViewState[procedureName] = MainGridView.Columns.Count - 1;
// To put the Update and Delete buttons at the right Index during RowCreated Event han
//ViewState[procedureName] = dt.Columns.IndexOf(procedureName);
}
public void DefineActionsGrid()
{
if (this._Actions.Trim() != "" && this._Actions.Trim() != "")
{
GenericCLX.CS.Util objUtil = new GenericCLX.CS.Util();
//objUtil.GetConfig("");
string strLocationUrlFull = objUtil.LocationUrlFull.Trim();
string[] arrStrActions = this._Actions.Split(chrDelimiter);
string[] arrStrAcronyms = this._Acronyms.Split(chrDelimiter);
for (int i = 0; i < arrStrActions.Length; i++)
{
if (arrStrActions[i].Trim() != "" && arrStrAcronyms[i].Trim() != "")
{
HyperLinkField objLink = new HyperLinkField();
objLink.Text = "<img src=\"/GenericCLX/img/" + arrStrActions[i] + ".gif\" border=\"0\" class=\"hand\"/>";
string[] arrDataNavigateUrlFields = new string[1];
arrDataNavigateUrlFields[0] = this._ID;
objLink.DataNavigateUrlFields = arrDataNavigateUrlFields;
objLink.DataNavigateUrlFormatString = strLocationUrlFull + this._Module + "/" + this._Title + "/" + this._Title + arrStrAcronyms[i] + ".aspx?" + this._ID + "={0}";
objLink.HeaderText = arrStrActions[i];
objLink.HeaderStyle.HorizontalAlign = (HorizontalAlign)2;
objLink.ItemStyle.HorizontalAlign = (HorizontalAlign)2;
this._Grid.Columns.Add(objLink);
}
}
}
}
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);
}
protected void bindResultsGrid()
{
foreach (var selectedField in targetSearch.OutputColumns)
{
if (selectedField.Name == "Membership.ID")
{
continue;
}
TemplateField templateField = new TemplateField
{
HeaderText = selectedField.DisplayName,
ItemTemplate = new SearchResultColumnTemplate(selectedField.Name),
HeaderStyle = { HorizontalAlign = HorizontalAlign.Left },
ItemStyle = { VerticalAlign = VerticalAlign.Top }
};
gvMembers.Columns.Add(templateField);
}
HyperLinkField field = new HyperLinkField
{
DataNavigateUrlFields = new[] { "Membership.ID" },
DataNavigateUrlFormatString = "~/membership/ViewMembership.aspx?contextID={0}",
Text = "(view)",
ItemStyle = { VerticalAlign = VerticalAlign.Top }
};
gvMembers.Columns.Add(field);
gvMembers.DataSource = dvResults;
gvMembers.DataBind();
}
/// <summary>
/// 这个事件会在渲染每一行前调用，因此改变了列的属性，那么渲染每一行时此列的属性都发生了变化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_PreRowDataBound(object sender, ExtAspNet.GridPreRowEventArgs e)
{
LinkButtonField lbfAction1 = Grid1.FindColumn("lbfAction1") as LinkButtonField;
LinkButtonField lbfAction2 = Grid1.FindColumn("lbfAction2") as LinkButtonField;
CheckBoxField cbxAtSchool = Grid1.FindColumn("cbxAtSchool") as CheckBoxField;
if (e.RowIndex < 5)
{
cbxAtSchool.Enabled = true;
lbfAction1.Enabled = true;
lbfAction2.Enabled = true;
}
else
{
cbxAtSchool.Enabled = false;
lbfAction1.Enabled = false;
lbfAction2.Enabled = false;
}
// 如果绑定到 DataTable，那么这里的 DataItem 就是 DataRowView
HyperLinkField linkField = Grid1.Columns[4] as HyperLinkField;
DataRowView row = e.DataItem as DataRowView;
if (row != null)
{
linkField.DataTextFormatString = "{0} (" + row["EntranceYear"].ToString() + ")";
}
}
private void UpdateGridView()
{
gvOrders.Columns.Clear();
gvOrders.DataSource = null;
gvOrders.DataBind();
DataTable data = Order.AllPendingDataTable();
if (data == null || data.Rows.Count == 0)
{
return;
}
// Setup Columns
// Id
BoundField bfNOrder = new BoundField();
bfNOrder.HeaderText = "#";
bfNOrder.DataField = "id";
gvOrders.Columns.Add(bfNOrder);
// Shipping Address
BoundField bfShippingAddress = new BoundField();
bfShippingAddress.HeaderText = "Shippig Address";
bfShippingAddress.DataField = "shipping_address";
gvOrders.Columns.Add(bfShippingAddress);
// Date
BoundField bfDate = new BoundField();
bfDate.HeaderText = "Ordered At";
bfDate.DataField = "date";
bfDate.DataFormatString = "{0:dd-MM-yyyy}";
gvOrders.Columns.Add(bfDate);
gvOrders.DataSource = data;
gvOrders.AutoGenerateColumns = false;
// Details Button
HyperLinkField hlDetails = new HyperLinkField();
hlDetails.HeaderText = "Actions";
hlDetails.Text = "Details";
hlDetails.ControlStyle.CssClass = "btn btn-primary btn-sm";
hlDetails.DataNavigateUrlFormatString = "AdminOrderDetails.aspx?id={0}";
hlDetails.DataNavigateUrlFields = new string[] { "id" };
gvOrders.Columns.Add(hlDetails);
// Finish Button
HyperLinkField hlFinish = new HyperLinkField();
hlFinish.Text = "Finish";
hlFinish.ControlStyle.CssClass = "btn btn-success btn-sm";
hlFinish.DataNavigateUrlFormatString = "AdminFinishOrder.aspx?id={0}";
hlFinish.DataNavigateUrlFields = new string[] { "id" };
gvOrders.Columns.Add(hlFinish);
gvOrders.DataBind();
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
BoundField bfColumn;
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "StockTransferID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.gv.Columns.Add(tfieldCheckbox);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "单据编号";
colMenu.TextFields = "StockTransferNum";
colMenu.MenuTemplateId = "actionMenu";
colMenu.NavigateUrlFields = "StockTransferID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "StockTransferDetailsManage.aspx?StockTransferID={0}";
colMenu.TokenNameAndValueFields = "cStockTransferID=StockTransferID"; //定义方式:"别名1=列名1,别名2=列名2...."
HyperLinkField hlTask = new HyperLinkField();
hlTask.HeaderText = "任务详情";
//hlTask.DataNavigateUrlFields = new string []{ "StockTransferID" };
//hlTask.DataNavigateUrlFormatString = "javaScript:onClick=window.showModalDialog(encodeURI('../PublicPage/TaskHistoryInfo.aspx?NoticeID={0}&&TaskType=正常入库'),'0','resizable:true;dialogWidth:800px;dialogHeight:600px')";
//hlTask.DataNavigateUrlFormatString = "www.google.com?a={0}";
//hlTask.Text = "任务详情";
//hlTask.Text = "<a href=\"javaScript:onClick=window.showModalDialog(encodeURI('../PublicPage/TaskHistoryInfo.aspx?NoticeID={0}&&TaskType=正常入库'),'0','resizable:true;dialogWidth:800px;dialogHeight:600px')\">任务详情</a>";
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "actionMenu";
MenuItemTemplate createMenuItem = new MenuItemTemplate("组长审批", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "StockTransferCreateTask.aspx?StockTransferID=%cStockTransferID%&&TaskType=物资组长审核信息&&BackUrl=" + HttpContext.Current.Request.Url.PathAndQuery;
//editMenuItem.ClientOnClickScript = "if(!window.confirm('确认删除所选项?')) return false;window.location.href='StorageEdit.aspx?StorageID=%curStorageID%'";//%curStorageID%代表别名curStorageID，而StorageID代表数据库的表中的列名
//editMenuItem.ClientOnClickScript = "window.location.href='StorageEdit.aspx?StorageID=%curStorageID%&curTime=" + DateTime.Now.ToString() + "'";
menuItemCollection.Controls.Add(createMenuItem);
this.Controls.Add(menuItemCollection);
this.gv.Columns.Add(colMenu);
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.gv.Columns.Add(bfColumn);
}
this.gv.Columns.Insert(4, hlTask);
this.gv.DataSource = from a in db.StockTransfer
select a;
this.gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound);
this.gv.DataBind();
this.gv.Columns[5].Visible = false;
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.gv);
}
}
private void UpdateGridView()
{
gvProducts.Columns.Clear();
gvProducts.DataSource = null;
gvProducts.DataBind();
DataTable data = Product.AllDataTable();
if (data == null || data.Rows.Count == 0)
{
return;
}
// Setup Columns
// Id
BoundField bfNProduct = new BoundField();
bfNProduct.HeaderText = "#";
bfNProduct.DataField = "id";
gvProducts.Columns.Add(bfNProduct);
// Name
BoundField bfName = new BoundField();
bfName.HeaderText = "Name";
bfName.DataField = "name";
gvProducts.Columns.Add(bfName);
// Price
BoundField bfPrice = new BoundField();
bfPrice.HeaderText = "Price";
bfPrice.DataField = "price";
bfPrice.DataFormatString = "{0:C}";
gvProducts.Columns.Add(bfPrice);
// Stock
BoundField bfStock = new BoundField();
bfStock.HeaderText = "Stock";
bfStock.DataField = "stock";
gvProducts.Columns.Add(bfStock);
gvProducts.DataSource = data;
gvProducts.AutoGenerateColumns = false;
// Details Button
HyperLinkField hlDetails = new HyperLinkField();
hlDetails.HeaderText = "Actions";
hlDetails.Text = "Details";
hlDetails.ControlStyle.CssClass = "btn btn-primary btn-sm";
hlDetails.DataNavigateUrlFormatString = "AdminProductDetails.aspx?id={0}";
hlDetails.DataNavigateUrlFields = new string[] { "id" };
gvProducts.Columns.Add(hlDetails);
gvProducts.DataBind();
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (!string.IsNullOrEmpty(Request.QueryString["QCBatch"]))
{
QCbatch = Request.QueryString["QCBatch"];
}
BoundField bfColumn;
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.gv.Columns.Add(bfColumn);
}
//添加选择列
HyperLinkField hlTask = new HyperLinkField();
hlTask.HeaderText = "上传质检报告";
this.gv.Columns.Insert(4, hlTask);
this.gv.DataSource = from a in db.StorageInTest
join b in db.StorageInMain on a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID equals b.StorageInID
where a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == _storageInID && a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == (string.IsNullOrEmpty(QCbatch) ? a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex : QCbatch)
select new
{
a.StorageInTestID,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.MaterialInfo.MaterialName,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.MaterialInfo.SpecificationModel,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.MaterialInfo.FinanceCode,
b.StorageInCode,
a.TestGentaojian,
a.TestMetre,
a.TestTon,
a.FailedGentaojian,
a.FailedMetre,
a.FailedTon,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.ProjectInfo.ProjectName,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.ExpectedTime,
a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex,
a.InspectionReportNum,
a.Remark
};
this.gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound);
this.gv.DataBind();
this.gv.Columns[this.gv.Columns.Count - 1].Visible = false;
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.gv);
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
catgrySerchResultGridView1.DataSource = search.proSearch("proName", quertString);
hplnk = new HyperLinkField();
hplnk.DataTextField = search.proSearch("proName", quertString).ToString();
hplnk.HeaderText = search.proSearch("proName", quertString).ToString();
catgrySerchResultGridView1.Columns.Add(hplnk);
catgrySerchResultGridView1.DataBind();
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
hplnk = new HyperLinkField();
quertString = Request.QueryString["srchValue"].ToString();
search = new Product();
catgrySerchResultGridView1.DataSource = search.proSearch("proName", quertString);
catgrySerchResultGridView1.DataBind();
}
static private HyperLinkField CreateHyperLinkField(string[] aapanUrlNavigateVar, string apanUrlText, string apanUrl)
{
HyperLinkField lcHyperLinkField = new HyperLinkField();
lcHyperLinkField.DataNavigateUrlFields = aapanUrlNavigateVar;
lcHyperLinkField.DataTextField = apanUrlText;
lcHyperLinkField.DataNavigateUrlFormatString = apanUrl;
return(lcHyperLinkField);
}
protected override void LoadResources()
{
base.LoadResources();
HyperLinkField field = (List.Columns[0] as HyperLinkField);
if (field != null)
{
field.Text = Resources.RulesControl_List_Caption;
field.DataNavigateUrlFormatString = CustomUrlProvider.CreateApplicationAbsoluteUrl(ResourceProvider.VirtualRootShortPath + "admin/rules.aspx?RuleEngineId={0:N}");
}
}
/// <summary>
///
/// </summary>
/// <param name="cfg"></param>
/// <returns></returns>
private static DataControlField CreateHyperLinkField(GridViewColumnConfig cfg)
{
//throw new NotImplementedException();
HyperLinkField hlf = new HyperLinkField();
hlf.HeaderText = cfg.HeaderText;
hlf.Text = cfg.HyperLinkText;
hlf.DataNavigateUrlFields = cfg.DataNavigateUrlFields;
hlf.DataNavigateUrlFormatString = cfg.DataNavigateUrlFormatString;
return(hlf);
}
protected void Page_Load(object sender, EventArgs e)
{
HtmlLink cssLnk = new HtmlLink();
cssLnk.Attributes.Add("rel", "stylesheet");
cssLnk.Attributes.Add("type", "text/css");
cssLnk.Href = "http://jqueryui.com/latest/themes/base/ui.all.css";
Page.Header.Controls.Add(cssLnk);
ControlGenerator.AddScriptControl(Page.Master.Page.Header.Controls, "http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js");
ControlGenerator.AddScriptControl(Page.Master.Page.Header.Controls, "http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.1/jquery-ui.js");
if (IsPostBack)
{
if (ViewState["SearchCriteria"] != null)
{
_searchCriteria = (TitleSearchCriteria)ViewState["SearchCriteria"];
_isExactSearch = (bool)ViewState["IsExactSearch"];
_orderBy = (TitleSearchOrderBy)ViewState["OrderBy"];
_sortOrder = (SortOrder)ViewState["SortOrder"];
}
pagingUserControl.Visible = true;
}
else
{
pagingUserControl.Visible = false;
BHLProvider bp = new BHLProvider();
CustomGenericList <Institution> institutions = bp.InstituationSelectAll();
listInstitutions.DataSource = institutions;
listInstitutions.DataBind();
}
String redirect = Request.QueryString["redir"] as String;
if (redirect != null)
{
if (redirect.ToLower() == "p")
{
litHeader.Text = "Pagination";
liImport.Visible = false;
divImport.Visible = false;
HyperLinkField linkField = (HyperLinkField)gvwResults.Columns[2];
linkField.NavigateUrl = "/Admin/Paginator.aspx";
linkField.DataNavigateUrlFormatString = "/Admin/Paginator.aspx?TitleID={0}";
_redirectUrl = "/Admin/Paginator.aspx?TitleID=";
}
}
errorControl.Visible = false;
Page.SetFocus(titleTextBox);
Page.Title = "BHL Admin - Title Search";
}
protected override void LoadResources()
{
base.LoadResources();
HyperLinkField field = (List.Columns[1] as HyperLinkField);
if (field != null)
{
field.Text = Resources.GroupsControl_List_RolesLinkColumns_Text;
field.DataNavigateUrlFormatString = CustomUrlProvider.CreateApplicationAbsoluteUrl(string.Concat(ResourceProvider.GroupsInstancesRolesPageVirtualPath, "?GroupId={0:N}"));
}
}
public void HyperLinkField_DefaultProperty()
{
HyperLinkField field = new HyperLinkField();
Assert.AreEqual(0, ((Array)field.DataNavigateUrlFields).Length, "DataNavigateUrlFields");
Assert.AreEqual("", field.DataNavigateUrlFormatString, "DataNavigateUrlFormatString");
Assert.AreEqual("", field.DataTextField, "DataTextField");
Assert.AreEqual("", field.DataTextFormatString, "DataTextFormatString");
Assert.AreEqual("", field.NavigateUrl, "NavigateUrl");
Assert.AreEqual("", field.Target, "Target");
Assert.AreEqual("", field.Text, "Text");
}
private void CreateGridView()
{
Grid = new GridView();
Grid.ID = "Grid";
Grid.CssClass = "flGrid";
Grid.DataKeyNames = new string[] { FileIdColumnName };
Grid.AutoGenerateColumns = false;
Grid.GridLines = GridLines.None;
Grid.ShowHeader = false;
Grid.RowDataBound += new GridViewRowEventHandler(Grid_RowDataBound);
Grid.RowDeleting += new GridViewDeleteEventHandler(Grid_RowDeleting);
HyperLinkField linkField = new HyperLinkField();
linkField.DataNavigateUrlFields = new string[] { UrlColumnName };
linkField.DataTextField = NameColumnName;
linkField.HeaderText = Resources.FileList_FileNameText;
linkField.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
linkField.Target = "_blank";
if (this.ShowIcons)
{
BoundField iconField = new BoundField();
Grid.Columns.Add(iconField);
}
else
{
linkField.ItemStyle.CssClass = "flFirst";
}
Grid.Columns.Add(linkField);
BoundField lengthField = new BoundField();
lengthField.DataField = LengthInKBColumnName;
lengthField.DataFormatString = "{0:N0} KB";
lengthField.HeaderStyle.Wrap = false;
lengthField.HeaderText = Resources.FileList_SizeText;
lengthField.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
lengthField.ItemStyle.Wrap = false;
Grid.Columns.Add(lengthField);
if (this.EnableDeleting)
{
ButtonField deleteField = new ButtonField();
deleteField.CausesValidation = false;
deleteField.CommandName = DataList.DeleteCommandName;
deleteField.Text = this.DeleteButtonText;
deleteField.ControlStyle.CssClass = "flRemove";
deleteField.ItemStyle.Wrap = false;
Grid.Columns.Add(deleteField);
}
}
protected override void LoadResources()
{
base.LoadResources();
TemplateField tempField = (List.Columns[0] as TemplateField);
if (tempField != null)
{
tempField.HeaderText = Resources.RulesControl_List_OrderNumberColumn_HeaderText;
}
HyperLinkField linkField = (List.Columns[1] as HyperLinkField);
if (linkField != null)
{
linkField.HeaderText = Resources.RulesControl_List_InputParametersLinkColumns_HeaderText;
linkField.Text = Resources.RulesControl_List_InputParametersLinkColumns_Text;
linkField.DataNavigateUrlFormatString = CustomUrlProvider.CreateApplicationAbsoluteUrl(ResourceProvider.VirtualRootShortPath + "admin/ruleparameters.aspx?RuleId={0:N}");
linkField.HeaderGroup = Resources.RulesControl_List_ParametersLinkColumns_HeaderGroup;
}
linkField = (List.Columns[2] as HyperLinkField);
if (linkField != null)
{
linkField.HeaderText = Resources.RulesControl_List_OutputParametersLinkColumns_HeaderText;
linkField.Text = Resources.RulesControl_List_OutputParametersLinkColumns_Text;
linkField.DataNavigateUrlFormatString = CustomUrlProvider.CreateApplicationAbsoluteUrl((string)FormRuleEngine.DataKey["OutputEditPage"]);
linkField.HeaderGroup = Resources.RulesControl_List_ParametersLinkColumns_HeaderGroup;
}
tempField = (List.Columns[6] as TemplateField);
if (tempField != null)
{
tempField.HeaderText = Resources.RulesControl_List_LastUsedUserColumn_HeaderText;
}
List.Columns[7].HeaderText = Resources.RulesControl_List_LastUsedDateColumn_HeaderText;
tempField = (List.Columns[8] as TemplateField);
if (tempField != null)
{
tempField.HeaderText = Resources.RulesControl_List_CreatedByColumn_HeaderText;
}
List.Columns[9].HeaderText = Resources.RulesControl_List_CreatedDateColumn_HeaderText;
Initialize(FormRuleEngine);
FormRuleEngine.Visible = true;
FormRuleEngine.AutoGenerateEditButton = FormRuleEngine.AutoGenerateInsertButton = false;
LoadResources(FormRuleEngine, this.GetType().BaseType.Name);
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string value = e.Row.Cells[2].Text;
if (value == "0")
{
e.Row.Cells[2].Text = "Não";
}
else if (value == "1")
{
e.Row.Cells[2].Text = "Sim";
}
value = e.Row.Cells[3].Text;
switch (value)
{
case "0":
e.Row.Cells[3].Text = "Espera confirmação";
e.Row.Cells[4].Visible = false;
break;
case "1":
e.Row.Cells[3].Text = "Espera deslocamento";
e.Row.Cells[4].Visible = false;
break;
case "2":
e.Row.Cells[3].Text = "Em progresso";
e.Row.Cells[4].Visible = false;
break;
case "3":
e.Row.Cells[3].Text = "Espera Pagamento";
HyperLinkField hp = (HyperLinkField)GridView1.Columns[4];
GridView1.Columns[4].Visible = true;
GridView1.Columns[5].Visible = true;
hp.NavigateUrl = String.Format("~/Account/Payments/Payment?PaymentID={0}", e.Row.Cells[5].Text);
hp.Text = "Pagar";
e.Row.Cells[4].Visible = true;
break;
case "4":
e.Row.Cells[3].Text = "Completo";
e.Row.Cells[4].Visible = false;
break;
}
}
}
// reName to better
private void SetHyperLink(DataColumn dataColumn, bool enableLInk)
{
var hypField = new HyperLinkField();
var split = " ";
hypField.HeaderText = dataColumn.ColumnName;
hypField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
hypField.DataTextField = dataColumn.ColumnName;
hypField.Target = "_blank";
if (!enableLInk)
{
hypField.SortExpression = dataColumn.ColumnName;
var strQueryString = new StringBuilder();
if (AdvancedModeGrouping == GridViewAdvancedModeGrouping.TimeInterval)
{
hypField.DataNavigateUrlFields = new string[] { "SystemEntityId", "EntityKey", "AuditActionId", "PersonId", "Start", "End" };
strQueryString.Append("SystemEntity={0}&");
strQueryString.Append("EntityKey={1}&");
strQueryString.Append("AuditAction={2}&");
strQueryString.Append("ActionBy={3}&");
strQueryString.Append("Start={4:yyyy-MM-dd hh-mm-ss tt}&");
strQueryString.Append("End={5:yyyy-MM-dd hh-mm-ss tt}&");
//strQueryString.Append("Start=" + HttpUtility.UrlEncode("{4}") + "&");
//strQueryString.Append("End=" + HttpUtility.UrlEncode("{5}") + "");
}
else if (AdvancedModeGrouping == GridViewAdvancedModeGrouping.AuditAction)
{
hypField.DataNavigateUrlFields = new string[] { "SystemEntityId", "EntityKey", "AuditActionId" };
strQueryString.Append("SystemEntity={0}&");
strQueryString.Append("EntityKey={1}&");
strQueryString.Append("AuditAction={2}");
}
else if (AdvancedModeGrouping == GridViewAdvancedModeGrouping.ActionByAndAuditAction)
{
hypField.DataNavigateUrlFields = new string[] { "SystemEntityId", "EntityKey", "AuditActionId", "PersonId" };
strQueryString.Append("SystemEntity={0}&");
strQueryString.Append("EntityKey={1}&");
strQueryString.Append("AuditAction={2}&");
strQueryString.Append("ActionBy={3}");
}
//hypField.DataNavigateUrlFields = str;
hypField.DataNavigateUrlFormatString = "~/History/HistoryRecordDetails.aspx?" + strQueryString;
}
MainGridView.Columns.Add(hypField);
}
protected void databind()
{
GridView1.DataSource = ziyuands;
GridView1.Columns.Clear();
if (ziyuands.Tables[0].Rows.Count > 0)
{
HyperLinkField bf1 = new HyperLinkField();
bf1.HeaderText = "资源名称";
bf1.DataTextField = "资源名称";
string[] pram = { "资源文件" };
bf1.DataNavigateUrlFields = pram;
bf1.DataNavigateUrlFormatString = "{0}";
BoundField bf2 = new BoundField();
bf2.ReadOnly = true;
bf2.HeaderText = "资源类型";
bf2.DataField = "资源类型";
BoundField bf3 = new BoundField();
bf3.ReadOnly = true;
bf3.HeaderText = "文件类型";
bf3.DataField = "文件类型";
BoundField bf4 = new BoundField();
bf4.ReadOnly = true;
bf4.HeaderText = "介绍";
bf4.DataField = "介绍";
BoundField bf5 = new BoundField();
bf5.ReadOnly = true;
bf5.HeaderText = "上传时间";
bf5.DataField = "上传时间";
BoundField bf6 = new BoundField();
bf6.ReadOnly = true;
bf6.HeaderText = "上传者";
bf6.DataField = "上传者";
HyperLinkField bf8 = new HyperLinkField();
bf8.HeaderText = "播放";
string[] param = { "资源ID" };
bf8.DataNavigateUrlFields = param;
bf8.DataNavigateUrlFormatString = "play.aspx?id={0}";
bf8.Target = "_blank";
bf8.Text = "播放";
GridView1.Columns.Add(bf1);
GridView1.Columns.Add(bf2);
GridView1.Columns.Add(bf3);
GridView1.Columns.Add(bf4);
GridView1.Columns.Add(bf6);
GridView1.Columns.Add(bf5);
GridView1.Columns.Add(bf8);
GridView1.DataBind();
}
}
private DataTable GetAllStudents()
{
string _subADPath = "LDAP://OU=东北大学本科生,DC=ccc,DC=neu,DC=edu,DC=cn";
if (ViewState["OUName"] == null)
{
_subADPath = "LDAP://OU=东北大学本科生,DC=ccc,DC=neu,DC=edu,DC=cn";
}
else
{
_subADPath = ViewState["OUName"].ToString();
}
string[] bjs = getBanJi();
DataTable dt = new DataTable();
HyperLinkField lnkField;
lstBanJi.Items.Clear();
lstBanJi.Items.Add("全部");
foreach (string subBj in bjs)
{
lstBanJi.Items.Add(subBj);
dt.Columns.Add(subBj);
dt.Columns.Add(subBj + "blog");
lnkField = new HyperLinkField();
lnkField.HeaderText = subBj;
lnkField.DataTextField = subBj;
lnkField.DataNavigateUrlFormatString = "{0}";
lnkField.DataNavigateUrlFields = new string[] { subBj + "blog" };
GridView1.Columns.Add(lnkField);
}
int totalStudents = 0;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
string bjAdPath;
foreach (string subBj in bjs)
{
bjAdPath = GetClassEntry(_subADPath, subBj);
if (bjAdPath != "")
{
totalStudents += GetStudentByClass(bjAdPath, ref dt, subBj);
}
}
});
StudentCount = totalStudents;
return(dt);
}
private void BindGrid(string userID, string reportID)
{
SubscribeDB.UpdateReadStates(userID, reportID, true);
if (!System.IO.Directory.Exists(Server.MapPath("../Csv/" + userID)))
{
return;
}
string[] files = System.IO.Directory.GetFiles(Server.MapPath("../Csv/" + userID), "*.csv");
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("报表");
dt.Columns.Add("生成时间");
dt.Columns.Add("路径");
foreach (string str in files)
{
string s = str.Substring(str.LastIndexOf('['));
if (s.StartsWith("[" + reportID + "]"))
{
DataRow row = dt.NewRow();
row[2] = s;
s = s.Substring(s.IndexOf(']') + 1);
row[0] = s.Substring(0, s.IndexOf('('));
s = s.Substring(s.IndexOf('(') + 1);
row[1] = s.Substring(0, 4) + "年" + s.Substring(4, 2) + "月" + s.Substring(6, 2) + "日" + s.Substring(8, 2) + "时";
dt.Rows.Add(row);
}
}
gridCsv.Columns.Clear();
gridCsv.AutoGenerateColumns = false;
for (int i = 0; i < 2; i++)
{
BoundField col = new BoundField();
col.HeaderText = dt.Columns[i].ColumnName;
col.DataField = dt.Columns[i].ColumnName;
gridCsv.Columns.Add(col);
}
HyperLinkField btnCol = new HyperLinkField();
btnCol.Text = "下载";
btnCol.DataNavigateUrlFormatString = "../Csv/" + userID + "/{0}";
btnCol.DataNavigateUrlFields = new string[1] {
dt.Columns[2].ColumnName
};
gridCsv.Columns.Add(btnCol);
gridCsv.DataSource = dt;
gridCsv.DataBind();
Boco.CommonToolLibrary.Grid.Grid.HyperLinkFieldEncodeHack(gridCsv);
}
private bool InitInfoList(List<String[]> list)
{
//办理历史列表
DataTable dtHistory = ReadGridView();
DataTable dt = ReadGridView();
int dtI = 0;
int dtHistoryI = 0;
for (int i = 0; i < list.Count; ++i)
{
if (list[i][5] != "已办理")
{
DataRow row = dt.NewRow();
row.ItemArray = new object[] { list[i][0], list[i][1], list[i][2], list[i][3], list[i][4] };
dt.Rows.InsertAt(row, dtI++);
}
else
{
DataRow row = dtHistory.NewRow();
row.ItemArray = new object[] { list[i][0], list[i][1], list[i][2], list[i][3], list[i][4] };
dtHistory.Rows.InsertAt(row, dtHistoryI++);
}
}
dt.AcceptChanges();
carFinesInfoList.DataSource = dt;
carFinesInfoList.DataBind();
HyperLinkField hyperLinkField = new HyperLinkField();
hyperLinkField.HeaderText = "处理情况";
carFinesInfoList.Columns.Add(hyperLinkField);
hyperLinkField.Text = "未处理";
hyperLinkField.NavigateUrl = "http://www.baidu.com";
carFinesInfoList.DataBind();
dtHistory.AcceptChanges();
historyFinesInfoList.DataSource = dtHistory;
historyFinesInfoList.DataBind();
return true;
}
private void InitializateGrid()
{
if (DetailConditions != null && !string.IsNullOrEmpty(TableName) && TableName.Length > 0)
{
gvListData.PageSize = 25;
gvListData.AllowPaging = true;
foreach (SearchExpander seardcondition in DetailConditions)
{
//===========================================================================
//Bound field when not have detail & not refference
if (!seardcondition.HasDetail && seardcondition.Refference == null)
{
BoundField boundField = new BoundField();
boundField.DataField = seardcondition.ColumnName;
boundField.HeaderText = seardcondition.Display;
if (seardcondition.PKType == typeof(DateTime))
{
boundField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
boundField.DataFormatString = "{0:dd/MM/yyyy}";
}
gvListData.Columns.Add(boundField);
}
//===========================================================================
//Link field when not have detail & have refference
else if (!seardcondition.HasDetail && seardcondition.Refference != null)
{
string RefTableName = WebCore.GetTableName(seardcondition.Refference);
if (seardcondition.HasLinkRef)
{
string BeetwenTableName = WebCore.GetTableName(seardcondition.Type);
HyperLinkField linkField = new HyperLinkField();
if (seardcondition.Type == null) linkField.DataNavigateUrlFields = new string[] { "ClientId", seardcondition.ColumnName };
else linkField.DataNavigateUrlFields = new string[] { "ClientId", BeetwenTableName + seardcondition.RefferenceColumn };
linkField.DataNavigateUrlFormatString = FriendlyUrl.Href("~/list").ToLower() + "/" + RefTableName.ToLower() + "/{0}/{1}";
linkField.HeaderText = seardcondition.Display;
if (seardcondition.Type == null) linkField.DataTextField = RefTableName + seardcondition.DisplayRefferenceColumn;
else linkField.DataTextField = RefTableName + seardcondition.DisplayRefferenceColumn;
if (seardcondition.DisplayRefferenceColumn.ToLower().Contains("date"))
{
linkField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
linkField.DataTextFormatString = "{0:dd/MM/yyyy}";
}
gvListData.Columns.Add(linkField);
}
else
{
BoundField linkField = new BoundField();
if (seardcondition.Type == null) linkField.DataField = RefTableName + seardcondition.DisplayRefferenceColumn;
else linkField.DataField = RefTableName + seardcondition.DisplayRefferenceColumn;
linkField.HeaderText = seardcondition.Display;
gvListData.Columns.Add(linkField);
}
}
//===========================================================================
//Link field when have detail
else
{
HyperLinkField linkField = new HyperLinkField();
linkField.DataNavigateUrlFields = new string[] { "ClientId", "Id" };
linkField.DataNavigateUrlFormatString = FriendlyUrl.Href("~/detail").ToLower() + "/" + TableName.ToLower().Replace("detail", "") + "/{0}/{1}";
linkField.HeaderText = seardcondition.Display;
linkField.DataTextField = seardcondition.ColumnName;
gvListData.Columns.Add(linkField);
}
}
}
}
private void BindGrid(string orderBy)
{
//TableSchema.Table schema = DataService.GetTableSchema(tableName, providerName);
if (Schema != null && Schema.PrimaryKey != null)
{
SetTableName(Schema);
Query query = new Query(Schema);
string sortColumn = null;
if(!String.IsNullOrEmpty(orderBy))
{
sortColumn = orderBy;
}
else if(ViewState[ORDER_BY] != null)
{
sortColumn = (string)ViewState[ORDER_BY];
}
int colIndex = -1;
if (!String.IsNullOrEmpty(sortColumn))
{
ViewState.Add(ORDER_BY, sortColumn);
TableSchema.TableColumn col = Schema.GetColumn(sortColumn);
if(col == null)
{
for (int i = 0; i < Schema.Columns.Count; i++)
{
TableSchema.TableColumn fkCol = Schema.Columns[i];
if(fkCol.IsForeignKey && !String.IsNullOrEmpty(fkCol.ForeignKeyTableName))
{
TableSchema.Table fkTbl = DataService.GetSchema(fkCol.ForeignKeyTableName, ProviderName, TableType.Table);
if(fkTbl != null)
{
col = fkTbl.Columns[1];
colIndex = i;
break;
}
}
}
}
if(col != null && col.MaxLength < 2048)
{
if (ViewState[SORT_DIRECTION] == null || ((string)ViewState[SORT_DIRECTION]) == SqlFragment.ASC)
{
if (colIndex > -1)
{
query.OrderBy = OrderBy.Asc(col, SqlFragment.JOIN_PREFIX + colIndex);
}
else
{
query.OrderBy = OrderBy.Asc(col);
}
ViewState[SORT_DIRECTION] = SqlFragment.ASC;
}
else
{
if (colIndex > -1)
{
query.OrderBy = OrderBy.Desc(col, SqlFragment.JOIN_PREFIX + colIndex);
}
else
{
query.OrderBy = OrderBy.Desc(col);
}
ViewState[SORT_DIRECTION] = SqlFragment.DESC;
}
}
}
DataTable dt = query.ExecuteJoinedDataSet().Tables[0];
grid.DataSource = dt;
grid.AutoGenerateColumns = false;
grid.Columns.Clear();
HyperLinkField link = new HyperLinkField();
link.Text = "Edit";
link.DataNavigateUrlFields = new string[] { Schema.PrimaryKey.ColumnName };
link.DataNavigateUrlFormatString = HttpContext.Current.Request.CurrentExecutionFilePath + "?id={0}";
grid.Columns.Insert(0, link);
for (int i = 0; i < Schema.Columns.Count; i++ )
{
BoundField field = new BoundField();
field.DataField = dt.Columns[i].ColumnName;
field.SortExpression = dt.Columns[i].ColumnName;
//field.SortExpression = Utility.QualifyColumnName(Schema.Name, dt.Columns[i].ColumnName, Schema.ProviderType);
field.HtmlEncode = false;
if (Schema.Columns[i].IsForeignKey)
{
TableSchema.Table schema;
if(Schema.Columns[i].ForeignKeyTableName == null)
{
schema = DataService.GetForeignKeyTable(Schema.Columns[i], Schema);
}
else
{
schema = DataService.GetSchema(Schema.Columns[i].ForeignKeyTableName, ProviderName, TableType.Table);
}
if (schema != null)
{
field.HeaderText = schema.DisplayName;
}
}
else
{
field.HeaderText = Schema.Columns[i].DisplayName;
}
field.HeaderText = CleanColumnName(field.HeaderText);
if (!Utility.IsAuditField(dt.Columns[i].ColumnName))
{
grid.Columns.Add(field);
}
}
grid.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region Initialize Values and Form Execution
if (Session["ReportTempCriteriaID"] != null)
hTable = CareerCruisingWeb.CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedSnap", Session["ReportTempCriteriaID"].ToString(), 1);
if (Session["ReportSavedCriteriaID"] != null)
hTable = CareerCruisingWeb.CCLib.Common.Forms.GetCriteriaData("Port_ReportsSavedState", Session["ReportSavedCriteriaID"].ToString(), 4);
// set the connection string into the data source
sqlDataSource.ConnectionString = ConfigurationManager.AppSettings["strConLocal"];
string toolTypeDirectoryCommand = "SELECT MainDirectory FROM Port_Type_Tool_Lookup WHERE ToolID = " + ((CareerCruisingWeb.PageBase.SuperBase) Page).ToolTypeID;
string toolTypeDirectory = CareerCruisingWeb.CCLib.Common.DataAccess.GetValue(toolTypeDirectoryCommand).ToString();
if (!IsPostBack)
{
HyperLinkField field = new HyperLinkField();
field.HeaderText = "Parent/Guardian Name";
field.DataTextField = "ParentFullName";
field.DataTextFormatString = "{0:c}";
field.DataNavigateUrlFields = new string[] { "ParentID", "PortfolioID" };
if (toolTypeDirectory == "School/")
field.DataNavigateUrlFormatString = "~/" + toolTypeDirectory + "Reports/ReportsParentLoginHistoryDetail.aspx?ParentID={0}&PortfolioID={1}";
else
field.DataNavigateUrlFormatString = "~/" + toolTypeDirectory + "ReportsParentLoginHistoryDetail.aspx?ParentID={0}&PortfolioID={1}";
field.ItemStyle.Wrap = false;
if (!Convert.ToBoolean(((CareerCruisingWeb.PageBase.SuperBase)Page).PortTypeElements["Rep_ParLog_Name"]))
{
field.SortExpression = "LName, FName";
}
loginHistoryGridView.Columns.Insert(0, field);
}
// bind the results of the above command to the result grid
sqlDataSource.SelectCommand = CommandText;
loginHistoryGridView.DataBind();
DataTable dtLoginHistory = null;
// for export control
if (strExpType != "")
{
// retrieve the underlying view and convert to a datatable for the export
DataSourceSelectArguments args = new DataSourceSelectArguments();
DataView view = (DataView)sqlDataSource.Select(args);
dtLoginHistory = view.ToTable();
dtsLoginHistory = new DataTable[] { dtLoginHistory };
}
// set the parameters for the paging control
pagingControlBottom.GridViewID = loginHistoryGridView.ID;
pagingControlBottom.TotalRowCount = rowsSelected;
pagingControlTop.GridViewID = loginHistoryGridView.ID;
pagingControlTop.TotalRowCount = rowsSelected;
#endregion Initialize Values and Form Execution
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txtGroupBy.Text = DateTime.Today.ToString("dd/MM/yyyy");
if (searchConditions != null && !string.IsNullOrEmpty(TableName) && TableName.Length > 0)
{
var segments = Request.GetFriendlyUrlSegments();
//===========================================================================
//Initial columns of grid
if (segments.Count != 3)
{
//BoundField tempField = new BoundField();
//tempField.HeaderText = "Phòng khám";
//tempField.DataField = "ClinicName";
//gvListData.Columns.Add(tempField);
}
else
{
tdSearch.Visible = false;
TableName = segments[0];
ClientID = segments[1];
Id = segments[2];
}
gvListData.PageSize = 25;
gvListData.PageSize = 25;
gvListData.AllowPaging = true;
foreach (SearchExpander seardcondition in SearchConditions)
{
//===========================================================================
//Bound field when not have detail & not refference
if (!seardcondition.HasDetail && seardcondition.Refference == null)
{
BoundField boundField = new BoundField();
boundField.DataField = seardcondition.ColumnName;
boundField.HeaderText = seardcondition.Display;
if (seardcondition.PKType == typeof(DateTime))
{
boundField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
boundField.DataFormatString = "{0:dd/MM/yyyy}";
if (!string.IsNullOrEmpty(seardcondition.DisplayFormat)) boundField.DataFormatString = seardcondition.DisplayFormat;
}
gvListData.Columns.Add(boundField);
}
//===========================================================================
//Link field when not have detail & have refference
else if (!seardcondition.HasDetail && seardcondition.Refference != null)
{
string RefTableName = WebCore.GetTableName(seardcondition.Refference);
if (seardcondition.HasLinkRef)
{
string BeetwenTableName = WebCore.GetTableName(seardcondition.Type);
HyperLinkField linkField = new HyperLinkField();
if (seardcondition.Type == null) linkField.DataNavigateUrlFields = new string[] { "ClientId", seardcondition.ColumnName };
else linkField.DataNavigateUrlFields = new string[] { "ClientId", BeetwenTableName + seardcondition.RefferenceColumn };
linkField.DataNavigateUrlFormatString = FriendlyUrl.Href("~/list").ToLower() + "/" + RefTableName.ToLower() + "/{0}/{1}";
linkField.HeaderText = seardcondition.Display;
if (seardcondition.Type == null) linkField.DataTextField = RefTableName + seardcondition.DisplayRefferenceColumn;
else linkField.DataTextField = RefTableName + seardcondition.DisplayRefferenceColumn;
if (seardcondition.DisplayRefferenceColumn.ToLower().Contains("date"))
{
linkField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
linkField.DataTextFormatString = "{0:dd/MM/yyyy}";
}
gvListData.Columns.Add(linkField);
}
else
{
BoundField linkField = new BoundField();
linkField.DataField = RefTableName + seardcondition.DisplayRefferenceColumn;
linkField.HeaderText = seardcondition.Display;
gvListData.Columns.Add(linkField);
}
}
//===========================================================================
//Link field when have detail
else
{
HyperLinkField linkField = new HyperLinkField();
linkField.DataNavigateUrlFields = new string[] { "ClientId", "Id" };
linkField.DataNavigateUrlFormatString = FriendlyUrl.Href("~/detail").ToLower() + "/" + TableName.ToLower().Replace("detail", "") + "/{0}/{1}";
linkField.HeaderText = seardcondition.Display;
linkField.Text = "Chi tiết";
//linkField.DataTextField = seardcondition.DisplayRefferenceColumn;
gvListData.Columns.Add(linkField);
}
}
//List Clinic in server
string sSQL = "SELECT Id, Name from Clinic";
DataSet dataset = SqlHelper.ExecuteDataset(Config.SVConnectionString, CommandType.Text, sSQL);
ddlClinic.DataSource = dataset;
ddlClinic.DataBind();
//Initial data
}
LoadList();
}
}
///<summary>添加替代连接</summary>
///<param name="header">header标题</param>
///<param name="field">显示字段</param>
///<param name="url">url链接</param>
///<param name="parms">链接字段</param>
protected void AddHyperLinkField(string header, string field, string url, string[] parms)
{
HyperLinkField hlField = new HyperLinkField();
hlField.HeaderText = header;
hlField.DataTextField = field;
hlField.DataNavigateUrlFields = parms;
hlField.DataNavigateUrlFormatString = url;
this.itemGridView.Columns.Add(hlField);
}
private bool InitInfoList(List<String[]> list)
{
/* String[] headerStr = { "罚单编号", "违章类型", "罚款",
"扣分","违章时间" };
for (int i = 0; i < 4; i++)
{
BoundField boundField = new BoundField();
for(int j=0;j<list.Count;++j)
{
boundField.DataField.Insert(0,list[j][0]);
}
boundField.HeaderText = headerStr[i];
driverFinesInfoList.Columns.Add(boundField);
}
HyperLinkField hyperLinkField = new HyperLinkField();
for(int j=0;j<list.Count;++j)
{
hyperLinkField.Text = "wocao!";
//hyperLinkField.DataTextField.Insert(0, list[j][0]);
}
hyperLinkField.HeaderText = "处理情况";
driverFinesInfoList.Columns.Add(hyperLinkField);
driverFinesInfoList.DataBind();
return AddListData(list);*/
//办理历史列表
DataTable dtHistory = ReadGridView();
DataTable dt = ReadGridView();
int dtI = 0;
int dtHistoryI = 0;
for (int i = 0; i < list.Count; ++i)
{
if (list[i][5] != "已办理")
{
DataRow row = dt.NewRow();
row.ItemArray = new object[] { list[i][0], list[i][1], list[i][2], list[i][3], list[i][4] };
dt.Rows.InsertAt(row, dtI++);
}
else
{
DataRow row = dtHistory.NewRow();
row.ItemArray = new object[] { list[i][0], list[i][1], list[i][2], list[i][3], list[i][4] };
dtHistory.Rows.InsertAt(row, dtHistoryI++);
}
}
dt.AcceptChanges();
driverFinesInfoList.DataSource = dt;
driverFinesInfoList.DataBind();
HyperLinkField hyperLinkField = new HyperLinkField();
hyperLinkField.HeaderText = "处理情况";
driverFinesInfoList.Columns.Add(hyperLinkField);
hyperLinkField.Text = "未处理";
hyperLinkField.NavigateUrl = "http://www.baidu.com";
driverFinesInfoList.DataBind();
dtHistory.AcceptChanges();
historyDriverFinesInfoList.DataSource = dtHistory;
historyDriverFinesInfoList.DataBind();
return true;
}
/// <summary>
/// 绑定输出数据
/// </summary>
private void BindData()
{
LogQueryCondition condition = this.GetLogQueryCondition();
IList<OperationLogItem> result = this.logDAO.queryLogItem(condition);
this.dailyRecordListGridView.Columns.Clear();
if (null == result || result.Count == 0)
{
this.errorLabel.Text = "查询的结果为0条记录！！！";
this.SetVisible(false);
return;
}
this.SetVisible(true);
this.dailyRecordListGridView.AutoGenerateColumns = false;
//要显示的域
BoundField boundField = null;
boundField=new BoundField();
boundField.DataField = "opType";
boundField.HeaderText = "操作类型";
this.dailyRecordListGridView.Columns.Add(boundField);
boundField = new BoundField();
boundField.DataField = "opTable";
boundField.HeaderText = "数据库表";
this.dailyRecordListGridView.Columns.Add(boundField);
boundField = new BoundField();
boundField.DataField = "opBookIn";
boundField.HeaderText = "文库";
this.dailyRecordListGridView.Columns.Add(boundField);
boundField = new BoundField();
boundField.DataField = "opPerson";
boundField.HeaderText = "操作员";
this.dailyRecordListGridView.Columns.Add(boundField);
boundField = new BoundField();
boundField.DataField = "opDate";
boundField.HeaderText = "操作时间";
this.dailyRecordListGridView.Columns.Add(boundField);
HyperLinkField hyperlinkField = new HyperLinkField();
hyperlinkField.HeaderText = "详情";
hyperlinkField.Text = "详情";
hyperlinkField.Target = "_blank";
hyperlinkField.DataNavigateUrlFields = new String[] { "id" };
hyperlinkField.DataNavigateUrlFormatString = GlobalDailyRecord.DEATIL_PAGE + "?id={0}";
this.dailyRecordListGridView.Columns.Add(hyperlinkField);
this.dailyRecordListGridView.DataSource = result;
this.dailyRecordListGridView.DataBind();
this.pageInfoLabel.Text = this.pageNumberHiddenField.Value + "/" + this.pageCountHiddenField.Value + " 共" + this.totalRecordsHiddenField.Value + "条记录";
}
/// <summary>
/// 在SetItemFields()中使用，添加一个链接列
/// </summary>
/// <param name="header">head标题</param>
/// <param name="format">url格式字符串</param>
/// <param name="fields">格式字符中引用的列</param>
/// <param name="target">链接的目的如（_blank,_parent,_self等)</param>
protected void AddHyperLinkField(string header, string format, string[] fields,String target)
{
HyperLinkField hyperlinkField = new HyperLinkField();
hyperlinkField.HeaderText = header;
hyperlinkField.Text = header;
hyperlinkField.DataNavigateUrlFields = fields;
hyperlinkField.DataNavigateUrlFormatString = format;
hyperlinkField.Target = target;
this.itemGridView.Columns.Add(hyperlinkField);
}
