/// <summary> /// 更新一条留言回复 /// </summary> /// <returns></returns> public bool UpdateReply(int companyID, EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel CustomerMessageReplyModel) { if (CustomerMessageReplyModel == null) { return(false); } if (dal.UpdateReply(companyID, CustomerMessageReplyModel)) { #region LGWR //EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); //logInfo.CompanyId = 0; //logInfo.DepatId = 0; //logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; //logInfo.EventIp = string.Empty; //logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.个人中心_留言板.ToString() + "在留言板更新了一条留言回复,回复人:" + CustomerMessageReplyModel.ReplyPersonName; //logInfo.EventTime = DateTime.Now; //logInfo.EventTitle = "更新留言回复"; //logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.个人中心_留言板; //logInfo.OperatorId = 0; //this.Logwr(logInfo); #endregion return(true); } return(false); }
protected void btnSave_Click(object sender, EventArgs e) { int id = Utils.GetInt(Utils.GetQueryStringValue("id")); EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel model = bll.GetReplyByMessageId(SiteUserInfo.CompanyID, id, false); if (model != null) { bool result = false; model.MessageId = id; model.ReplyPersonId = SiteUserInfo.ID; model.ReplyContent = this.txtReplyMsg.Text; model.ReplyPersonName = this.txtReplyMan.Text.Trim(); model.ReplyTime = Utils.GetDateTime(this.txtReplyDate.Text); if (model.MessageInfo.ReplyState == EyouSoft.Model.EnumType.CompanyStructure.ReplyState.已回复) { result = bll.UpdateReply(SiteUserInfo.CompanyID, model); } else { result = bll.AddReply(SiteUserInfo.CompanyID, model); } if (result) { EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('回复成功!');parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.window.location.href='/UserCenter/Message/MessageBoard.aspx';"); } else { EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('回复失败!');parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.window.location.href='/UserCenter/Message/MessageBoard.aspx';"); } } }
/// <summary> /// 页面初始化方法 /// </summary> /// <param name="id">记录ID</param> protected void DataInit(int id) { //声明留言操作对象 EyouSoft.BLL.CompanyStructure.CustomerMessageReply bll = new EyouSoft.BLL.CompanyStructure.CustomerMessageReply(); //声明回复信息对象 EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel model = bll.GetReplyByMessageId(SiteUserInfo.TourCompany.TourCompanyId, id, true); if (model != null && model.MessageInfo != null) { //标题 this.lblTitle.Text = model.MessageInfo.MessageTitle; //留言时间 this.lblMsgDate.Text = model.MessageInfo.MessageTime == null ? "" : Convert.ToDateTime(model.MessageInfo.MessageTime).ToString("yyyy-MM-dd"); //留言人名 this.lblMsgMan.Text = model.MessageInfo.MessagePersonName; //留言内容 this.lblMsg.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.MessageInfo.MessageContent); //留言回复状态 this.lblState.Text = model.MessageInfo.ReplyState.ToString(); //回复内容 this.lblReplyMsg.Text = EyouSoft.Common.Function.StringValidate.TextToHtml(model.ReplyContent); //回复人名 this.lblReplyMan.Text = model.ReplyPersonName; //回复时间 this.lblReplyDate.Text = model.ReplyTime == null ? "" : Convert.ToDateTime(model.ReplyTime).ToString("yyyy-MM-dd"); } }
/// <summary> /// 根据公司编号与留言编号获得回复内容,组团端传组团公司编号 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="messageID">留言编号</param> /// <param name="isZhuTuan">True:组团端,False:专线端</param> /// <returns></returns> public EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel GetReplyByMessageId(int companyId, int messageID, bool isZhuTuan) { EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel item = null; StringBuilder SQL = new StringBuilder(); //if (isZhuTuan) //{ // SQL.AppendFormat("if Exists(SELECT * FROM tbl_Message where MessageCompanyId={0} and MessageID={1})", companyId, messageID); //} //else //{ // SQL.AppendFormat("if Exists(SELECT * FROM tbl_Message where CompanyId={0} and MessageID={1})", companyId, messageID); //} //SQL.Append("SELECT tbl_MessageReply.*,(select ContactName from tbl_CompanyUser where Id=tbl_MessageReply.ReplyPersonId) as ReplyPersonName"); SQL.Append("SELECT tbl_MessageReply.*"); //SQL.AppendFormat(",(select MessageTitle as MessageTitle,ReplyState as ReplyState,MessageContent as MessageContent,MessageTime as MessageTime,(select contactname from dbo.tbl_CompanyUser where id =(select MessagePersonId from dbo.tbl_Message where MessageId={0})) as MessagePersonName from dbo.tbl_Message FOR XML RAW,ROOT('ROOT')) as MessageInfo ", messageID); SQL.AppendFormat(" FROM tbl_MessageReply WHERE MessageId={0}", messageID); if (isZhuTuan) { SQL.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_Message where MessageCompanyId={0} and MessageID={1}) ", companyId, messageID); } else { SQL.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_Message where CompanyId={0} and MessageID={1}) ", companyId, messageID); } DbCommand dc = this.SystemStore.GetSqlStringCommand(SQL.ToString()); using (IDataReader rdr = DbHelper.ExecuteReader(dc, this.DB)) { while (rdr.Read()) { item = new EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel() { MessageId = rdr.IsDBNull(rdr.GetOrdinal("MessageId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("MessageId")), ReplyId = rdr.IsDBNull(rdr.GetOrdinal("ReplyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ReplyId")), ReplyContent = rdr["ReplyContent"].ToString(), ReplyPersonId = rdr.IsDBNull(rdr.GetOrdinal("ReplyPersonId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ReplyPersonId")), ReplyPersonName = rdr["ReplyPersonName"].ToString(), ReplyTime = rdr.IsDBNull(rdr.GetOrdinal("ReplyTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("ReplyTime")), MessageInfo = GetMessageById(messageID) }; //if (!rdr.IsDBNull(rdr.GetOrdinal("MessageInfo"))) //{ // XMLConvert(item, rdr["MessageInfo"].ToString()); //} } if (item == null) { item = new EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel() { MessageInfo = GetMessageById(messageID) }; } return(item); } }
/// <summary> /// XML转换成留言实体 /// </summary> /// <param name="model"></param> private void XMLConvert(EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel model1, string MessageInfo) { System.Xml.Linq.XElement root = System.Xml.Linq.XElement.Parse(MessageInfo); var xRow = root.Element("row"); EyouSoft.Model.CompanyStructure.CustomerMessageModel Model = new EyouSoft.Model.CompanyStructure.CustomerMessageModel(); if (xRow != null) { Model.MessageTitle = EyouSoft.Toolkit.Utils.GetXAttributeValue(xRow, "MessageTitle"); Model.MessageTime = DateTime.Parse(EyouSoft.Toolkit.Utils.GetXAttributeValue(xRow, "MessageTime")); Model.MessageContent = EyouSoft.Toolkit.Utils.GetXAttributeValue(xRow, "MessageContent"); Model.MessagePersonName = EyouSoft.Toolkit.Utils.GetXAttributeValue(xRow, "MessagePersonName"); Model.ReplyState = (EyouSoft.Model.EnumType.CompanyStructure.ReplyState) int.Parse(EyouSoft.Toolkit.Utils.GetXAttributeValue(xRow, "ReplyState")); model1.MessageInfo = Model; } }
/// <summary> /// 添加一条留言回复 /// </summary> /// <returns></returns> public bool AddReply(int companyID, EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel CustomerMessageReplyModel) { DbCommand dc = this.DB.GetStoredProcCommand("proc_MessageReply_Add"); this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, companyID); this.DB.AddInParameter(dc, "MessageId", DbType.Int32, CustomerMessageReplyModel.MessageId); this.DB.AddInParameter(dc, "ReplyPersonId", DbType.Int32, CustomerMessageReplyModel.ReplyPersonId); this.DB.AddInParameter(dc, "ReplyContent", DbType.String, CustomerMessageReplyModel.ReplyContent); this.DB.AddInParameter(dc, "ReplyState", DbType.Byte, (int)EyouSoft.Model.EnumType.CompanyStructure.ReplyState.已回复); this.DB.AddInParameter(dc, "ReplyPersonName", DbType.String, CustomerMessageReplyModel.ReplyPersonName); this.DB.AddInParameter(dc, "ReplyTime", DbType.DateTime, CustomerMessageReplyModel.ReplyTime); this.DB.AddOutParameter(dc, "Result", DbType.Int32, 4); DbHelper.RunProcedure(dc, DB); object Result = this.DB.GetParameterValue(dc, "Result"); return(int.Parse(Result.ToString()) > 0 ? true : false); }
/// <summary> /// 页面初始化 /// </summary> /// <param name="id">记录ID</param> private void DataInit(int id) { EyouSoft.Model.CompanyStructure.CustomerMessageReplyModel model = bll.GetReplyByMessageId(SiteUserInfo.CompanyID, id, false); if (model != null) { this.lblTitle.Text = model.MessageInfo.MessageTitle; this.lblMsgDate.Text = model.MessageInfo.MessageTime == null ? "" : Convert.ToDateTime(model.MessageInfo.MessageTime).ToString("yyyy-MM-dd"); this.lblMsgMan.Text = model.MessageInfo.MessagePersonName; this.lblMsg.Text = model.MessageInfo.MessageContent; this.lblState.Text = model.MessageInfo.ReplyState.ToString(); //回复内容 this.txtReplyMsg.Text = model.ReplyContent; //回复人 this.txtReplyMan.Text = model.ReplyPersonName == null ? "": model.ReplyPersonName; //回复时间 this.txtReplyDate.Text = model.ReplyTime == null ? "" : Convert.ToDateTime(model.ReplyTime).ToString("yyyy-MM-dd"); } }