public void BindData()
{
Entities.QueryKnowledgeLib query = new Entities.QueryKnowledgeLib();
if (!right_Approval && !right_Reject && !right_Disable) //如果不具备 审核通过、驳回、停用的权限 则只能查看到自己提交的信息
{
query.CreateUserID = userID;
}
if (RequestTitle != "")
{
query.Title = RequestTitle;
}
if (RequestKCID != "")
{
query.KCID = int.Parse(RequestKCID);
}
if (RequestProperty != "")
{
query.Property = RequestProperty;
}
if (RequestStatus != "")
{
query.StatusS = RequestStatus;
}
if (RequestCreateUserID != "")
{
query.CreateUserID = int.Parse(RequestCreateUserID);
}
if (RequestBeginTime != "")
{
query.BeginTime = RequestBeginTime;
}
if (RequestEndTime != "")
{
query.EndTime = RequestEndTime;
}
if (RequestCategory != "")
{
query.Category = RequestCategory;
}
if (RequestMBeginTime != "")
{
query.MBeginTime = RequestMBeginTime;
}
if (RequestMEndTime != "")
{
query.MEndTime = RequestMEndTime;
}
if (RequestModifyUserID != "")
{
query.LastModifyUserID = int.Parse(RequestModifyUserID);
}
query.UserID = BLL.Util.GetLoginUserID();
DataTable dt = BLL.KnowledgeLib.Instance.GetKnowledgeLibCount(query, BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
public void BindData()
{
Entities.QueryKnowledgeLib query = new Entities.QueryKnowledgeLib();
//if (!right_Approval && !right_Reject && !right_Disable) //如果不具备 审核通过、驳回、停用的权限 则只能查看到自己提交的信息
//{
// query.CreateUserID = userID;
//}
if (RequestTitle != "")
{
query.Title = RequestTitle;
}
if (RequestKCID != "")
{
query.KCID = int.Parse(RequestKCID);
}
if (RequestProperty != "")
{
query.Property = RequestProperty;
}
if (RequestStatusS != "")
{
query.StatusS = RequestStatusS;
}
if (RequestCreateUserID != "")
{
query.CreateUserID = int.Parse(RequestCreateUserID);
}
if (RequestBeginTime != "")
{
query.BeginTime = RequestBeginTime;
}
if (RequestEndTime != "")
{
query.EndTime = RequestEndTime;
}
if (RequestMBeginTime != "")
{
query.MBeginTime = RequestMBeginTime;
}
if (RequestMEndTime != "")
{
query.MEndTime = RequestMEndTime;
}
if (RequestCategory != "")
{
query.Category = RequestCategory;
}
if (RequestModifyUserID != "")
{
query.LastModifyUserID = Convert.ToInt32(RequestModifyUserID);
}
string wherePlug = BLL.UserGroupDataRigth.Instance.GetSqlRightstr("a", "BGID", "CreateUserID", BLL.Util.GetLoginUserID());
DataTable dt = BLL.KLFAQ.Instance.GetKLFAQ(query, "a.CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, wherePlug, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
//old logic
public void BindData()
{
Entities.QueryKnowledgeLib query = new Entities.QueryKnowledgeLib();
if (RequestKeywords != "")
{
query.Keywords = RequestKeywords;
}
if (RequestKCID != "")
{
query.KCIDS = RequestKCID;
}
query.Content = ""; //这边为空，后台控制是 内容Content!=''
query.Status = 2; //知识点状态为审核通过
//获取 全部 的总数
int allCount;
BLL.KnowledgeLib.Instance.GetKLIDAllCount(query, out allCount);
hidRecordCount.Value = allCount.ToString(); //全部
string str = string.Empty;
if (RequestUnRead != "")
{
query.UnRead = "";
query.UserID = BLL.Util.GetLoginUserID();
str = "1";
}
DataTable dt = BLL.KnowledgeLib.Instance.GetKnowledgeLib(query, " CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
int unReadCount; //未读总数
query.UnRead = "";
query.UserID = BLL.Util.GetLoginUserID();
DataTable dt_UnRead = BLL.KnowledgeLib.Instance.GetKnowledgeLib(query, " CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, out unReadCount);
//BLL.KnowledgeLib.Instance.GetKLIDAllCount(query, out unReadCount);
// hidUnRead.Value = unReadCount.ToString();
//获取全部table的ID 和 未读table的ID，如果全部table的ID不在未读table里面，则是已读，字体控制为正常，不需要加载未读小图标
string[] allKLID = new string[dt.Rows.Count];
string unReadKLID = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
allKLID[i] = dt.Rows[i]["KLID"].ToString();
}
for (int i = 0; i < dt_UnRead.Rows.Count; i++)
{
unReadKLID += dt_UnRead.Rows[i]["KLID"].ToString() + ",";
}
for (int i = 0; i < allKLID.Length; i++)
{
if (!unReadKLID.Contains(allKLID[i]))
{
hidImgID.Value += allKLID[i] + ",";
}
}
hidImgID.Value = hidImgID.Value.TrimEnd(',');
litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1);
}
