protected override void CreateChildControls() { //base.CreateChildControls(); // TODO: add custom rendering code here. // Label label = new Label(); // label.Text = "Hello World"; // this.Controls.Add(label); this._gviewMyMessage = new SPGridView(); HyperLinkField lf = new HyperLinkField(); lf.HeaderText = "消息主题"; //lf.DataTextField = "MessageTitle"; //lf.DataNavigateUrlFields = new string[] { "MessageInfoID", "ReceiverID" }; //lf.DataNavigateUrlFormatString = "MyMessage.aspx?curMessageInfoID={0}&curReceiverID={1}"; //DataNavigateUrlFormatString不支持javascript //string relativeUrl = "MyMessage.aspx?curMessageInfoID={0}&curReceiverID={1}"; //lf.DataNavigateUrlFormatString = "javascript:window.showModalDialog('" + relativeUrl + "','0','dialogWidth:300px;dialogHeight:450px');"; //lf.DataNavigateUrlFormatString = "javascript:window.showModalDialog('MyMessage.aspx?curMessageInfoID={0}&curReceiverID={1}','0','dialogWidth:300px;dialogHeight:450px');"; this._gviewMyMessage.Columns.Add(lf); BoundField bfCreateTime = new BoundField(); bfCreateTime.HeaderText = "日期"; bfCreateTime.DataField = "CreateTime"; bfCreateTime.DataFormatString = "{0:yyyy-MM-dd}"; this._gviewMyMessage.Columns.Add(bfCreateTime); BoundField bfMsgFromEmp = new BoundField(); bfMsgFromEmp.HeaderText = "来自"; bfMsgFromEmp.DataField = "MsgFromEmp"; this._gviewMyMessage.Columns.Add(bfMsgFromEmp); BoundField bfMessageStatus = new BoundField(); bfMessageStatus.HeaderText = "状态"; bfMessageStatus.DataField = "MessageStatus"; this._gviewMyMessage.Columns.Add(bfMessageStatus); this._gviewMyMessage.AutoGenerateColumns = false; this._gviewMyMessage.GridLines = GridLines.None; this._gviewMyMessage.CssClass = "ms-vh2 padded headingfont"; this._gviewMyMessage.RowDataBound += new GridViewRowEventHandler(_gviewMyMessage_RowDataBound); //this._gviewMyMessage.AllowPaging = true; //this._gviewMyMessage.PageSize = 1; //this._gviewMyMessage.PageIndexChanging +=new GridViewPageEventHandler(_gviewMyMessage_PageIndexChanging); //this._gviewMyMessage.PagerTemplate = new SPGridViewPagerTemplate("{0} - {1}", _gviewMyMessage); using (WebPartMMSProDBDataContext dc = new WebPartMMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { this._gviewMyMessage.DataSource = (from m in dc.MessageInfo join r in dc.MessageReceiver on m.MessageInfoID equals r.MessageInfoID where m.MessageStatus == "未读" && m.MessageType == "私有消息" && dc.EmpInfo.SingleOrDefault(e => e.EmpID == r.ReceiverID).Account == SPContext.Current.Web.CurrentUser.LoginName orderby m.MessageInfoID descending select new { m.MessageInfoID, r.ReceiverID, m.MessageTitle, m.CreateTime, MsgFromEmp = dc.EmpInfo.SingleOrDefault(ee => ee.EmpID == m.Creater).EmpName, m.MessageStatus }).Take(6); this._gviewMyMessage.DataBind(); } Literal L1 = new Literal(); L1.Text = "<table style='width:100%; text-align:right'><tr><td><a href='WorkPages/DocAndIndexManager/MoreMyMessage.aspx'>更多我的消息...</a></td></tr></table>"; this.Controls.Add(this._gviewMyMessage); this.Controls.Add(L1); this.Title = "我的消息"; }
protected override void CreateChildControls() { base.CreateChildControls(); // TODO: add custom rendering code here. // Label label = new Label(); // label.Text = "Hello World"; // this.Controls.Add(label); this._gviewTransferAndScrap = new SPGridView(); this._gviewTransferAndScrap.RowDataBound += new GridViewRowEventHandler(_gviewTransferAndScrap_RowDataBound); //HyperLinkField hlf = new HyperLinkField(); ////hlf.HeaderStyle.ForeColor = Color.Gray; //hlf.HeaderStyle.Font.Bold = true; //hlf.HeaderText = colNames[0].Split(':')[1]; //hlf.DataTextField = colNames[0].Split(':')[0]; //hlf.DataNavigateUrlFields = new string[] { "TaskStorageID", "StorageInID"}; //hlf.DataNavigateUrlFormatString = SPContext.Current.Web.Url + "/WorkPages/StorageIn/QualityControlManage.aspx?TaskStorageID={0}&StorageInID={1}"; TemplateField tfieldHyperLink = new TemplateField(); tfieldHyperLink.ItemTemplate = new HyperLinkTemplate("待办事项", DataControlRowType.DataRow, "TaskType", "TaskTitle"); tfieldHyperLink.HeaderTemplate = new HyperLinkTemplate("待办事项", DataControlRowType.Header); this._gviewTransferAndScrap.Columns.Add(tfieldHyperLink); for (int i = 1; i < colNames.Length; i++) { BoundField bf = new BoundField(); //bf.HeaderStyle.ForeColor = Color.Gray; bf.HeaderStyle.Font.Bold = true; bf.HeaderText = colNames[i].Split(':')[1]; bf.DataField = colNames[i].Split(':')[0]; if (i == 1) { bf.DataFormatString = "{0:yyyy-MM-dd HH:mm dddd}"; } //if (i == 3) //{ // TableItemStyle tis = new TableItemStyle(); // tis.ForeColor = System.Drawing.Color.Red; // bf.DataFormatString = ""; //} this._gviewTransferAndScrap.Columns.Add(bf); } this._gviewTransferAndScrap.AutoGenerateColumns = false; this._gviewTransferAndScrap.GridLines = GridLines.None; this._gviewTransferAndScrap.CssClass = "ms-vh2 padded headingfont"; //string curLoginName = SPContext.Current.Web.CurrentUser.LoginName; using (WebPartMMSProDBDataContext dc = new WebPartMMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { this._gviewTransferAndScrap.DataSource = (from t in dc.StockTransferTask join e1 in dc.EmpInfo on t.TaskTargetID equals e1.EmpID join e2 in dc.EmpInfo on t.TaskCreaterID equals e2.EmpID where e1.Account.ToLower() == SPContext.Current.Web.CurrentUser.LoginName.ToLower() orderby t.StockTransferTaskID descending select new { t.StockTransferTaskID, t.TaskTitle, t.CreateTime, e2.EmpName, t.TaskState, t.StockTransferID, t.TaskType, t.TaskInType }).Take(7); this._gviewTransferAndScrap.DataBind(); } int colLastIndex = this._gviewTransferAndScrap.Columns.Count - 2; int rowLastIndex = this._gviewTransferAndScrap.Rows.Count - 1; for (int i = 0; i <= rowLastIndex; i++) { if (this._gviewTransferAndScrap.Rows[i].Cells[colLastIndex].Text == "已完成") { this._gviewTransferAndScrap.Rows[i].Cells[colLastIndex].ForeColor = System.Drawing.Color.Green; } else { this._gviewTransferAndScrap.Rows[i].Cells[colLastIndex].ForeColor = System.Drawing.Color.Red; } } Literal L1 = new Literal(); L1.Text = "<table style='width:100%; text-align:right'><tr><td><a href='workpages/DocAndIndexManager/MoreTransferAndScrap.aspx'>更多待办事项...</a></td></tr></table>"; this.Controls.Add(this._gviewTransferAndScrap); this.Controls.Add(L1); this.Title = "移库&报废"; }