/// <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 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 InitializeCustomControls()
{
InitToolBar();
this.spgvCommitNotice = new SPGridView();
this.spgvCommitNotice.AutoGenerateColumns = false;
this.spgvCommitNotice.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
string[] ShowTlist =
{
"业主单位:ProprietorName",
"所属项目:ProjectName",
"项目阶段:ProjectStage",
"项目属性:ProjectProperty",
"施工单位:ConstructorName",
"包含物资:MaterialCount",
"创建时间:CreateTime",
"备注:Remark",
"ID:StorageOutNoticeID"
};
BoundField bfColumn;
foreach (var kvp in ShowTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvCommitNotice.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "StorageOutNoticeID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvCommitNotice.Columns.Insert(0, tfieldCheckbox);
//添加任务详情列
HyperLinkField hlfTask = new HyperLinkField();
hlfTask.HeaderText = "任务详情";
this.spgvCommitNotice.Columns.Insert(10, hlfTask);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "调拨通知单编号";
colMenu.TextFields = "StorageOutNoticeCode";
colMenu.MenuTemplateId = "spmfNoticeCode";
colMenu.NavigateUrlFields = "StorageOutNoticeID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "ManageStorageOutDetails.aspx?NoticeID={0}";
colMenu.TokenNameAndValueFields = "curNoticeID=StorageOutNoticeID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "spmfNoticeCode";
MenuItemTemplate createMenuItem = new MenuItemTemplate("生产组长审核", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "../PublicPage/AuditDispatchCenter.aspx?Process=正常出库&NoticeID=%curNoticeID%";
menuItemCollection.Controls.Add(createMenuItem);
this.Controls.Add(menuItemCollection);
this.spgvCommitNotice.Columns.Insert(1, colMenu);
this.spgvCommitNotice.RowDataBound += new GridViewRowEventHandler(spgvCommitNotice_RowDataBound);
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
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);
}
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "StorageInID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.gv.Columns.Insert(0, tfieldCheckbox);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "交货通知单编号";
colMenu.TextFields = "StorageInCode";
colMenu.MenuTemplateId = "actionMenu";
colMenu.NavigateUrlFields = "StorageInID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "StorageInDetailedManage.aspx?StorageInID={0}";
colMenu.TokenNameAndValueFields = "curStorageID=StorageInID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "actionMenu";
MenuItemTemplate createMenuItem = new MenuItemTemplate("送往质检", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "QualityControlMessage.aspx?StorageInID=%curStorageID%&&state=质检&&storageInType=正常入库";
//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.Insert(1, colMenu);
//this.gv.Columns.Add(hlTask);
HyperLinkField hlTask = new HyperLinkField();
hlTask.HeaderText = "任务详情";
this.gv.Columns.Insert(4, hlTask);
//hlTask.DataNavigateUrlFields={}
// hlTask.DataNavigateUrlFormatString = "javaScript:onClick=window.showModalDialog('../PublicPage/ErrorInfo.aspx?StorageInID={0}')";
this.gv.DataSource = from a in db.StorageIn
where a.Creator == UserLoginId
select new
{
a.StorageInID,
a.StorageInCode,
a.Remark,
a.CreateTime
};
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 InitializeCustomControls()
{
InitToolBar();
//初始化维修保养表
this.spgvRepair = new SPGridView();
this.spgvRepair.AutoGenerateColumns = false;
this.spgvRepair.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
BoundField bfColumn;
foreach (var kvp in ShowRepairTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvRepair.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfChooseRepair = new TemplateField();
tfChooseRepair.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "SrinRepairPlanID");
tfChooseRepair.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvRepair.Columns.Insert(0, tfChooseRepair);
SPMenuField colRepairMenu = new SPMenuField();
colRepairMenu.HeaderText = "维修保养计划表编号";
colRepairMenu.TextFields = "SrinRepairPlanCode";
colRepairMenu.MenuTemplateId = "mtRepair";
colRepairMenu.NavigateUrlFields = "SrinRepairPlanID"; //定义方式:"列名1,列名2..."
colRepairMenu.NavigateUrlFormat = "ManageRepairOrVerifyDetails.aspx?FormID={0}&Type=维修保养";
colRepairMenu.TokenNameAndValueFields = "curID=SrinRepairPlanID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate mtRepair = new MenuTemplate();
mtRepair.ID = "mtRepair";
MenuItemTemplate mitMaterial = new MenuItemTemplate("物资组长审核", "/_layouts/images/newitem.gif");
mitMaterial.ClientOnClickNavigateUrl = string.Format("SrinDispatchCenter.aspx?TaskType=维修保养物资组长审核&TaskID={0}&FormID=%curID%", _taskid);
mtRepair.Controls.Add(mitMaterial);
this.Controls.Add(mtRepair);
this.spgvRepair.Columns.Insert(1, colRepairMenu);
//初始化回收检验表
this.spgvVerify = new SPGridView();
this.spgvVerify.AutoGenerateColumns = false;
this.spgvVerify.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
foreach (var kvp in ShowVerifyTList)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvVerify.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfChooseVerify = new TemplateField();
tfChooseVerify.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "SrinVerifyTransferID");
tfChooseVerify.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvVerify.Columns.Insert(0, tfChooseVerify);
SPMenuField colVerifyMenu = new SPMenuField();
colVerifyMenu.HeaderText = "回收检验传递表编号";
colVerifyMenu.TextFields = "SrinVerifyTransferCode";
colVerifyMenu.MenuTemplateId = "mtVerify";
colVerifyMenu.NavigateUrlFields = "SrinVerifyTransferID"; //定义方式:"列名1,列名2..."
colVerifyMenu.NavigateUrlFormat = "ManageRepairOrVerifyDetails.aspx?FormID={0}&Type=回收检验";
colVerifyMenu.TokenNameAndValueFields = "curID=SrinVerifyTransferID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate mtVerify = new MenuTemplate();
mtVerify.ID = "mtVerify";
MenuItemTemplate mitVerify = new MenuItemTemplate("提交生产组", "/_layouts/images/newitem.gif");
mitVerify.ClientOnClickNavigateUrl = string.Format("SrinDispatchCenter.aspx?TaskType=生产组安排质检&TaskID={0}&FormID=%curID%", _taskid);
mtVerify.Controls.Add(mitVerify);
this.Controls.Add(mtVerify);
this.spgvVerify.Columns.Insert(1, colVerifyMenu);
//添加任务详情列
HyperLinkField hlfVerifyTask = new HyperLinkField();
hlfVerifyTask.HeaderText = "任务详情";
this.spgvVerify.Columns.Insert(7, hlfVerifyTask);
this.spgvVerify.RowDataBound += new GridViewRowEventHandler(spgvVerify_RowDataBound);
}
/// <summary>
/// Add columns from configuration to Grid
/// </summary>
private void AddColumns()
{
foreach (DataField dataField in Config.Columns)
{
// Generate menus
if (dataField.ContextMenu.Count > 0)
{
SPMenuField menu = new SPMenuField();
menu.HeaderText = dataField.Header;
menu.TextFields = dataField.Name;
menu.SortExpression = dataField.Name;
menu.MenuTemplateId = "MT" + ID + dataField.Name;
if (string.IsNullOrEmpty(dataField.ContextMenu.Fields))
{
menu.NavigateUrlFields = dataField.ContextMenu.Fields;
}
// TODO: Change
if (!string.IsNullOrEmpty(dataField.ContextMenu.Format))
{
//menu.NavigateUrlFormat = dataField.ContextMenu.Format;
menu.TokenNameAndValueFields = dataField.ContextMenu.Format;
}
// Menu Template linked
_menuTemplate = new MenuTemplate();
_menuTemplate.ID = "MT" + ID + dataField.Name;
foreach (ContextMenuItem menuItem in dataField.ContextMenu)
{
MenuItemTemplate optionMenu = new MenuItemTemplate(menuItem.Name, menuItem.Image);
if (menuItem.Url.Contains("Row"))
{
Debug.WriteLine(string.Format("Menu {0} - {1} - {2}", Title, dataField.Name, menuItem.Name));
//TODO: Check the send item (see Test1) Send value is the column name
//not the field value
// Page become null when we are connecting webparts
if (Page != null)
{
// Generate the script
string script = Page.ClientScript.GetPostBackEventReference(this, "_");
// Add the special SPSGetRowId call
optionMenu.ClientOnClickScript =
script.Replace("'_'", "'Row$'+SPSGetRowId('%MENUCLIENTID%')");
}
}
else
{
// Other url
optionMenu.ClientOnClickNavigateUrl = menuItem.Url;
}
_menuTemplate.Controls.Add(optionMenu);
}
Controls.Add(_menuTemplate);
_gridView.Columns.Add(menu);
}
else
{
// Normal Bound field
BoundField boundField = new BoundField();
boundField.DataField = dataField.Name;
boundField.HeaderText = dataField.Header;
if (string.IsNullOrEmpty(dataField.SortExpression))
{
boundField.SortExpression = dataField.Name;
}
else
{
boundField.SortExpression = dataField.SortExpression;
}
if (dataField.IsHtml)
{
boundField.HtmlEncode = false;
}
if (!string.IsNullOrEmpty(dataField.Format))
{
boundField.DataFormatString = dataField.Format;
boundField.HtmlEncode = false;
}
if (dataField.Select)
{
boundField.DataFormatString = string.Format("<a href=\"#\" onclick=\"{0}\">", SelectRowScript());
boundField.DataFormatString += "{0}</a>";
boundField.HtmlEncode = false;
}
_gridView.Columns.Add(boundField);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//==================================Integration Menu=================================
MenuTemplate propertyNameListMenu = new MenuTemplate();
propertyNameListMenu.ID = "IntegrationMenu";
MenuItemTemplate testMenu = new MenuItemTemplate("Edit Connection", "/_layouts/epmlive/images/integration/editcon.png");
testMenu.ClientOnClickNavigateUrl = "connection.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu);
MenuItemTemplate testMenu2 = new MenuItemTemplate("Edit Properties", "/_layouts/images/edit.gif");
testMenu2.ClientOnClickNavigateUrl = "properties.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu2);
MenuItemTemplate testMenu3 = new MenuItemTemplate("Edit Columns", "/_layouts/epmlive/images/integration/editcols.png");
testMenu3.ClientOnClickNavigateUrl = "columns.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu3);
MenuItemTemplate testMenu4 = new MenuItemTemplate("View Log", "/_layouts/epmlive/images/integration/log.png");
testMenu4.ClientOnClickNavigateUrl = "log.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu4);
MenuItemTemplate testMenu5 = new MenuItemTemplate("Delete Integration", "/_layouts/images/delete.gif");
testMenu5.ClientOnClickScript = "DeleteIntegration('%INTLISTID%');";
propertyNameListMenu.Controls.Add(testMenu5);
this.Controls.Add(propertyNameListMenu);
//===================================================================================
MenuTemplate propertyNameListMenu2 = new MenuTemplate();
propertyNameListMenu2.ID = "IntegrationGroupMenu";
MenuItemTemplate testMenu6 = new MenuItemTemplate("Add Integration", "/_layouts/images/add.gif");
testMenu6.ClientOnClickNavigateUrl = "Add.aspx?LIST=%LISTID%&ret=Manage";
propertyNameListMenu2.Controls.Add(testMenu6);
MenuItemTemplate testMenu7 = new MenuItemTemplate("Edit Fields", "/_layouts/images/edit.gif");
testMenu7.ClientOnClickScript = "EditFields('%LISTID%')";
propertyNameListMenu2.Controls.Add(testMenu7);
this.Controls.Add(propertyNameListMenu2);
//===================================================================================
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "";
colMenu.TextFields = "ListName"; // GroupName field, bind to a List column
colMenu.MenuTemplateId = "IntegrationGroupMenu";
colMenu.TokenNameAndValueFields = "LISTID=LIST_ID";
colMenu.SortExpression = "ListName";
colMenu.MenuFormat = MenuFormat.ArrowAlwaysVisible;
gvIntegrations.GroupMenu = colMenu;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
var dataSet = new DataSet();
using (var connection = new SqlConnection(CoreFunctions.getConnectionString(Web.Site.WebApplication.Id)))
{
connection.Open();
using (var sqlCommand = new SqlCommand(
@"SELECT dbo.INT_MODULES.Title, dbo.INT_MODULES.Description, dbo.INT_MODULES.Icon, dbo.INT_LISTS.INT_LIST_ID, dbo.INT_LISTS.LIST_ID, dbo.INT_LISTS.ACTIVE
FROM dbo.INT_MODULES INNER JOIN
dbo.INT_LISTS ON dbo.INT_MODULES.MODULE_ID = dbo.INT_LISTS.MODULE_ID where SITE_ID=@siteid",
connection))
{
sqlCommand.Parameters.AddWithValue("@siteid", Web.Site.ID);
using (var sqlDataAdapter = new SqlDataAdapter(sqlCommand))
{
sqlDataAdapter.Fill(dataSet);
}
}
}
DataTable dt = dataSet.Tables[0];
dt.Columns.Add("ListName");
Hashtable hshLists = new Hashtable();
ArrayList arrExists = new ArrayList();
ArrayList arrIgnore = new ArrayList();
foreach (SPList list in Web.Lists)
{
if (!list.Hidden)
{
hshLists.Add(list.ID, list.Title);
}
if (bIsSystemList(list.Title) || list.BaseType == SPBaseType.DocumentLibrary)
{
arrIgnore.Add(list.ID);
}
}
foreach (DataRow dr in dt.Rows)
{
try
{
Guid ListId = new Guid(dr["LIST_ID"].ToString());
if (hshLists.Contains(ListId))
{
dr["ListName"] = hshLists[ListId].ToString();
arrExists.Add(ListId);
}
}
catch { }
}
foreach (DictionaryEntry de in hshLists)
{
if (!arrExists.Contains(de.Key) && !arrIgnore.Contains(de.Key))
{
DataRow dr = dt.NewRow();
dr["List_Id"] = de.Key;
dr["ListName"] = de.Value;
dr["Title"] = "No Integrations";
dt.Rows.Add(dr);
}
}
gvIntegrations.DataSource = dataSet;
gvIntegrations.DataBind();
});
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
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);
}
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "CommitInID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.gv.Columns.Insert(0, tfieldCheckbox);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "交货通知单编号";
colMenu.TextFields = "CommitInCode";
colMenu.MenuTemplateId = "actionMenu";
HyperLinkField hlTask = new HyperLinkField();
hlTask.HeaderText = "任务详情";
colMenu.NavigateUrlFields = "CommitInID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "CommitInDetailedManage.aspx?CommitInID={0}";
colMenu.TokenNameAndValueFields = "curCommitID=CommitInID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "actionMenu";
MenuItemTemplate createMenuItem = new MenuItemTemplate("送往质检", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "../PublicPage/AuditDispatchCenter.aspx?Process=委外入库&CommitInID=%curCommitID%";
menuItemCollection.Controls.Add(createMenuItem);
this.Controls.Add(menuItemCollection);
this.gv.Columns.Insert(1, colMenu);
this.gv.Columns.Insert(4, hlTask);
this.gv.DataSource = from a in db.CommitIn
select new
{
a.CommitInID,
a.CommitInCode,
a.Remark,
a.CreateTime
};
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);
}
}
/// <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);
}
}
}
