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)
{
if (info.Status == 1 || ((int)info.Status == 0 && DateTime.Compare((DateTime)info.SurveyStartTime, DateTime.Now) < 0))
{
Response.Write("<script>location.href='about:blank'</script>;");
}
txtProjectName.Value = info.Name;
sltUserGroup.Value = info.BGID.ToString();
sltSurveyCategory.Value = info.SCID.ToString();
surveyCategoryStr = info.SCID.ToString();
txtDescription.Value = info.Description;
Entities.SurveyInfo surveyInfo = BLL.SurveyInfo.Instance.GetSurveyInfo((int)info.SIID);
txtSurveyName.Value = surveyInfo.Name;
hdnSIID.Value = surveyInfo.SIID.ToString();
txtBusinessGroup.Value = info.BusinessGroup;
BeginDateTime = info.SurveyStartTime.ToString();
EndDateTime = info.SurveyEndTime.ToString();
DataTable dt = BLL.SurveyPerson.Instance.GetSurveyPersonBySPIID(info.SPIID);
if (dt != null && dt.Rows.Count > 0)
{
string personNames = string.Empty;
string personIds = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
string userName = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(int.Parse(dt.Rows[i]["ExamPersonID"].ToString()));
if (i > 0)
{
personNames += ",";
personIds += ",";
}
personNames += userName;
personIds += dt.Rows[i]["ExamPersonID"].ToString();
}
txtExamPersonNames.Value = personNames;
hdnPersonIDS.Value = personIds;
}
}
}
else
{
Response.Write("<script>location.href='about:blank'</script>;");
}
}
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool IsExistsBySPIID(int SPIID)
{
QuerySurveyProjectInfo query = new QuerySurveyProjectInfo();
query.SPIID = SPIID;
DataTable dt = new DataTable();
int count = 0;
dt = GetSurveyProjectInfo(query, string.Empty, 1, 1, out count);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entities.SurveyProjectInfo GetSurveyProjectInfo(int SPIID)
{
QuerySurveyProjectInfo query = new QuerySurveyProjectInfo();
query.SPIID = SPIID;
DataTable dt = new DataTable();
int count = 0;
dt = GetSurveyProjectInfo(query, string.Empty, 1, 1, out count);
if (count > 0)
{
return(LoadSingleSurveyProjectInfo(dt.Rows[0]));
}
else
{
return(null);
}
}
/// <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 GetSurveyProjectInfo(QuerySurveyProjectInfo query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, order, currentPage, pageSize, out totalCount));
}
/// <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 GetSurveyProjectInfo(QuerySurveyProjectInfo query, string order, int currentPage, int pageSize, out int totalCount)
{
string where = string.Empty;
if (query.SPIID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
where += " AND spi.SPIID=" + query.SPIID;
}
if (query.Name != Entities.Constants.Constant.STRING_INVALID_VALUE)
{
where += " AND spi.Name LIKE '%" + Utils.StringHelper.SqlFilter(query.Name) + "%'";
}
if (query.BusinessGroup != Entities.Constants.Constant.STRING_INVALID_VALUE)
{
where += " AND spi.BusinessGroup LIKE '%" + Utils.StringHelper.SqlFilter(query.BusinessGroup) + "%'";
}
if (query.BGID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
where += " AND spi.BGID=" + query.BGID;
}
if (query.SCID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
where += " AND spi.SCID=" + query.SCID;
}
if (query.StatusStr != Entities.Constants.Constant.STRING_INVALID_VALUE)
{
string[] statusArry = query.StatusStr.Split(',');
where += " And (";
int i = 0;
foreach (string status in statusArry)
{
if (i > 0)
{
where += " OR ";
}
switch (status)
{
case "0": //未开始
where += "( spi.SurveyStartTime>getdate() )";
break;
case "1": //进行中
where += "( spi.SurveyStartTime<=getdate() And spi.SurveyEndTime>=getdate() )";
break;
case "2": //已结束
where += "( spi.SurveyEndTime<getdate() And spi.status=0 )";
break;
}
i++;
}
where += ")";
}
if (query.BeginCreateTime != Entities.Constants.Constant.DATE_INVALID_VALUE)
{
where += " AND spi.CreateTime>='" + query.BeginCreateTime + "'";
}
if (query.EndCreateTime != Entities.Constants.Constant.DATE_INVALID_VALUE)
{
where += " AND spi.CreateTime<='" + query.EndCreateTime + "'";
}
if (query.CreateUserID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
where += " AND spi.CreateUserID=" + query.CreateUserID;
}
if (query.LoginUserID != Entities.Constants.Constant.INT_INVALID_VALUE)
{
where += Dal.UserGroupDataRigth.Instance.GetSqlRightstr("spi", "BGID", "CreateUserID", (int)query.LoginUserID);
//where += " And (EXISTS(SELECT * FROM UserDataRigth WHERE UserID=" + query.LoginUserID + " And RightType=2)";
//where += " OR ((spi.BGID IN (SELECT BGID FROM UserGroupDataRigth WHERE UserID=" + query.LoginUserID + " And RightType=2))";
//where += " OR (spi.BGID IN (SELECT BGID FROM UserGroupDataRigth WHERE UserID=" + query.LoginUserID + " And RightType=1) And spi.CreateUserID=" + query.LoginUserID + ")))";
}
where += " AND spi.Status >=0 ";
//lxw 10.29
if (query.SCIDStr != Entities.Constants.Constant.STRING_INVALID_VALUE)
{
where += " And spi.SCID in (" + Dal.Util.SqlFilterByInCondition(query.SCIDStr) + ")";
}
if (query.CreaterType == 1 && query.UserID != Constant.INT_INVALID_VALUE)
{
where += " AND spi.SPIID IN (Select SPIID From SurveyPerson sp Where sp.SPIID=spi.SPIID AND sp.ExamPersonID=" + query.UserID + ")";
}
if (query.SurveyStartTime != Constant.DATE_INVALID_VALUE)
{
where += " AND spi.SurveyStartTime>='" + query.SurveyStartTime + "'";
}
if (query.SurveyEndTime != Constant.DATE_INVALID_VALUE)
{
where += " AND spi.SurveyEndTime<='" + query.SurveyEndTime + "'";
}
if (query.Status != Entities.Constants.Constant.INT_INVALID_VALUE)
{
where += " AND spi.Status=" + query.Status;
}
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_SURVEYPROJECTINFO_SELECT, parameters);
totalCount = (int)(parameters[4].Value);
return(ds.Tables[0]);
}
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>;");
}
}
}
