/// <summary>
/// 页面初始化方法
/// </summary>
private void DataInit(string msgTitle)
{
EyouSoft.BLL.CompanyStructure.CustomerMessageReply bll = new EyouSoft.BLL.CompanyStructure.CustomerMessageReply();
//查询model
EyouSoft.Model.CompanyStructure.CustomerMessageModel searchModel = new EyouSoft.Model.CompanyStructure.CustomerMessageModel();
searchModel.MessageTitle = msgTitle;
searchModel.CompanyId = SiteUserInfo.CompanyID;
//获得分页数据
IList <EyouSoft.Model.CompanyStructure.CustomerMessageModel> list = bll.GetMessageList(SiteUserInfo.TourCompany.TourCompanyId, pageSize, pageIndex, ref recordCount, true, searchModel);
//判断list是否有数据
if (list != null && list.Count > 0)
{
this.rptList.DataSource = list;
this.rptList.DataBind();
BindPage();
this.lblMsg.Visible = false;
}
else
{
this.ExporPageInfoSelect1.Visible = false;
this.lblMsg.Visible = true;
}
list = null;
}
/// <summary>
/// 添加一条留言
/// </summary>
/// <returns></returns>
public bool AddMessage(EyouSoft.Model.CompanyStructure.CustomerMessageModel CustomerMessageModel)
{
if (CustomerMessageModel == null)
{
return(false);
}
if (dal.AddMessage(CustomerMessageModel))
{
#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()+"新增了一条留言，留言标题：" + CustomerMessageModel.MessageTitle;
//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)
{
//留言标题
string msgTitle = this.txtTitle.Text;
//留言内容
string msgContent = this.txtMsg.Text;
//留言操作对象
EyouSoft.BLL.CompanyStructure.CustomerMessageReply bll = new EyouSoft.BLL.CompanyStructure.CustomerMessageReply();
//声明新的留言model
EyouSoft.Model.CompanyStructure.CustomerMessageModel model = new EyouSoft.Model.CompanyStructure.CustomerMessageModel();
#region 属性赋值
model.CompanyId = SiteUserInfo.CompanyID;
model.MessageCompanyId = SiteUserInfo.TourCompany.TourCompanyId;
model.MessageContent = msgContent;
model.MessageTitle = msgTitle;
model.MessageTime = DateTime.Now;
model.ReplyState = EyouSoft.Model.EnumType.CompanyStructure.ReplyState.未回复;
model.MessagePersonId = SiteUserInfo.ID;
model.MessagePersonName = SiteUserInfo.UserName;
#endregion
//数据操作
if (bll.AddMessage(model))
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('留言成功!');parent.Boxy.getIframeDialog('" + Request.QueryString["iframeid"] + "').hide();parent.window.location.href='/GroupEnd/Messages/MessageBoard.aspx'");
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "javascript:alert('留言失败!');window.location.href='/GroupEnd/Messages/AddMessage.aspx'");
}
}
/// <summary>
/// 根据留言编号获得留言
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.CustomerMessageModel GetMessageById(int Id)
{
StringBuilder SQL = new StringBuilder();
EyouSoft.Model.CompanyStructure.CustomerMessageModel item = null;
SQL.AppendFormat("select *,(select contactname from dbo.tbl_CompanyUser where id =(select MessagePersonId from dbo.tbl_Message where MessageId={0})) as MessagePersonName from dbo.tbl_Message where MessageId={0}", Id);
DbCommand dc = this.SystemStore.GetSqlStringCommand(SQL.ToString());
using (IDataReader rdr = DbHelper.ExecuteReader(dc, this.DB))
{
while (rdr.Read())
{
item = new EyouSoft.Model.CompanyStructure.CustomerMessageModel()
{
MessageId = rdr.IsDBNull(rdr.GetOrdinal("MessageId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("MessageId")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
MessageCompanyId = rdr.IsDBNull(rdr.GetOrdinal("MessageCompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("MessageCompanyId")),
MessageContent = rdr["MessageContent"].ToString(),
MessagePersonName = rdr["MessagePersonName"].ToString(),
MessagePersonId = rdr.IsDBNull(rdr.GetOrdinal("MessageId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("MessageId")),
MessageTitle = rdr["MessageTitle"].ToString(),
MessageTime = rdr.IsDBNull(rdr.GetOrdinal("MessageTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("MessageTime")),
ReplyState = (EyouSoft.Model.EnumType.CompanyStructure.ReplyState)(int) rdr.GetByte(rdr.GetOrdinal("ReplyState"))
};
}
return(item);
}
}
/// 获取留言列表
/// </summary>
/// <param name="companyId">组团登录为组团公司编号,专线登录为专线公司编号</param>
/// <param name="pageSize">每页显示的记录数</param>
/// <param name="pageIndex">返回第几页</param>
/// <param name="recordCount">返回的记录数</param>
/// <param name="isZhuTuan">True:组团端,False:专线端</param>
/// <param name="customerMessageModel">留言实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.CustomerMessageModel> GetMessageList(int companyId, int pageSize, int pageIndex, ref int recordCount, bool isZhuTuan, EyouSoft.Model.CompanyStructure.CustomerMessageModel customerMessageModel)
{
IList <EyouSoft.Model.CompanyStructure.CustomerMessageModel> items = new List <EyouSoft.Model.CompanyStructure.CustomerMessageModel>();
EyouSoft.Model.CompanyStructure.CustomerMessageModel item = null;
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_Message";
string primaryKey = "MessageId";
string orderByString = "MessageTime DESC";
StringBuilder fields = new StringBuilder();
#region 要查询的字段
//fields.Append("tbl_Message.*,(select contactname from dbo.tbl_CompanyUser where id in(select ReplyPersonId from dbo.tbl_MessageReply where MessageId=tbl_Message.MessageId)) as MessageReplyPersonName,(select contactname from dbo.tbl_CompanyUser where id =tbl_Message.MessagePersonId) as MessagePersonName");
fields.Append("tbl_Message.*,(select ReplyPersonName from dbo.tbl_MessageReply where MessageId =tbl_Message.MessageId) as ReplyPersonName,(select contactname from dbo.tbl_CompanyUser where id =tbl_Message.MessagePersonId) as MessagePersonName");
#endregion
#region 拼接查询条件
if (isZhuTuan)
{
cmdQuery.AppendFormat(" MessageCompanyId={0} ", companyId);
}
else
{
cmdQuery.AppendFormat(" CompanyId={0} ", companyId);
}
if (customerMessageModel != null)
{
if (!String.IsNullOrEmpty(customerMessageModel.MessageTitle))
{
cmdQuery.AppendFormat(" and MessageTitle like '%{0}%'", customerMessageModel.MessageTitle);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
item = new EyouSoft.Model.CompanyStructure.CustomerMessageModel()
{
MessageId = rdr.GetInt32(rdr.GetOrdinal("MessageId")),
CompanyId = rdr.IsDBNull(rdr.GetOrdinal("CompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
MessageCompanyId = rdr.IsDBNull(rdr.GetOrdinal("MessageCompanyId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("MessageCompanyId")),
MessageTitle = rdr["MessageTitle"].ToString(),
MessageContent = rdr["MessageContent"].ToString(),
MessagePersonId = rdr.IsDBNull(rdr.GetOrdinal("MessagePersonId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("MessagePersonId")),
MessageTime = rdr.IsDBNull(rdr.GetOrdinal("MessageTime")) ? System.DateTime.Now : rdr.GetDateTime(rdr.GetOrdinal("MessageTime")),
MessagePersonName = rdr["MessagePersonName"].ToString(),
MessageReplyPersonName = rdr["ReplyPersonName"].ToString(),
ReplyState = (EyouSoft.Model.EnumType.CompanyStructure.ReplyState)rdr.GetByte(rdr.GetOrdinal("ReplyState"))
};
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 添加一条留言
/// </summary>
/// <returns></returns>
public bool AddMessage(EyouSoft.Model.CompanyStructure.CustomerMessageModel CustomerMessageModel)
{
string SQL = "INSERT INTO tbl_Message(CompanyId,MessageCompanyId,MessageTitle,MessageContent,MessagePersonId,MessageTime,ReplyState) VALUES(@CompanyId,@MessageCompanyId,@MessageTitle,@MessageContent,@MessagePersonId,@MessageTime,0)";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, CustomerMessageModel.CompanyId);
this.DB.AddInParameter(dc, "MessageCompanyId", DbType.Int32, CustomerMessageModel.MessageCompanyId);
this.DB.AddInParameter(dc, "MessageTitle", DbType.String, CustomerMessageModel.MessageTitle);
this.DB.AddInParameter(dc, "MessageContent", DbType.String, CustomerMessageModel.MessageContent);
this.DB.AddInParameter(dc, "MessagePersonId", DbType.Int32, CustomerMessageModel.MessagePersonId);
this.DB.AddInParameter(dc, "MessageTime", DbType.DateTime, CustomerMessageModel.MessageTime);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
EyouSoft.Model.CompanyStructure.CustomerMessageModel cmm = e.Item.DataItem as EyouSoft.Model.CompanyStructure.CustomerMessageModel;
EyouSoft.Model.CompanyStructure.CustomerInfo cci = new EyouSoft.BLL.CompanyStructure.Customer().GetCustomerModel(cmm.MessageCompanyId);
Literal lt_groupName = e.Item.FindControl("lt_groupName") as Literal;
Literal lt_Contract = e.Item.FindControl("lt_Contract") as
Literal;
if (cci != null)
{
lt_groupName.Text = cci.Name;
lt_Contract.Text = cci.Phone;
}
}
/// <summary>
/// 更新一条留言
/// </summary>
/// <returns></returns>
public bool UpdateMessage(EyouSoft.Model.CompanyStructure.CustomerMessageModel CustomerMessageModel)
{
string SQL = "UPDATE tbl_Message SET CompanyId=@CompanyId,MessageCompanyId=@MessageCompanyId,MessageTitle=@MessageTitle,MessageContent=@MessageContent,MessagePersonId=@MessagePersonId,MessageTime=@MessageTime,ReplyState=0 WHERE MessageId=@MessageId";
DbCommand dc = this.DB.GetSqlStringCommand(SQL);
this.DB.AddInParameter(dc, "MessageId", DbType.Int32, CustomerMessageModel.MessageId);
this.DB.AddInParameter(dc, "CompanyId", DbType.Int32, CustomerMessageModel.CompanyId);
this.DB.AddInParameter(dc, "MessageCompanyId", DbType.Int32, CustomerMessageModel.MessageCompanyId);
this.DB.AddInParameter(dc, "MessageTitle", DbType.String, CustomerMessageModel.MessageTitle);
this.DB.AddInParameter(dc, "MessageContent", DbType.String, CustomerMessageModel.MessageContent);
this.DB.AddInParameter(dc, "MessagePersonId", DbType.Int32, CustomerMessageModel.MessagePersonId);
this.DB.AddInParameter(dc, "MessageTime", DbType.DateTime, CustomerMessageModel.MessageTime);
return(DbHelper.ExecuteSql(dc, this.DB) > 0 ? true : false);
}
/// <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>
/// <param name="companyId">组团登录为组团公司编号,专线登录为专线公司编号</param>
/// <param name="pageSize">每页显示的记录数</param>
/// <param name="pageIndex">返回第几页</param>
/// <param name="recordCount">返回的记录数</param>
/// <param name="isZhuTuan">True:组团端,False:专线端</param>
/// <param name="customerMessageModel">留言搜索实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.CustomerMessageModel> GetMessageList(int companyId, int pageSize, int pageIndex, ref int recordCount, bool isZhuTuan, EyouSoft.Model.CompanyStructure.CustomerMessageModel customerMessageModel)
{
return(dal.GetMessageList(companyId, pageSize, pageIndex, ref recordCount, isZhuTuan, customerMessageModel));
}