/// <summary>
/// 通过条件查询提问的KLRaiseQuestion数据
/// </summary>
/// <param name="query"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetKLRaiseQuestionDataForManage(QueryKLRaiseQuestions query, string QuestionedUserName, string order, int currentPage, int pageSize, out int totalCount, int userid)
{
string where = string.Empty;
where += GetQueryKLRaiseQuestionWhere(query);
where += Dal.UserGroupDataRigth.Instance.GetSqlRightstr("KLRaiseQuestions", "BGID", "CreateUserID", userid);
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 40000),
new SqlParameter("@questionedUserName", SqlDbType.NVarChar, 200),
new SqlParameter("@order", SqlDbType.NVarChar, 200),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@indexpage", SqlDbType.Int, 4),
new SqlParameter("@totalRecorder", SqlDbType.Int, 4)
};
parameters[0].Value = where;
parameters[1].Value = QuestionedUserName;
parameters[2].Value = order;
parameters[3].Value = pageSize;
parameters[4].Value = currentPage;
parameters[5].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KLRaiseQuestions_Select, parameters);
totalCount = (int)(parameters[5].Value);
return(ds.Tables[0]);
}
/// <summary>
/// 通过条件查询提问的KLRaiseQuestion数据
/// </summary>
/// <param name="query"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetKLRaiseQuestionDataForManage(QueryKLRaiseQuestions query, string QuestionedUserName, string order, int currentPage, int pageSize, out int totalCount)
{
int userid = BLL.Util.GetLoginUserID();
return(Dal.Personalization.Instance.GetKLRaiseQuestionDataForManage(query, QuestionedUserName, order, currentPage, pageSize, out totalCount, userid));
}
public string GetQueryKLRaiseQuestionWhere(QueryKLRaiseQuestions query)
{
string where = string.Empty;
if (query.Id != Constant.INT_INVALID_VALUE)
{
where += " and Id=" + query.Id;
}
if (query.CreateUserId != Constant.INT_INVALID_VALUE)
{
where += " and CreateUserId=" + query.CreateUserId;
}
if (query.CreateDate != Constant.DATE_INVALID_VALUE)
{
where += " And CreateDate<='" + query.CreateDate.ToString("yyyy-MM-dd") + " 23:59:59' And CreateDate>='" + query.CreateDate.ToString("yyyy-MM-dd") + " 00:00:00' ";
}
if (query.Title != Constant.STRING_INVALID_VALUE)
{
where += " and Title like '%" + StringHelper.SqlFilter(query.Title) + "%'";
}
if (query.CONTENT != Constant.STRING_INVALID_VALUE)
{
where += " and CONTENT like '%" + StringHelper.SqlFilter(query.CONTENT) + "%'";
}
if (query.KLCId != Constant.INT_INVALID_VALUE && query.RegionID != Constant.INT_INVALID_VALUE)
{
where += " and KLCId IN (SELECT KCID FROM dbo.TF_GetKnowledgeCategory(" + query.KLCId + ") )";
}
if (query.KLRefId != Constant.INT_INVALID_VALUE)
{
where += " and KLRefId=" + query.KLRefId;
}
if (query.Type != Constant.INT_INVALID_VALUE)
{
where += " and Type=" + query.Type;
}
if (query.Status != Constant.INT_INVALID_VALUE)
{
where += " and Status=" + query.Status;
}
if (query.AnswerUser != Constant.INT_INVALID_VALUE)
{
where += " and AnswerUser="******" and BGID=" + query.BGID;
}
if (query.LastModifyDate != Constant.DATE_INVALID_VALUE)
{
where += " And LastModifyDate<='" + query.CreateDate.ToString("yyyy-MM-dd") + " 23:59:59' And LastModifyDate>='" + query.CreateDate.ToString("yyyy-MM-dd") + " 00:00:00' ";
}
if (query.LastModifyBy != Constant.INT_INVALID_VALUE)
{
where += " and LastModifyBy=" + query.LastModifyBy;
}
if (query.CreateUserName != Constant.STRING_INVALID_VALUE)
{
where += " and CONTENT like '%" + StringHelper.SqlFilter(query.CreateUserName) + "%'";
}
if (query.QueryStatuses != Constant.STRING_INVALID_VALUE)
{
where += " and Status in(" + Dal.Util.SqlFilterByInCondition(query.QueryStatuses) + ")";
}
if (query.CreateBeginTime != Constant.DATE_INVALID_VALUE)
{
where += " And CreateDate >='" + query.CreateBeginTime.ToString("yyyy-MM-dd") + " 00:00:00'";
}
if (query.CreateEndTime != Constant.DATE_INVALID_VALUE)
{
where += " And CreateDate<='" + query.CreateEndTime.ToString("yyyy-MM-dd") + " 23:59:59'";
}
if (query.AnswerBeginTime != Constant.DATE_INVALID_VALUE)
{
where += " And LastModifyDate >='" + query.AnswerBeginTime.ToString("yyyy-MM-dd") + " 00:00:00'";
}
if (query.AnswerEndTime != Constant.DATE_INVALID_VALUE)
{
where += " And LastModifyDate<='" + query.AnswerEndTime.ToString("yyyy-MM-dd") + " 23:59:59'";
}
//if (query.QueryBGIDs != Constant.STRING_INVALID_VALUE && query.QueryBGIDs != "")
//{
// where += " And BGID in(" + Dal.Util.SqlFilterByInCondition(query.QueryBGIDs) + ")";
//}
return(where);
}
