public void InitGrid(object sender, EventArgs e) { try { PmsHead pmsHead = new PmsHead(); pmsHead.Vid = "PM"; pmsHead.NoStageName = "'CLose','HardClosed'"; //if (UserStatus == "PM") // pmsHead.Pm = textboxPM.Text.ToString().Trim(); //else // pmsHead.UserName = textboxUserName.Text.ToString().Trim(); pmsHead.UserName = textboxUserName.Text.Trim(); pmsHead.CrId = textboxCrNo.Text.Trim(); PmsHeadBiz pmsHeadBiz = new PmsHeadBiz(); IList <PmsHead> pmsHeadList = pmsHeadBiz.SelectPmsHeadOther(pmsHead); gridViewMain.DataSource = pmsHeadList; gridViewMain.DataBind(); gridViewMain.Columns[13].Visible = false; } catch { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('InitGrid failure!');", true); } }
private void InitPage() { try { LoginName = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", "."); ButtonSaveTop.Attributes.Add("onclick", "return CheckBeforeSave()"); ButtonSaveUnder.Attributes.Add("onclick", "return CheckBeforeSave()"); ButtonCancelTop.OnClientClick = "window.close()"; ButtonCancelUnder.OnClientClick = "window.close()"; //取得project,module PmsHead pmsHead = new PmsHead(); pmsHead.Vid = "PM"; pmsHead.UserName = LoginName; pmsHead.CrId = CrID; string minID = string.Empty; PmsMinHeadBiz pmsMinHeadBiz = new PmsMinHeadBiz(); pmsMinHeadBiz.GetMinId(out minID); MinID = minID; // 保存到ViewState,发mail时使用 PmsHeadBiz pmsHeadBiz = new PmsHeadBiz(); IList <PmsHead> pmsHeadList = pmsHeadBiz.SelectPmsHeadOther(pmsHead); string project = pmsHeadList[0].BugFreeProject; string module = pmsHeadList[0].BugFreeModule; string IssueCreateUrl = ConfigurationManager.AppSettings["IssueCreateUrl"]; string paraMeter = "&PmsID=" + Server.UrlEncode(GetBase64Encode(PmsID)) + "&UserName="******".", " "))) + "&CrID=" + Server.UrlEncode(GetBase64Encode(CrID)) + "&BugFreeProject=" + Server.UrlEncode(GetBase64Encode(project)) + "&BugFreeModule=" + Server.UrlEncode(GetBase64Encode(module)) + "&MNID=" + Server.UrlEncode(GetBase64Encode(MinID)); ButtonCreateIssue.OnClientClick = "javascript:window.open('" + IssueCreateUrl + paraMeter + "');"; BindDropDown(); InitTextBox(); GridViewBind(null); GridViewIssueBind(); } catch (Exception ex) { Msgbox("Init Page Failed !"); } }
public void BindGrid(object sender, EventArgs e) { #region Bind DataTable to GridView try { if (sender == null) { DataTable dt = new DataTable(); gridViewMain.DataSource = dt; gridViewMain.DataBind(); gridViewMain.Columns[13].Visible = false; } else { #region Get Values PmsHead pmsHead = new PmsHead(); pmsHead.Vid = "PM"; if (this.dropdownlistDomain.SelectedItem != null && this.dropdownlistDomain.SelectedItem.Text.ToUpper() != "") { pmsHead.Domain = this.dropdownlistDomain.SelectedItem.Text.ToString(); } else { pmsHead.Domain = ""; } pmsHead.System = textboxSystem.Text.Trim(); pmsHead.CrId = textboxCrNo.Text.Trim(); pmsHead.PmsName = textboxPmsName.Text.Trim(); if (this.dropdownlistType.SelectedItem != null && this.dropdownlistType.SelectedItem.Text.ToUpper() != "") { pmsHead.Type = this.dropdownlistType.SelectedItem.Value.ToString(); } else { pmsHead.Type = ""; } if (this.dropdownlistSite.SelectedItem != null && this.dropdownlistSite.SelectedItem.Text.ToUpper() != "") { pmsHead.Site = this.dropdownlistSite.SelectedItem.Value.ToString(); } else { pmsHead.Site = ""; } if (this.dropdownlistStage.SelectedItem != null && this.dropdownlistStage.SelectedItem.Text.ToUpper() != "") { pmsHead.StageName = this.dropdownlistStage.SelectedItem.Text.ToString().Trim(); } else { pmsHead.StageName = ""; } // pmsHead.Pm = textboxPM.Text.ToString().Trim(); // pmsHead.UserName = textboxUserName.Text.ToString().Trim(); if (this.dropdownlistPriority.SelectedItem != null && this.dropdownlistPriority.SelectedItem.Text.ToUpper() != "") { pmsHead.Priority = this.dropdownlistPriority.SelectedItem.Text.ToString().Trim(); } else { pmsHead.Priority = ""; } pmsHead.UserName = textboxUserName.Text.ToString().Trim(); if (this.dateTextBoxCreateDateFrom.Text.ToString().Trim() != "") { pmsHead.CreateDateFrom = DateTime.Parse(dateTextBoxCreateDateFrom.Text.ToString().Trim()); } if (this.dateTextBoxCreateDateTo.Text.ToString().Trim() != "") { pmsHead.CreateDateTo = DateTime.Parse(dateTextBoxCreateDateTo.Text.ToString().Trim()); } if (this.dateTextBoxReleaseDateFrom.Text.ToString().Trim() != "") { pmsHead.ReleaseDateFrom = DateTime.Parse(dateTextBoxReleaseDateFrom.Text.ToString().Trim()); } if (this.dateTextBoxReleaseDateTo.Text.ToString().Trim() != "") { pmsHead.ReleaseDateTo = DateTime.Parse(dateTextBoxReleaseDateTo.Text.ToString().Trim()); } if (this.dateTextBoxDueDateFrom.Text.ToString().Trim() != "") { pmsHead.DueDateFrom = DateTime.Parse(dateTextBoxDueDateFrom.Text.ToString().Trim()); } if (this.dateTextBoxDueDateTo.Text.ToString().Trim() != "") { pmsHead.DueDateTo = DateTime.Parse(dateTextBoxDueDateTo.Text.ToString().Trim()); } #endregion PmsHeadBiz pmsHeadBiz = new PmsHeadBiz(); IList <PmsHead> pmsHeadList = pmsHeadBiz.SelectPmsHeadOther(pmsHead); #region Sort Modify By Albee List <PmsHead> SdpHeadList = (List <PmsHead>)pmsHeadList; if (SdpHeadList != null && SdpHeadList.Count > 0) { #region Descending if (GridViewSortDirection == SortDirection.Descending) { switch (ViewState["SortExpression"].ToString()) { case "CrId": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.CrId.CompareTo(x.CrId)); }); break; case "Type": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Type.CompareTo(x.Type)); }); break; case "PmsName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.PmsName.CompareTo(x.PmsName)); }); break; case "Progress": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Progress.CompareTo(x.Progress)); }); break; case "DueDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.DueDate.CompareTo(x.DueDate)); }); break; case "ReleaseDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.ReleaseDate.CompareTo(x.ReleaseDate)); }); break; case "CreateDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.CreateDate.CompareTo(x.CreateDate)); }); break; case "StageName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.StageName.CompareTo(x.StageName)); }); break; case "Pm": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Pm.CompareTo(x.Pm)); }); break; case "Sd": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Sd.CompareTo(x.Sd)); }); break; case "System": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.System.CompareTo(x.System)); }); break; default: break; } } #endregion #region Ascending else { switch (ViewState["SortExpression"].ToString()) { case "CrId": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.CrId.CompareTo(y.CrId)); }); break; case "Type": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Type.CompareTo(y.Type)); }); break; case "PmsName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.PmsName.CompareTo(y.PmsName)); }); break; case "Progress": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Progress.CompareTo(y.Progress)); }); break; case "DueDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.DueDate.CompareTo(y.DueDate)); }); break; case "ReleaseDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.ReleaseDate.CompareTo(y.ReleaseDate)); }); break; case "CreateDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.CreateDate.CompareTo(y.CreateDate)); }); break; case "StageName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.StageName.CompareTo(y.StageName)); }); break; case "Pm": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Pm.CompareTo(y.Pm)); }); break; case "Sd": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Sd.CompareTo(y.Sd)); }); break; case "System": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.System.CompareTo(y.System)); }); break; default: break; } } #endregion } //gridViewDetailList.DataSource = pmsSdpHeadList; //mark by Albee 2010-08-03 gridViewMain.DataSource = SdpHeadList; #endregion //gridViewMain.DataSource = pmsHeadList; gridViewMain.DataBind(); gridViewMain.Columns[13].Visible = false; } } catch { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('BindGrid failure!');", true); } #endregion }
public void BindGrid(object sender, EventArgs e) { #region Bind DataTable to GridView try { if (sender == null) { DataTable dt = new DataTable(); gridViewMain.DataSource = dt; gridViewMain.DataBind(); } else { #region Get Values PmsHead pmsHead = new PmsHead(); pmsHead.Vid = "PM"; pmsHead.StageName = PmsCommonEnum.ProjectStage.AssignMember.GetDescription(); #endregion PmsHeadBiz pmsHeadBiz = new PmsHeadBiz(); IList <PmsHead> pmsHeadList = pmsHeadBiz.SelectPmsHeadOther(pmsHead); #region Sort Modify By Albee List <PmsHead> SdpHeadList = (List <PmsHead>)pmsHeadList; #region Descending if (GridViewSortDirection == SortDirection.Descending) { switch (ViewState["SortExpression"].ToString()) { case "CrId": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.CrId.CompareTo(x.CrId)); }); break; case "Type": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Type.CompareTo(x.Type)); }); break; case "PmsName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.PmsName.CompareTo(x.PmsName)); }); break; case "Progress": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Progress.CompareTo(x.Progress)); }); break; case "DueDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.DueDate.CompareTo(x.DueDate)); }); break; case "ReleaseDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.ReleaseDate.CompareTo(x.ReleaseDate)); }); break; case "CreateDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.CreateDate.CompareTo(x.CreateDate)); }); break; case "StageName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.StageName.CompareTo(x.StageName)); }); break; case "Priority": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Priority.CompareTo(x.Priority)); }); break; case "Sd": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.Sd.CompareTo(x.Sd)); }); break; case "System": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(y.System.CompareTo(x.System)); }); break; default: break; } } #endregion #region Ascending else { switch (ViewState["SortExpression"].ToString()) { case "CrId": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.CrId.CompareTo(y.CrId)); }); break; case "Type": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Type.CompareTo(y.Type)); }); break; case "PmsName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.PmsName.CompareTo(y.PmsName)); }); break; case "Progress": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Progress.CompareTo(y.Progress)); }); break; case "DueDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.DueDate.CompareTo(y.DueDate)); }); break; case "ReleaseDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.ReleaseDate.CompareTo(y.ReleaseDate)); }); break; case "CreateDate": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.CreateDate.CompareTo(y.CreateDate)); }); break; case "StageName": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.StageName.CompareTo(y.StageName)); }); break; case "Priority": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Priority.CompareTo(y.Priority)); }); break; case "Sd": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.Sd.CompareTo(y.Sd)); }); break; case "System": SdpHeadList.Sort(delegate(PmsHead x, PmsHead y) { return(x.System.CompareTo(y.System)); }); break; default: break; } } #endregion gridViewMain.DataSource = SdpHeadList; #endregion #region Get gridViewTaskAudit Values //借用Creator传LoginName pmsHead.Creator = LoginName; IList <PmsHead> pmsHeadListAudit = pmsHeadBiz.SelectPmsHeadForAuditor(pmsHead); List <PmsHead> SdpHeadListAudit = (List <PmsHead>)pmsHeadListAudit; gridViewTaskAudit.DataSource = SdpHeadListAudit; #endregion IList <PmsHead> pmsHeadListAgent = pmsHeadBiz.SelectPmsHeadForAgent(pmsHead); List <PmsHead> SdpHeadListAgent = (List <PmsHead>)pmsHeadListAgent; gridViewTaskAgent.DataSource = SdpHeadListAgent; #region Get gridViewTaskAgent Values #endregion gridViewMain.DataBind(); gridViewTaskAudit.DataBind(); gridViewTaskAgent.DataBind(); } } catch { ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString(), "alert('BindGrid failure!');", true); } #endregion }