/// <summary>
/// 构造查询条件
/// </summary>
/// <returns></returns>
AdviceQuery CreateQuery()
{
AdviceQuery tempAQ = new AdviceQuery();
tempAQ.AdviceTypeID = AdviceTypeID;
tempAQ.EndCreated = Convert.ToDateTime(endtime.Value);
tempAQ.StartCreated = Convert.ToDateTime(starttime.Value);
tempAQ.IsShow = 9999;
return(tempAQ);
}
/// <summary>
/// 构造反馈统计绑定数据的对象集
/// </summary>
/// <returns></returns>
List <AdviceRate> CreateAdviceRateList()
{
List <AdviceRate> adviceRateList = new List <AdviceRate>(); //数据对象集
List <Advice> adviceInfoTypeList = AdviceHelper.CreatedAdviceRate(AdviceTypeID); //此对象仅为反馈信息类型去重后的结果。
CurrentQuery.AdviceTypeID = AdviceTypeID;
for (int i = 0; i < adviceInfoTypeList.Count; i++)
{
CurrentQuery.AdviceInfoType = adviceInfoTypeList[i].AdviceInfoType;
//CurrentQuery.State = 0;
//CurrentQuery.NotEnumState = -1;
AdviceRate adviceRate = new AdviceRate();
adviceRate.AdviceCount = AdviceHelper.GetAdviceCount(CurrentQuery);//总件数
adviceRate.AdviceInfoType = adviceInfoTypeList[i].AdviceInfoType;
adviceRate.AdviceTypeID = AdviceTypeID;
adviceRate.AdviceTypeTitle = adviceInfoTypeList[i].TypeTitle;
CurrentQuery.State = (int)AdviceState.Finished;
adviceRate.HandleCount = AdviceHelper.GetAdviceCount(CurrentQuery);//总处理数
CurrentQuery.State = 0;
CurrentQuery.MustHandle = 1;
adviceRate.HandleNumber = AdviceHelper.GetAdviceCount(CurrentQuery);//应处理数
CurrentQuery.NotState = (int)AdviceState.Finished;
adviceRate.NoHandleCount = AdviceHelper.GetAdviceCount(CurrentQuery);//未处理数
CurrentQuery.NotEnumState = (int)EnumLibrary.AdviceEnum.AdminHandle;
CurrentQuery.State = (int)AdviceState.Finished;
CurrentQuery.NotState = -1;
adviceRate.NotAdminMustHandleCount = AdviceHelper.GetAdviceCount(CurrentQuery);//办理人处理的必须办理的信息数
CurrentQuery.MustHandle = -1;
adviceRate.NoAdminHandleCount = AdviceHelper.GetAdviceCount(CurrentQuery); //办理人处理数
adviceRate.NoHandleNumber = adviceRate.AdviceCount - adviceRate.HandleNumber; //不需处理数
int count = 0;
if (adviceRate.NoAdminHandleCount > 0 && adviceRate.HandleNumber > 0)
{
count = (int)(((double)adviceRate.NotAdminMustHandleCount / (double)adviceRate.HandleNumber) * 100);
}
if (count > 100)
{
count = 100;
}
adviceRate.HandleRate = count + "%";
adviceRateList.Add(adviceRate);
CurrentQuery = CreateQuery();
}
return(adviceRateList);
}
AdviceQuery CreateQuery()
{
AdviceQuery tempAQ = new AdviceQuery();
tempAQ.AdviceTypeID = AdviceTypeID;
tempAQ.State = (int)CurrentState;
tempAQ.AccountID = AccountID;
tempAQ.IsShow = 9999;
string keyWord = SearchTextBox.Text.Trim();
string selectedValue = ddlSearchKey.SelectedValue;
switch (selectedValue)
{
case "name":
tempAQ.Name = keyWord; break;
case "phone":
tempAQ.Phone = keyWord; break;
case "fax":
tempAQ.Fax = keyWord; break;
case "address":
tempAQ.Address = keyWord; break;
case "email":
tempAQ.Email = keyWord; break;
case "content":
tempAQ.Content = keyWord; break;
default:
tempAQ.Title = keyWord; break;
}
return(tempAQ);
}
/// <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();
}
