public string GetAdviceIDBySN(long sn) { int from = 0; int count = 1; string adviceID = ""; List <Advice> advice = AdviceHelper.GetAdviceByQuery(CurrentQuery, from, count); for (int i = 0; i < advice.Count; i++) { if (advice[i] != null) { adviceID = advice[i].TypeID; } } return(adviceID); }
/// <summary> /// 初始化页面信息 /// </summary> void LoadAdvices() { AdviceUPager.PageIndex = PageNumber; AdviceUPager.ItemCount = AdviceHelper.QueryAdviceCountByAll(CurrentQuery); AdviceUPager.UrlFormat = We7Helper.AddParamToUrl(Request.RawUrl.Replace("{", "{{").Replace("}", "}}"), Keys.QRYSTR_PAGEINDEX, "{0}"); AdviceUPager.PrefixText = "共 " + AdviceUPager.MaxPages + " 页 · 第 " + AdviceUPager.PageIndex + " 页 · "; List <Advice> list = new List <Advice>(); list = AdviceHelper.GetAdviceByQuery(CurrentQuery, AdviceUPager.Begin - 1, AdviceUPager.Count); AdviceType adviceType = new AdviceType(); foreach (Advice a in list) { if (a.MustHandle > 1) { HasMustHandle = true; } if (a.TypeID != null && a.TypeID != "") { adviceType = AdviceTypeHelper.GetAdviceType(a.TypeID); if (adviceType != null) { a.TypeTitle = adviceType.Title; } } if (a.UserID != null && a.UserID.Length > 0) { a.Name = AccountHelper.GetAccount(a.UserID, new string[] { "LastName" }).LastName; } if (a.Name == null || a.Name == "") { a.Name = "匿名用户"; } a.TimeNote = GetTimeNote(a.CreateDate); a.AlertNote = GetAlertNote(a.ToHandleTime, adviceType.RemindDays, a.MustHandle); } AdviceGridView.DataSource = list; AdviceGridView.DataBind(); BuildStateLinks();//刷新状态统计栏 }
/// <summary> /// 初始化页面信息 /// </summary> void LoadAdvices() { query = null; //CurrentQuery.State = (int)CurrentState; AdviceUPager.PageIndex = PageNumber; AdviceUPager.ItemCount = AdviceHelper.QueryAdviceCountByAll(CurrentQuery); AdviceUPager.UrlFormat = We7Helper.AddParamToUrl(Request.RawUrl.Replace("{", "{{").Replace("}", "}}"), Keys.QRYSTR_PAGEINDEX, "{0}"); AdviceUPager.PrefixText = "共 " + AdviceUPager.MaxPages + " 页 · 第 " + AdviceUPager.PageIndex + " 页 · "; List <Advice> list = new List <Advice>(); list = AdviceHelper.GetAdviceByQuery(CurrentQuery, AdviceUPager.Begin - 1, AdviceUPager.Count); AdviceType adviceType = new AdviceType(); foreach (Advice a in list) { if (a.TypeID != null && a.TypeID != "") { adviceType = AdviceTypeHelper.GetAdviceType(a.TypeID); if (adviceType != null) { a.TypeTitle = adviceType.Title; } } if (a.UserID != null && a.UserID.Length > 0) { a.Name = AccountHelper.GetAccount(a.UserID, new string[] { "LoginName" }).LoginName; } if (a.Name == null || a.Name == "") { a.Name = "匿名用户"; } } AdviceGridView.DataSource = list; AdviceGridView.DataBind(); }
/// <summary> /// 反馈信息按反馈模型统计(AdviceType表) /// 统计标准为Advice表State = (int)AdviceState.Finished /// </summary> protected void AdviceModuleStatistics() { //1.获取所有的反馈模型 adTypeList List <AdviceType> adTypeList = new List <AdviceType>(); adTypeList = AdviceTypeHelper.GetAdviceTypes(); if (adTypeList != null) { //翻页控件属性赋值 if (AdviceReplyStatisticsPager.Count < 0) { AdviceReplyStatisticsPager.PageIndex = 0; } AdviceReplyStatisticsPager.FreshMyself(); AdviceReplyStatisticsPager.RecorderCount = adTypeList.Count; if (AdviceReplyStatisticsPager.RecorderCount < 1) { StatisticsDataGridView.DataSource = null; } else { //反馈统计对象 List <AdviceRate> adRateList = new List <AdviceRate>(); foreach (AdviceType adType in adTypeList) { AdviceRate adRate = new AdviceRate(); if (adType != null && adType.ID != "") { adRate.AdviceTypeID = CurrentQuery.AdviceTypeID = adType.ID; adRate.AdviceTypeTitle = adType.Title; //2.根据条件循环获取每个模型的反馈信息数据 adList List <Advice> adList = AdviceHelper.GetAdviceByQuery(CurrentQuery, 0, 0); adRate.AdviceCount = adList.Count; for (int i = 0; i < adList.Count; i++) { if (adList != null && adList.Count != 0) { //根据获取到的反馈信息数据给反馈统计对象赋值 if (adList[i].MustHandle == 1) { adRate.HandleNumber += 1; } if (adList[i].State == (int)AdviceState.Finished) { adRate.HandleCount += 1; if (adList[i].EnumState != EnumLibrary.AdviceEnum.AdminHandle.ToString())//管理员办理的除去 { adRate.NoAdminHandleCount += 1; if (adList[i].MustHandle == 1) { adRate.NotAdminMustHandleCount += 1; } } } if (adList[i].State != (int)AdviceState.Finished && adList[i].MustHandle == 1) { adRate.NoHandleCount += 1; } } } } adRate.NoHandleNumber = adRate.AdviceCount - adRate.HandleNumber; int count = 0; if (adRate.NoAdminHandleCount > 0 && adRate.HandleNumber > 0) { count = (int)(((double)adRate.NotAdminMustHandleCount / (double)adRate.HandleNumber) * 100); } if (count > 100) { count = 100; } adRate.HandleRate = count + "%"; adRateList.Add(adRate); } StatisticsDataGridView.DataSource = adRateList; } } StatisticsDataGridView.DataBind(); }