private static string GetWhere(QueryProjectTask_SurveyAnswer query) { string where = string.Empty; if (query.RecID != Constant.INT_INVALID_VALUE) { where += " AND RecID=" + query.RecID; } if (query.ProjectID != Constant.INT_INVALID_VALUE) { where += " AND ProjectID=" + query.ProjectID; } if (query.PTID != Constant.STRING_INVALID_VALUE) { where += " AND PTID='" + StringHelper.SqlFilter(query.PTID) + "'"; } if (query.SIID != Constant.INT_INVALID_VALUE) { where += " AND SIID=" + query.SIID; } if (query.CustID != Constant.STRING_INVALID_VALUE) { where += " AND ReturnVisitCustID='" + StringHelper.SqlFilter(query.CustID) + "'"; } return(where); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BitAuto.YanFa.SysRightManager.Common.UserInfo.Check(); if (!string.IsNullOrEmpty(RequestCustID)) { DataTable dt = null; dt = BLL.ProjectSurveyMapping.Instance.GetSurveyinfoByCustID(RequestCustID); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int RowCount = 0; QueryProjectTask_SurveyAnswer query = new QueryProjectTask_SurveyAnswer(); query.CustID = RequestCustID; int _siid = 0; if (int.TryParse(dt.Rows[i]["SIID"].ToString(), out _siid)) { } query.SIID = _siid; DataTable dtnew = BLL.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer(query, "", 1, 1000000, out RowCount); //当前时间不在周期里,并且问卷没有提交过答案 DateTime _beginTime = new DateTime(); DateTime _endTime = new DateTime(); if (DateTime.TryParse(dt.Rows[i]["begindate"].ToString(), out _beginTime)) { } if (DateTime.TryParse(dt.Rows[i]["endDate"].ToString(), out _endTime)) { } //答过问卷,或者问卷当前时间在问卷周期内 if (RowCount > 0 || (System.DateTime.Now >= _beginTime && System.DateTime.Now <= _endTime)) { //如果是查看 if (dtnew != null && dtnew.Rows.Count > 0) { if (dtnew.Rows[0]["Status"] != DBNull.Value) { if (dtnew.Rows[0]["Status"].ToString() == "1") { str += "<a href='../ReturnVisit/SurveyInfo.aspx?SIID=" + dt.Rows[i]["SIID"].ToString() + "&ProJectID=" + dt.Rows[i]["ProjectID"].ToString() + "&CustID=" + RequestCustID + "&Action=view' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a> "; } else { str += "<a href='../ReturnVisit/SurveyInfo.aspx?SIID=" + dt.Rows[i]["SIID"].ToString() + "&ProJectID=" + dt.Rows[i]["ProjectID"].ToString() + "&CustID=" + RequestCustID + "' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a> "; } } } else { str += "<a href='../ReturnVisit/SurveyInfo.aspx?SIID=" + dt.Rows[i]["SIID"].ToString() + "&ProJectID=" + dt.Rows[i]["ProjectID"].ToString() + "&CustID=" + RequestCustID + "' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a> "; } } } } } } }
/// 加载问卷 /// <summary> /// 加载问卷 /// </summary> protected void LoadSurvey() { RequestTaskID = CommonFunction.ObjectToString(ViewState["RequestTaskID"]); if (!string.IsNullOrEmpty(RequestTaskID)) { DataTable SurveyinfoDt = null; SurveyinfoDt = BLL.ProjectSurveyMapping.Instance.GetSurveyinfoByOtherTaskID(RequestTaskID); if (SurveyinfoDt != null && SurveyinfoDt.Rows.Count > 0) { for (int i = 0; i < SurveyinfoDt.Rows.Count; i++) { QueryProjectTask_SurveyAnswer query = new QueryProjectTask_SurveyAnswer(); query.PTID = RequestTaskID; int siid = CommonFunction.ObjectToInteger(SurveyinfoDt.Rows[i]["SIID"]); query.SIID = siid; //查询问卷个数:只取总数 int RowCount = BLL.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer_Count(query); //当前时间不在周期里,并且问卷没有提交过答案 DateTime beginTime = CommonFunction.ObjectToDateTime(SurveyinfoDt.Rows[i]["begindate"]); DateTime endTime = CommonFunction.ObjectToDateTime(SurveyinfoDt.Rows[i]["endDate"]); //答过问卷,或者问卷当前时间在问卷周期内 if (RowCount > 0 || (System.DateTime.Now >= beginTime && System.DateTime.Now <= endTime)) { //问卷控件 Control surveyCtl; Entities.SurveyInfo model = new Entities.SurveyInfo(); model.TaskID = RequestTaskID; model.SIID = siid; model.Num = SurveyCount; model.Name = SurveyinfoDt.Rows[i]["Name"].ToString(); //如果是查看 surveyCtl = this.LoadControl("~/OtherTask/UCOtherTask/UCSurveyInfoEdit.ascx", model); //把问卷保存在数据组中 SIIDStr += model.SIID.ToString() + ","; //共有多少问卷 SurveyCount = SurveyCount + 1; this.PlaceHolderSurvey.Controls.Add(surveyCtl); } } if (!string.IsNullOrEmpty(SIIDStr)) { SIIDStr = SIIDStr.Substring(0, SIIDStr.Length - 1); } hiddenSurveyCount.Value = SurveyCount.ToString(); hiddenSIIDStr.Value = SIIDStr; } } //调用前台代码,初始化跳题逻辑 GotoNumQuestion(); }
/// <summary> /// 根据条件,查询数据 /// </summary> /// <param name="query">条件对象</param> /// <returns>返回数据</returns> public DataTable GetProjectTask_SurveyAnswerByQuery(QueryProjectTask_SurveyAnswer query) { string where = GetWhere(query); string sql = string.Format("SELECT * FROM ProjectTask_SurveyAnswer WHERE 1=1 {0}", where); DataSet ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.Text, sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(ds.Tables[0]); } return(null); }
public int GetProjectTask_SurveyAnswer_Count(QueryProjectTask_SurveyAnswer query) { ////暂时先以存储过程的逻辑查询数据 //int RowCount = 0; DataTable dt = GetProjectTask_SurveyAnswerByQuery(query); if (dt != null) { return(dt.Rows.Count); } return(0); }
/// <summary> /// 加载问卷 /// </summary> protected void LoadSurvey() { if (!string.IsNullOrEmpty(RequestTaskID)) { DataTable dt = null; dt = BLL.ProjectSurveyMapping.Instance.GetSurveyinfoByOtherTaskID(RequestTaskID); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int RowCount = 0; QueryProjectTask_SurveyAnswer query = new QueryProjectTask_SurveyAnswer(); query.PTID = RequestTaskID; int _siid = 0; int.TryParse(dt.Rows[i]["SIID"].ToString(), out _siid); query.SIID = _siid; DataTable dtnew = BLL.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer(query, "", 1, 1000000, out RowCount); //当前时间不在周期里,并且问卷没有提交过答案 DateTime _beginTime = new DateTime(); DateTime _endTime = new DateTime(); DateTime.TryParse(dt.Rows[i]["begindate"].ToString(), out _beginTime); DateTime.TryParse(dt.Rows[i]["endDate"].ToString(), out _endTime); //问卷控件 Control ctl; //答过问卷,或者问卷当前时间在问卷周期内 if (RowCount > 0 || (System.DateTime.Now >= _beginTime && System.DateTime.Now <= _endTime)) { Entities.SurveyInfo model = new Entities.SurveyInfo(); model.TaskID = RequestTaskID; model.SIID = _siid; model.Num = SurveyCount; model.Name = dt.Rows[i]["Name"].ToString(); ctl = this.LoadControl("~/OtherTask/UCOtherTask/UCSurveyInfoView.ascx", model); //把问卷保存在数据组中 SIIDStr += model.SIID.ToString() + ","; //共有多少问卷 SurveyCount = SurveyCount + 1; this.PlaceHolderSurvey.Controls.Add(ctl); } } if (!string.IsNullOrEmpty(SIIDStr)) { SIIDStr = SIIDStr.Substring(0, SIIDStr.Length - 1); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(RequestTaskID)) { DataTable dt = null; dt = BLL.ProjectSurveyMapping.Instance.GetSurveyinfoByTaskID(RequestTaskID); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int RowCount = 0; QueryProjectTask_SurveyAnswer query = new QueryProjectTask_SurveyAnswer(); query.PTID = RequestTaskID; int _siid = 0; if (int.TryParse(dt.Rows[i]["SIID"].ToString(), out _siid)) { } query.SIID = _siid; DataTable dtnew = BLL.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer(query, "", 1, 1000000, out RowCount); //当前时间不在周期里,并且问卷没有提交过答案 DateTime _beginTime = new DateTime(); DateTime _endTime = new DateTime(); if (DateTime.TryParse(dt.Rows[i]["begindate"].ToString(), out _beginTime)) { } if (DateTime.TryParse(dt.Rows[i]["endDate"].ToString(), out _endTime)) { } //答过问卷,或者问卷当前时间在问卷周期内 if (RowCount > 0 || (System.DateTime.Now >= _beginTime && System.DateTime.Now <= _endTime)) { //如果是查看 if (Request["Action"] != null && Request["Action"] == "view") { str += "<a href='../../CustInfo/DetailV/SurveyInfo.aspx?SIID=" + dt.Rows[i]["SIID"].ToString() + "&ProJectID=" + dt.Rows[i]["ProjectID"].ToString() + "&TaskID=" + dt.Rows[i]["PTID"].ToString() + "&Action=view' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a> "; } else { str += "<a href='../../CustInfo/DetailV/SurveyInfo.aspx?SIID=" + dt.Rows[i]["SIID"].ToString() + "&ProJectID=" + dt.Rows[i]["ProjectID"].ToString() + "&TaskID=" + dt.Rows[i]["PTID"].ToString() + "' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a> "; } } } } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.ProjectTask_SurveyAnswer GetProjectTask_SurveyAnswer(long RecID) { QueryProjectTask_SurveyAnswer query = new QueryProjectTask_SurveyAnswer(); query.RecID = RecID; DataTable dt = GetProjectTask_SurveyAnswerByQuery(query); if (dt != null) { return(LoadSingleProjectTask_SurveyAnswer(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 是否存在该记录 /// </summary> public bool IsExistsByRecID(long RecID) { QueryProjectTask_SurveyAnswer query = new QueryProjectTask_SurveyAnswer(); query.RecID = RecID; DataTable dt = new DataTable(); int count = 0; dt = GetProjectTask_SurveyAnswer(query, string.Empty, 1, 1, out count); if (count > 0) { return(true); } else { return(false); } }
/// <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 GetProjectTask_SurveyAnswer(QueryProjectTask_SurveyAnswer query, string order, int currentPage, int pageSize, out int totalCount) { string where = GetWhere(query); DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 40000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@page", SqlDbType.Int, 4), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@TotalRecorder", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = currentPage; parameters[3].Value = pageSize; parameters[4].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_SURVEYANSWER_SELECT, parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
/// <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 GetProjectTask_SurveyAnswer(SqlTransaction tran, QueryProjectTask_SurveyAnswer query, string order, int currentPage, int pageSize, out int totalCount) { return(Dal.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer(tran, query, order, currentPage, pageSize, out totalCount)); }
public int GetProjectTask_SurveyAnswer_Count(QueryProjectTask_SurveyAnswer query) { return(Dal.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer_Count(query)); }
/// <summary> /// 根据条件,查询记录条数 /// </summary> /// <param name="tran">事务</param> /// <param name="query">条件对象</param> /// <returns>有记录返回True,否则返回False</returns> public Entities.ProjectTask_SurveyAnswer GetProjectTask_SurveyAnswerByQuery(SqlTransaction tran, QueryProjectTask_SurveyAnswer query) { DataTable dt = Dal.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswerByQuery(tran, query); if (dt != null && !string.IsNullOrEmpty(dt.Rows[0]["RecID"].ToString())) { return(Dal.ProjectTask_SurveyAnswer.Instance.LoadSingleProjectTask_SurveyAnswer(dt.Rows[0])); } return(null); }