public void BindData() { Entities.QuerySurveyProjectInfo query = new Entities.QuerySurveyProjectInfo(); if (RequestCategory != "") { query.SCIDStr = RequestCategory; } if (RequestName != "") { query.Name = RequestName; } query.StatusStr = "1,2"; //状态包括1-进行中;2-已结束; query.CreaterType = 1; query.UserID = userID; //将当前登录者赋值给UserID DataTable dt = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, "spi.CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount); repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); hidSurveyAll.Value = RecordCount.ToString(); //全部 query.StatusStr = "1"; //query.SurveyEndTime = DateTime.Now; //正在进行中 int count; DataTable dt_surveying = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, " spi.CreateTime DESC", BLL.PageCommon.Instance.PageIndex, PageSize, out count); hidSurveying.Value = count.ToString(); litPagerDown.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, RecordCount, PageSize, BLL.PageCommon.Instance.PageIndex, 1); }
private void QuestionBind() { int spIid = -1; if (int.TryParse(SPIID, out spIid)) { Entities.QuerySurveyProjectInfo query = new Entities.QuerySurveyProjectInfo(); query.LoginUserID = BLL.Util.GetLoginUserID(); query.SPIID = spIid; int count = 0; DataTable dtProject = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, "", 1, 1000, out count); if (count > 0) { Entities.SurveyProjectInfo projectInfo = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(spIid); if (projectInfo != null) { if (projectInfo.SurveyStartTime <= DateTime.Now) { Entities.QuerySurveyQuestion queryQuestion = new Entities.QuerySurveyQuestion(); queryQuestion.SIID = (int)projectInfo.SIID; queryQuestion.Status = 0; int totalCount = 0; DataTable dt = BLL.SurveyQuestion.Instance.GetSurveyQuestion(queryQuestion, "OrderNum", 1, 1000, out totalCount); rptSurveyQuestion.DataSource = dt; rptSurveyQuestion.DataBind(); } } } } }
private void SurveyProjectBind() { Entities.QuerySurveyProjectInfo query = new Entities.QuerySurveyProjectInfo(); if (!string.IsNullOrEmpty(ProjectName)) { query.Name = ProjectName; } int bgId = 0; if (int.TryParse(BGID, out bgId) && bgId > 0) { query.BGID = bgId; } int scId = 0; if (int.TryParse(SCID, out scId) && scId > 0) { query.SCID = scId; } if (!string.IsNullOrEmpty(BusniessGroup)) { query.BusinessGroup = BusniessGroup; } if (!string.IsNullOrEmpty(SurveyStatus)) { query.StatusStr = SurveyStatus; } DateTime beginTime = Entities.Constants.Constant.DATE_INVALID_VALUE; DateTime endTime = Entities.Constants.Constant.DATE_INVALID_VALUE; if (DateTime.TryParse(BeginTime, out beginTime)) { query.SurveyStartTime = beginTime; } if (DateTime.TryParse(EndTime, out endTime)) { query.SurveyEndTime = endTime.Add(new TimeSpan(23, 59, 59)); } int userId = 0; if (int.TryParse(CreateUserID, out userId) && userId > 0) { query.CreateUserID = userId; } query.LoginUserID = BLL.Util.GetLoginUserID(); int totalCount = 0; DataTable dt = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, "spi.CreateTime desc", BLL.PageCommon.Instance.PageIndex, BLL.PageCommon.Instance.PageSize, out totalCount); rptSurveyProject.DataSource = dt; rptSurveyProject.DataBind(); AjaxPager_Project.PageSize = 10; AjaxPager_Project.InitPager(totalCount); }
//判断其状态是否是已使用,是-返回true;否-返回false public bool judgeIsUsed(string siid) { return(true); bool isUsed = false; int _siid; if (int.TryParse(siid, out _siid)) { Entities.QuerySurveyProjectInfo query = new Entities.QuerySurveyProjectInfo(); query.SIID = _siid; int count; DataTable dt = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query, "", 1, 10000, out count); if (dt.Rows.Count > 0) { isUsed = true; } } return(isUsed); }
private void UpdateSurveyCategoryStatus(out string msg) { msg = string.Empty; int _scid = 0; if (int.TryParse(RequestSCID, out _scid)) { Entities.SurveyCategory model = BLL.SurveyCategory.Instance.GetSurveyCategory(_scid); if (model != null) { int count; if (model.Status == 0) { if (model.TypeId == 1) { //判断该分类在调查问卷或调查项目中使用,则不能删除 Entities.QuerySurveyInfo query_surveyInfo = new Entities.QuerySurveyInfo(); query_surveyInfo.SCID = _scid; DataTable dt_surveyInfo = BLL.SurveyInfo.Instance.GetSurveyInfo(query_surveyInfo, "", 1, 10000, out count); if (dt_surveyInfo.Rows.Count > 0) { msg = "{msg:'该分类在调查问卷中有使用,无法停用'}"; return; } //判断该分类在调查问卷或调查项目中使用,则不能删除 Entities.QuerySurveyProjectInfo query_projectInfo = new Entities.QuerySurveyProjectInfo(); query_projectInfo.SCID = _scid; query_projectInfo.Status = 0; DataTable dt_projectInfo = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query_projectInfo, "", 1, 10000, out count); if (dt_projectInfo.Rows.Count > 0) { msg = "{msg:'该分类在调查项目中有使用,无法停用'}"; return; } } else if (model.TypeId == 2) { Entities.QueryProjectInfo query = new Entities.QueryProjectInfo(); query.PCatageID = _scid; query.Status = 0; DataTable dt = BLL.ProjectInfo.Instance.GetProjectInfo(query, "", 1, 9999, out count); if (dt != null && dt.Rows.Count > 0) { msg = "{msg:'该分类在数据清洗项目中有使用,无法停用'}"; return; } } model.Status = 1; } else if (model.Status == 1) { model.Status = 0; } int result = 0; try { result = BLL.SurveyCategory.Instance.Update(model); msg = "{msg:'success'}"; } catch (Exception ex) { msg = "{msg:'" + ex.Message + "'}"; } } } }
//问卷分类修改(包括编辑和删除) private void surveyCategoryUpdate(out string msg) { msg = string.Empty; int _scid; if (int.TryParse(RequestSCID, out _scid)) { Entities.SurveyCategory model = BLL.SurveyCategory.Instance.GetSurveyCategory(_scid); if (model != null) { string oldName = string.Empty; string newName = string.Empty; if (RequestName != "") { oldName = model.Name; model.Name = RequestName; newName = model.Name; } if (RequestStatus != "") { int count; if (TypeId == "1") { //判断该分类在调查问卷或调查项目中使用,则不能删除 Entities.QuerySurveyInfo query_surveyInfo = new Entities.QuerySurveyInfo(); query_surveyInfo.SCID = _scid; DataTable dt_surveyInfo = BLL.SurveyInfo.Instance.GetSurveyInfo(query_surveyInfo, "", 1, 10000, out count); if (dt_surveyInfo.Rows.Count > 0) { msg = "{msg:'该分类在调查问卷中有使用,无法删除'}"; return; } //判断该分类在调查问卷或调查项目中使用,则不能删除 Entities.QuerySurveyProjectInfo query_projectInfo = new Entities.QuerySurveyProjectInfo(); query_projectInfo.SCID = _scid; query_projectInfo.Status = 0; DataTable dt_projectInfo = BLL.SurveyProjectInfo.Instance.GetSurveyProjectInfo(query_projectInfo, "", 1, 10000, out count); if (dt_projectInfo.Rows.Count > 0) { msg = "{msg:'该分类在调查项目中有使用,无法删除'}"; return; } } else if (TypeId == "2") { Entities.QueryProjectInfo query = new Entities.QueryProjectInfo(); query.PCatageID = _scid; query.Status = 0; DataTable dt = BLL.ProjectInfo.Instance.GetProjectInfo(query, "", 1, 9999, out count); if (dt != null && dt.Rows.Count > 0) { msg = "{msg:'该分类在数据清洗项目中有使用,无法删除'}"; return; } } model.Status = int.Parse(RequestStatus); } int result = 0; try { result = BLL.SurveyCategory.Instance.Update(model); if (RequestStatus != "" && TypeId == "2") { //如果是其他任务的删除 BLL.CallRecord_ORIG_Business.Instance.DeleteBusinessUrl((int)model.BGID, (int)model.SCID); } if (result == 1) { msg = "{msg:'操作成功'}"; string logType = string.Empty; if (TypeId == "1") { //插入日志 if (model.Status == -1)//删除 { logType += "问卷分类【删除】主键【" + model.SCID + "】分类名称【" + model.Name + "】问卷"; } else if (oldName != string.Empty && newName != string.Empty) { logType += "问卷分类【修改】主键【" + model.SCID + "】分类名称由【" + oldName + "】修改为【" + newName + "】"; } } else if (TypeId == "2") { //插入日志 if (model.Status == -1)//删除 { logType += "项目分类【删除】主键【" + model.SCID + "】分类名称【" + model.Name + "】问卷"; } else if (oldName != string.Empty && newName != string.Empty) { logType += "项目分类【修改】主键【" + model.SCID + "】分类名称由【" + oldName + "】修改为【" + newName + "】"; } } BLL.Util.InsertUserLog(logType); } else { msg = "{msg:'操作失败'}"; } } catch (Exception ex) { msg = "{msg:'" + ex.Message + "'}"; } } } }