private void BindDividGroup(OnLineCustomer dividGroup)
{
var dividGroupHTML = new StringBuilder();
if (dividGroup.DivideGroupManage != null)
{
foreach (var item in dividGroup.DivideGroupManage)
{
dividGroupHTML.Append("<div class='clearfix' style='background-image: url(../Images/sanjiao.png); background-repeat: no-repeat; padding: 20px 0px 0px 20px;'>");
dividGroupHTML.AppendFormat("<h2>{0}</h2>", item.Name + "(" + item.Description + ")");
var members = OnLineCustomerService.QueryMembers(item.Id);
if (members != null)
{
dividGroupHTML.Append("<ul class='box'>");
foreach (var member in members)
{
dividGroupHTML.AppendFormat("<li>{0}</li>", member.Remark);
dividGroupHTML.Append("<li>");
if (member.QQ.Any())
{
foreach (var qq in member.QQ)
{
dividGroupHTML.AppendFormat("<a href='http://wpa.qq.com/msgrd?V=1&uin={0}&Site=&Menu=yes' target='_blank'><img src='http://wpa.qq.com/pa?p=2:{0}:41' alt='点击这里给我发消息' /></a>", qq);
}
}
dividGroupHTML.Append("</li>");
}
dividGroupHTML.Append("</ul>");
}
dividGroupHTML.Append("</div>");
}
}
this.divDivideGroup.InnerHtml = dividGroupHTML.ToString();
}
public OnLineCustomer Query(Guid company, PublishRoles role)
{
OnLineCustomer view = null;
string sql = "SELECT [T_OnLineCustomer].[Title],[T_OnLineCustomer].[Content],[T_DivideGroupManage].[Id],[T_DivideGroupManage].[Name],[T_DivideGroupManage].[Description]," +
"[T_DivideGroupManage].[SortLevel] " +
"FROM [T_OnLineCustomer] LEFT JOIN [T_DivideGroupManage] ON [T_DivideGroupManage].[Company]=[T_OnLineCustomer].[Company] " +
"WHERE [T_OnLineCustomer].[Company]=@Company AND [T_OnLineCustomer].[PublishRole]=@Role ORDER BY [T_DivideGroupManage].[SortLevel]";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Company", company);
dbOperator.AddParameter("Role", (int)role);
using (var reader = dbOperator.ExecuteReader(sql)) {
var divideGroup = new List <DivideGroupManage>();
while (reader.Read())
{
view = new OnLineCustomer();
view.Title = reader.GetString(0);
view.Content = reader.GetString(1);
if (!reader.IsDBNull(2))
{
var model = new DivideGroupManage(reader.GetGuid(2));
model.Name = reader.GetString(3);
model.Description = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.SortLevel = reader.GetInt32(5);
divideGroup.Add(model);
}
}
if (divideGroup.Count > 0)
{
view.DivideGroupManage = divideGroup;
}
}
}
return(view);
}
protected void Page_Load(object sender, EventArgs e)
{
RegisterOEMSkins("core.css");
RegisterOEMSkins("from.css");
RegisterOEMSkins("page.css");
if (!IsPostBack)
{
Guid companyId = isOem()? BasePage.OEM.CompanyId : OnLineCustomerService.QueryPlatForm();
PublishRoles publishRoles = isOem() ? PublishRoles.OEM : PublishRoles.平台;
OnLineCustomer onLineCustomer = OnLineCustomerService.Query(companyId, publishRoles);
if (onLineCustomer != null)
{
this.lblTitle.Text = onLineCustomer.Title;
this.lblContent.Text = onLineCustomer.Content;
BindDividGroup(onLineCustomer);
}
}
}
