/// <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));
}
}
