/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_Feedback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_Feedback("); strSql.Append("CardNo,SchoolId,Remark,SubmitTime)"); strSql.Append(" values ("); strSql.Append("@CardNo,@SchoolId,@Remark,@SubmitTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CardNo", SqlDbType.NVarChar, 100), new SqlParameter("@SchoolId", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 800), new SqlParameter("@SubmitTime", SqlDbType.DateTime) }; parameters[0].Value = model.CardNo; parameters[1].Value = model.SchoolId; parameters[2].Value = model.Remark; parameters[3].Value = model.SubmitTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_Feedback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_Feedback set "); strSql.Append("CardNo=@CardNo,"); strSql.Append("SchoolId=@SchoolId,"); strSql.Append("Remark=@Remark,"); strSql.Append("SubmitTime=@SubmitTime"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@CardNo", SqlDbType.NVarChar, 100), new SqlParameter("@SchoolId", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 800), new SqlParameter("@SubmitTime", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.CardNo; parameters[1].Value = model.SchoolId; parameters[2].Value = model.Remark; parameters[3].Value = model.SubmitTime; parameters[4].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public static AMS.Model.Enum.HandleResult Add_Feedback(AMS.Model.AMS_Feedback model) { AMS.IBllService.IAdvertManageBllService bllService = AMS.ServiceConnectChannel.AdvertManageBllServiceChannel.CreateServiceChannel(); bool error = false; try { return(bllService.AddFeedback(model)); } catch (Exception ex) { error = true; SeatManage.SeatManageComm.WriteLog.Write(string.Format("根据学校编号获取设备列表遇到错误,异常来自:{0};信息:{1}", ex.Source, ex.Message)); throw ex; } finally { ICommunicationObject ICommObjectService = bllService as ICommunicationObject; try { if (ICommObjectService.State == CommunicationState.Faulted) { ICommObjectService.Abort(); } else { ICommObjectService.Close(); } } catch { ICommObjectService.Abort(); } } }
public AMS.Model.Enum.HandleResult AddFeedback(AMS.Model.AMS_Feedback model) { if (feedbackDal.Add(model) > 0) { return(Model.Enum.HandleResult.Successed); } else { return(Model.Enum.HandleResult.Failed); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_Feedback GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,CardNo,SchoolId,Remark,SubmitTime from AMS_Feedback "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; AMS.Model.AMS_Feedback model = new AMS.Model.AMS_Feedback(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["CardNo"] != null && ds.Tables[0].Rows[0]["CardNo"].ToString() != "") { model.CardNo = ds.Tables[0].Rows[0]["CardNo"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolId"] != null && ds.Tables[0].Rows[0]["SchoolId"].ToString() != "") { model.SchoolId = ds.Tables[0].Rows[0]["SchoolId"].ToString(); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } if (ds.Tables[0].Rows[0]["SubmitTime"] != null && ds.Tables[0].Rows[0]["SubmitTime"].ToString() != "") { model.SubmitTime = DateTime.Parse(ds.Tables[0].Rows[0]["SubmitTime"].ToString()); } return(model); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { if (this.LoginUserInfo == null || this.UserSchoolInfo == null) { Response.Redirect("../Login.aspx"); return; } string cmd = Request.Form["subCmd"]; switch (cmd) { case "LoginOut": Session.Clear(); Response.Cookies["userInfo"].Expires = DateTime.Now.AddDays(-1); SeatManage.SeatManageComm.CookiesManager.RefreshNum = 0; Response.Redirect("../Login.aspx"); break; case "addFeedback": string remark = txtFeedback.Value.Trim(); IFeedbackBll feedbackBll = new PocketBespeak_Feedback(); string cardNo = this.LoginUserInfo.CardNo; string schoolId = this.UserSchoolInfo.Id.ToString(); AMS.Model.AMS_Feedback model = new AMS.Model.AMS_Feedback(); model.CardNo = cardNo; model.Remark = remark; model.SchoolId = schoolId; AMS.Model.Enum.HandleResult result = feedbackBll.AddFeedback(model); if (result == AMS.Model.Enum.HandleResult.Successed) { spanWarmInfo.Visible = true; spanWarmInfo.InnerText = "提交成功,感谢您的建议,我们会不断改进!"; } else { spanWarmInfo.Visible = true; spanWarmInfo.InnerText = "提交失败,当前网络可能不可用,请稍后再试!"; } break; } }
/// <summary> /// 反馈信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public AMS.Model.Enum.HandleResult AddFeedback(AMS.Model.AMS_Feedback model) { return(AMS.ServiceProxy.AMS_Feedback.Add_Feedback(model)); }