/// <summary> /// 增加一条数据 /// </summary> public int Insert(SqlTransaction sqltran, Entities.SurveyAnswer model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@SPIID", SqlDbType.Int, 4), new SqlParameter("@SIID", SqlDbType.Int, 4), new SqlParameter("@SQID", SqlDbType.Int, 4), new SqlParameter("@SMRTID", SqlDbType.Int, 4), new SqlParameter("@SMCTID", SqlDbType.Int, 4), new SqlParameter("@SOID", SqlDbType.Int, 4), new SqlParameter("@AnswerContent", SqlDbType.NVarChar, 2000), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4), new SqlParameter("@PTID", SqlDbType.VarChar, 20), new SqlParameter("@ReturnVisitCRMCustID", SqlDbType.VarChar) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.SPIID; parameters[2].Value = model.SIID; parameters[3].Value = model.SQID; parameters[4].Value = model.SMRTID; parameters[5].Value = model.SMCTID; parameters[6].Value = model.SOID; parameters[7].Value = model.AnswerContent; parameters[8].Value = model.CreateTime; parameters[9].Value = model.CreateUserID; parameters[10].Value = model.PTID; parameters[11].Value = model.ReturnVisitCRMCustID; SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_SURVEYANSWER_INSERT, parameters); return((int)parameters[0].Value); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.SurveyAnswer model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@SPIID", SqlDbType.Int, 4), new SqlParameter("@SIID", SqlDbType.Int, 4), new SqlParameter("@SQID", SqlDbType.Int, 4), new SqlParameter("@SMRTID", SqlDbType.Int, 4), new SqlParameter("@SMCTID", SqlDbType.Int, 4), new SqlParameter("@SOID", SqlDbType.Int, 4), new SqlParameter("@AnswerContent", SqlDbType.NVarChar, 2000), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.RecID; parameters[1].Value = model.SPIID; parameters[2].Value = model.SIID; parameters[3].Value = model.SQID; parameters[4].Value = model.SMRTID; parameters[5].Value = model.SMCTID; parameters[6].Value = model.SOID; parameters[7].Value = model.AnswerContent; parameters[8].Value = model.CreateTime; parameters[9].Value = model.CreateUserID; return(SqlHelper.ExecuteNonQuery(sqltran, CONNECTIONSTRINGS, CommandType.StoredProcedure, P_SURVEYANSWER_UPDATE, parameters)); }
private Entities.SurveyAnswer LoadSingleSurveyAnswer(DataRow row) { Entities.SurveyAnswer model = new Entities.SurveyAnswer(); if (row["RecID"].ToString() != "") { model.RecID = int.Parse(row["RecID"].ToString()); } if (row["SPIID"].ToString() != "") { model.SPIID = int.Parse(row["SPIID"].ToString()); } if (row["SIID"].ToString() != "") { model.SIID = int.Parse(row["SIID"].ToString()); } if (row["SQID"].ToString() != "") { model.SQID = int.Parse(row["SQID"].ToString()); } if (row["SMRTID"].ToString() != "") { model.SMRTID = int.Parse(row["SMRTID"].ToString()); } if (row["SMCTID"].ToString() != "") { model.SMCTID = int.Parse(row["SMCTID"].ToString()); } if (row["SOID"].ToString() != "") { model.SOID = int.Parse(row["SOID"].ToString()); } model.AnswerContent = row["AnswerContent"].ToString(); if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } return(model); }
//问卷调查提交 private void surveyAnswerSubmit(out string msg) { msg = string.Empty; judgeIsCorrect(out msg); if (msg != "success") { return; } #region 提交准备数据 SurveyAnswerRoot modelRoot = null; List <Entities.SurveyAnswer> list_ESurveyAnswer = new List <Entities.SurveyAnswer>(); ArrayList array_UserActionLog = new ArrayList();//日志 modelRoot = (SurveyAnswerRoot)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(RequestJsonSurveyAnswer, typeof(SurveyAnswerRoot)); if (modelRoot == null) { msg = "提交的问卷数据不存在"; return; } for (int i = 0; i < modelRoot.DataRoot.Length; i++) { Entities.SurveyAnswer model = new Entities.SurveyAnswer(); SurveyAnswer answer = modelRoot.DataRoot[i]; int _spiid; if (int.TryParse(RequestSPIID, out _spiid)) { model.SPIID = _spiid; } if (!string.IsNullOrEmpty(RequestPTID)) { model.PTID = RequestPTID; } int _siid; if (int.TryParse(RequestSIID, out _siid)) { model.SIID = _siid; } int _sqid; if (int.TryParse(answer.SQID, out _sqid)) { model.SQID = _sqid; } int _smrtid; if (int.TryParse(answer.SMRTID, out _smrtid)) { model.SMRTID = _smrtid; } int _smctid; if (int.TryParse(answer.SMCTID, out _smctid)) { model.SMCTID = _smctid; } int _soid; if (int.TryParse(answer.SOID, out _soid)) { model.SOID = _soid; } model.AnswerContent = answer.AnswerContent; model.CreateUserID = userID; model.CreateTime = DateTime.Now; list_ESurveyAnswer.Add(model); string logStr = string.Empty; logStr = "调查问卷回答信息表【插入】问卷调查项目ID【" + model.SPIID + "】调查问卷ID【" + model.SIID + "】调查问卷试题ID【" + model.SQID + "】提交人【" + model.CreateUserID + "】调查问卷矩阵行ID【" + model.SMRTID + "】矩阵列ID【" + model.SMCTID + "】调查问卷选项ID【" + model.SOID + "】回答内容【" + model.AnswerContent + "】创建时间【" + model.CreateTime + "】"; array_UserActionLog.Add(logStr); } #endregion #region 事务提交 string connectionstrings = ConfigurationUtil.GetAppSettingValue("ConnectionStrings_CC"); SqlConnection connection = new SqlConnection(connectionstrings); connection.Open(); SqlTransaction tran = connection.BeginTransaction("SampleTransaction"); try { //删除之前的答案 if (!string.IsNullOrEmpty(RequestPTID)) { int _siid1; if (int.TryParse(RequestSIID, out _siid1)) { BLL.SurveyAnswer.Instance.Delete(tran, _siid1, RequestPTID); } } for (int i = 0; i < list_ESurveyAnswer.Count; i++) { BLL.SurveyAnswer.Instance.Insert(tran, list_ESurveyAnswer[i]); } for (int i = 0; i < array_UserActionLog.Count; i++) { BLL.Util.InsertUserLog(tran, array_UserActionLog[i].ToString()); } //是否答过题,默认答没答过 bool flag = false; if (list_ESurveyAnswer.Count == 0) { flag = false; } else { for (int i = 0; i < list_ESurveyAnswer.Count; i++) { if (list_ESurveyAnswer[i].SOID != -2 || list_ESurveyAnswer[i].AnswerContent != "" || list_ESurveyAnswer[i].SMCTID != -2 || list_ESurveyAnswer[i].SMRTID != -2) { flag = true; } } } //答过题记录 if (flag == true) { //判断该项目,该任务,该问卷,是否已有答问卷记录,没有插入 DataTable dt = null; Entities.QueryProjectTask_SurveyAnswer querey = new Entities.QueryProjectTask_SurveyAnswer(); querey.PTID = RequestPTID; int _projectID; if (int.TryParse(RequestProjectID, out _projectID)) { } querey.ProjectID = _projectID; int _siid; if (int.TryParse(RequestSIID, out _siid)) { } querey.SIID = _siid; //int rowcount = 0; //dt = BLL.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswer(tran, querey, "", 1, 1000000, out rowcount); Entities.ProjectTask_SurveyAnswer getModel = BLL.ProjectTask_SurveyAnswer.Instance.GetProjectTask_SurveyAnswerByQuery(tran, querey); if (getModel == null) { Entities.ProjectTask_SurveyAnswer model = new Entities.ProjectTask_SurveyAnswer(); model.ProjectID = _projectID; model.PTID = RequestPTID; model.SIID = _siid; model.CreateTime = System.DateTime.Now; model.CreateUserID = BLL.Util.GetLoginUserID(); model.Status = RequestIsSub; BLL.ProjectTask_SurveyAnswer.Instance.Insert(tran, model); } else { getModel.CreateTime = DateTime.Now; getModel.Status = RequestIsSub; BLL.ProjectTask_SurveyAnswer.Instance.UpdateCreateTimeAndStatus(tran, getModel); } } msg = "success"; tran.Commit(); } catch (Exception ex) { BitAuto.ISDC.CC2012.BLL.Loger.Log4Net.Error("[TakingAnSurveyHandler.ashx]surveyAnswerSubmit...任务ID:" + RequestPTID + ",事务提交阶段出错:", ex); if (tran.Connection != null) { tran.Rollback(); } msg = ex.Message.ToString(); } finally { connection.Close(); } #endregion }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.SurveyAnswer model) { return(Dal.SurveyAnswer.Instance.Update(sqltran, model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.SurveyAnswer model) { return(Dal.SurveyAnswer.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(SqlTransaction sqltran, Entities.SurveyAnswer model) { Dal.SurveyAnswer.Instance.Insert(sqltran, model); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.SurveyAnswer model) { Dal.SurveyAnswer.Instance.Insert(model); }
//问卷调查提交 private void surveyAnswerSubmit(out string msg) { msg = string.Empty; judgeIsCorrect(out msg); if (msg != "success") { return; } #region 提交准备数据 SurveyAnswerRoot modelRoot = null; List <Entities.SurveyAnswer> list_ESurveyAnswer = new List <Entities.SurveyAnswer>(); ArrayList array_UserActionLog = new ArrayList();//日志 modelRoot = (SurveyAnswerRoot)Newtonsoft.Json.JavaScriptConvert.DeserializeObject(RequestJsonSurveyAnswer, typeof(SurveyAnswerRoot)); if (modelRoot == null) { msg = "提交的问卷数据不存在"; return; } for (int i = 0; i < modelRoot.DataRoot.Length; i++) { Entities.SurveyAnswer model = new Entities.SurveyAnswer(); SurveyAnswer answer = modelRoot.DataRoot[i]; int _spiid; if (int.TryParse(RequestSPIID, out _spiid)) { model.SPIID = _spiid; } int _siid; if (int.TryParse(RequestSIID, out _siid)) { model.SIID = _siid; } int _sqid; if (int.TryParse(answer.SQID, out _sqid)) { model.SQID = _sqid; } int _smrtid; if (int.TryParse(answer.SMRTID, out _smrtid)) { model.SMRTID = _smrtid; } int _smctid; if (int.TryParse(answer.SMCTID, out _smctid)) { model.SMCTID = _smctid; } int _soid; if (int.TryParse(answer.SOID, out _soid)) { model.SOID = _soid; } model.AnswerContent = answer.AnswerContent; model.CreateUserID = userID; model.CreateTime = DateTime.Now; list_ESurveyAnswer.Add(model); string logStr = string.Empty; logStr = "调查问卷回答信息表【插入】问卷调查项目ID【" + model.SPIID + "】调查问卷ID【" + model.SIID + "】调查问卷试题ID【" + model.SQID + "】提交人【" + model.CreateUserID + "】调查问卷矩阵行ID【" + model.SMRTID + "】矩阵列ID【" + model.SMCTID + "】调查问卷选项ID【" + model.SOID + "】回答内容【" + model.AnswerContent + "】创建时间【" + model.CreateTime + "】"; array_UserActionLog.Add(logStr); } #endregion #region 事务提交 string connectionstrings = ConfigurationUtil.GetAppSettingValue("ConnectionStrings_CC"); SqlConnection connection = new SqlConnection(connectionstrings); connection.Open(); SqlTransaction tran = connection.BeginTransaction("SampleTransaction"); try { for (int i = 0; i < list_ESurveyAnswer.Count; i++) { BLL.SurveyAnswer.Instance.Insert(tran, list_ESurveyAnswer[i]); } for (int i = 0; i < array_UserActionLog.Count; i++) { BLL.Util.InsertUserLog(tran, array_UserActionLog[i].ToString()); } msg = "success"; tran.Commit(); } catch (Exception ex) { if (tran.Connection != null) { tran.Rollback(); } msg = ex.Message.ToString(); } finally { connection.Close(); } #endregion }