/// <summary> /// 插入反馈意见 /// </summary> /// <param name="cardNo">学号</param> /// <param name="remark">反馈意见</param> /// <param name="loginId"></param> /// <returns></returns> public static Model.Enum.HandleResult AddFeedback(Model.AMS_FeedbackModel model) { IWCFService.IAdvertManageService advertService = WcfAccessProxy.AMS_ServiceProxy.CreateChannelAdvertManageService(); bool error = false; try { return(advertService.AddFeedback(model)); } catch (Exception ex) { error = true; SeatManage.SeatManageComm.WriteLog.Write(string.Format("添加反馈意见遇到异常,异常模块:{0};信息:{1}", ex.Source, ex.Message)); throw ex; } finally { ICommunicationObject ICommObjectService = advertService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
/// <summary> /// 添加反馈意见 /// </summary> /// <param name="model"> 反馈意见</param> /// <returns></returns> public Model.Enum.HandleResult AddFeedback(Model.AMS_FeedbackModel model) { try { if (dal.AddFeedback(model) > 0) { return(Model.Enum.HandleResult.Successed); } else { return(Model.Enum.HandleResult.Failed); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 插入反馈意见 /// </summary> /// <param name="cardNo">学号</param> /// <param name="remark">反馈意见</param> /// <param name="loginId"></param> /// <returns></returns> public int AddFeedback(Model.AMS_FeedbackModel model) { string sql = "INSERT INTO [dbo].[AMS_Feedback] ([CardNo],[SchoolId],[Remark],[SubmitTime]) VALUES (@cardNo,@schoolId,@remark,GETDATE())"; SqlParameter[] parameters = { new SqlParameter("@cardNo", SqlDbType.NVarChar, 100), new SqlParameter("@remark", SqlDbType.NVarChar, 800), new SqlParameter("@schoolId", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.CardNo; parameters[1].Value = model.Remark; parameters[2].Value = model.SchoolId; object obj = DbHelperSQL.ExecuteSql(sql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }