/// <summary>
/// 根据问卷ID取问卷下所有矩阵行列
/// </summary>
/// <param name="SIID"></param>
/// <returns></returns>
public DataTable GetAllMatrixDataTableBySIID(int SIID)
{
DataTable dt = null;
int RowCount = 0;
QuerySurveyMatrixTitle query = new QuerySurveyMatrixTitle();
query.SIID = SIID;
query.Status = 0;
dt = GetSurveyMatrixTitle(query, "", 1, 100000, out RowCount);
return(dt);
}
/// <summary>
/// 取矩阵行列
/// </summary>
/// <param name="SQID"></param>
/// <param name="Type"></param>
/// <returns></returns>
private DataTable GetMatrixDataTable(int SQID, int Type)
{
DataTable dt = null;
int RowCount = 0;
QuerySurveyMatrixTitle query = new QuerySurveyMatrixTitle();
query.SQID = SQID;
query.Type = Type;
query.Status = 0;
dt = BLL.SurveyMatrixTitle.Instance.GetSurveyMatrixTitle(query, "", 1, 100000, out RowCount);
return(dt);
}
/// <summary>
/// 按照查询条件查询
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="order">排序</param>
/// <param name="currentPage">页号,-1不分页</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="totalCount">总行数</param>
/// <returns>集合</returns>
public DataTable GetSurveyMatrixTitle(QuerySurveyMatrixTitle query, string order, int currentPage, int pageSize, out int totalCount)
{
string where = string.Empty;
if (query.SMTID != Constant.INT_INVALID_VALUE)
{
where += " And SMTID=" + query.SMTID;
}
if (query.SIID != Constant.INT_INVALID_VALUE)
{
where += " And SIID=" + query.SIID;
}
if (query.SQID != Constant.INT_INVALID_VALUE)
{
where += " And SQID=" + query.SQID;
}
if (query.Status != Constant.INT_INVALID_VALUE)
{
where += " And Status=" + query.Status;
}
if (query.Type != Constant.INT_INVALID_VALUE)
{
where += " And Type=" + query.Type;
}
DataSet ds;
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 40000),
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 = order;
parameters[2].Value = pageSize;
parameters[3].Value = currentPage;
parameters[4].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_SURVEYMATRIXTITLE_SELECT, parameters);
totalCount = (int)(parameters[4].Value);
return(ds.Tables[0]);
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool IsExistsBySMTID(int SMTID)
{
QuerySurveyMatrixTitle query = new QuerySurveyMatrixTitle();
query.SMTID = SMTID;
DataTable dt = new DataTable();
int count = 0;
dt = GetSurveyMatrixTitle(query, string.Empty, 1, 1, out count);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entities.SurveyMatrixTitle GetSurveyMatrixTitle(int SMTID)
{
QuerySurveyMatrixTitle query = new QuerySurveyMatrixTitle();
query.SMTID = SMTID;
DataTable dt = new DataTable();
int count = 0;
dt = GetSurveyMatrixTitle(query, string.Empty, 1, 1, out count);
if (count > 0)
{
return(LoadSingleSurveyMatrixTitle(dt.Rows[0]));
}
else
{
return(null);
}
}
public List <Entities.SurveyMatrixTitle> GetMatrixTitleList(int siid)
{
List <Entities.SurveyMatrixTitle> list = new List <Entities.SurveyMatrixTitle>();
Entities.QuerySurveyMatrixTitle query = new QuerySurveyMatrixTitle();
int totalCount = 0;
query.SIID = siid;
query.Status = 0;
DataTable dt = GetSurveyMatrixTitle(query, "", 1, 9999, out totalCount);
if (totalCount > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(LoadSingleSurveyMatrixTitle(dr));
}
}
return(list);
}
/// <summary>
/// 按照查询条件查询
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="order">排序</param>
/// <param name="currentPage">页号,-1不分页</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="totalCount">总行数</param>
/// <returns>集合</returns>
public DataTable GetSurveyMatrixTitle(QuerySurveyMatrixTitle query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.SurveyMatrixTitle.Instance.GetSurveyMatrixTitle(query, order, currentPage, pageSize, out totalCount));
}
private void SurveyProjectInfoBind()
{
int spIid = 0;
if (int.TryParse(SPIID, out spIid))
{
Entities.QuerySurveyProjectInfo query = new QuerySurveyProjectInfo();
//query.BGIDStr = BLL.UserGroupDataRigth.Instance.GetUserGroupDataRightBgIDStrByUserID(BLL.Util.GetLoginUserID());
query.LoginUserID = BLL.Util.GetLoginUserID();
query.SPIID = spIid;
int totalCount = 0;
BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, "", 1, 1, out totalCount);
if (totalCount > 0)
{
Entities.SurveyProjectInfo info = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(spIid);
if (info != null)
{
spanProjectName.InnerText = info.Name;
spanDescription.InnerText = info.Description;
DataTable bgBt = BLL.BusinessGroup.Instance.GetBusinessGroupByBGID((int)info.BGID);
if (bgBt != null && bgBt.Rows.Count > 0)
{
spanBGID.InnerText = bgBt.Rows[0]["Name"].ToString();
}
Entities.SurveyCategory categoryInfo = BLL.SurveyCategory.Instance.GetSurveyCategory((int)info.SCID);
if (categoryInfo != null)
{
spanBCID.InnerText = categoryInfo.Name;
}
Entities.SurveyInfo surveyInfo = BLL.SurveyInfo.Instance.GetSurveyInfo((int)info.SIID);
spanSIID.InnerText = surveyInfo.Name;
spanBusinessGroup.InnerText = info.BusinessGroup;
spanBeginTime.InnerText = info.SurveyStartTime.ToString();
spanEndTime.InnerText = info.SurveyEndTime.ToString();
DataTable dt = BLL.SurveyPerson.Instance.GetSurveyPersonBySPIID(info.SPIID);
if (dt != null && dt.Rows.Count > 0)
{
string personNames = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
int userId = int.Parse(dt.Rows[i]["ExamPersonID"].ToString());
string userName = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(userId);
if (i > 0)
{
personNames += ",";
}
Entities.QuerySurveyAnswer queryAnswer = new QuerySurveyAnswer();
queryAnswer.CreateUserID = userId;
queryAnswer.SPIID = spIid;
int answerCount = 0;
BLL.SurveyAnswer.Instance.GetSurveyAnswer(queryAnswer, "", 1, 1000, out answerCount);
if (answerCount > 0)
{
personNames += "<a href='/SurveyInfo/PersonalSurveyInfoView.aspx?SPIID=" + spIid + "&UserID=" + userId + "' target='_blank'>" + userName + "</a>";
}
else
{
personNames += userName;
}
}
spanPersons.InnerHtml = personNames;
spanEstimateNumber.InnerText = dt.Rows.Count.ToString();
}
int userCount = BLL.SurveyAnswer.Instance.GetAnswerUserCountBySPIID(spIid);
Entities.QuerySurveyQuestion questionQuery = new QuerySurveyQuestion();
questionQuery.AskCategory = 5;
questionQuery.SIID = (int)info.SIID;
string scoreStr = string.Empty;
int questionTotalCount = 0;
DataTable dtQuestion = BLL.SurveyQuestion.Instance.GetSurveyQuestion(questionQuery, "", 1, 1000, out questionTotalCount);
int row = 0;
foreach (DataRow dr in dtQuestion.Rows)
{
if (row > 0)
{
scoreStr += "；";
}
int sqId = int.Parse(dr["SQID"].ToString());
Entities.QuerySurveyMatrixTitle queryRow = new QuerySurveyMatrixTitle();
queryRow.SQID = sqId;
queryRow.Type = 1;
int rowCount = 0;
BLL.SurveyMatrixTitle.Instance.GetSurveyMatrixTitle(queryRow, "", 1, 1000, out rowCount);
int colCount = 0;
queryRow.Type = 2;
BLL.SurveyMatrixTitle.Instance.GetSurveyMatrixTitle(queryRow, "", 1, 1000, out colCount);
int sumScore = BLL.SurveyQuestion.Instance.GetQuestionForMatrixDropdownSumScore(sqId, spIid);
if (userCount > 0)
{
decimal score = (decimal)sumScore / userCount;
scoreStr += (int.Parse(dr["OrderNum"].ToString()) + 1) + "(" + score.ToString("0.00") + ")";
}
}
spanScore.InnerText = scoreStr;
spanFinshTime.InnerText = info.SurveyEndTime.ToString();
spanTrueNumber.InnerText = userCount.ToString();
spanCreateUserName.InnerText = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName((int)info.CreateUserID);
spanCreateTime.InnerText = info.CreateTime.ToString();
row++;
}
}
else
{
Response.Write("<script>location.href='about:blank'</script>;");
}
}
}
