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