/// <summary> /// 查询平台在线客服设置 /// </summary> public static OnLineCustomer Query(Guid company, PublishRoles roles) { //Guid company = QueryPlatForm(); var reposity = Factory.CreateOnLineCustomerRepository(); return(reposity.Query(company, roles)); }
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); }
/// <summary> /// 插入分组信息 /// </summary> /// <param name="online">在线服务Id</param> /// <param name="view">分组信息</param> /// <param name="operatorAccount">操作员帐号</param> public static void InsertDivideGroup(Guid online, DivideGroupView view, PublishRoles role, string operatorAccount) { var reposity = Factory.CreateOnLineCustomerRepository(); reposity.InsertDivideGroup(online, view); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string content = string.Format("在线客服Id{0},分组名称{1},分组描述{2},分组排序{3}", online, view.Name, view.Description, view.SortLevel); saveAddLog("分组信息", content, operatorRole, view.Id.ToString(), operatorAccount); }
/// <summary> /// 删除成员管理信息 /// </summary> /// <param name="member">成员管理Id</param> /// <param name="operatorAccount">操作员帐号</param> public static void DeleteMember(Guid member, PublishRoles role, string operatorAccount) { var view = OnLineCustomerService.QueryMember(member); var reposity = Factory.CreateOnLineCustomerRepository(); reposity.DeleteMember(member); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string content = string.Format("成员说明:{0},成员QQ:{1}", view.Remark, view.QQ.Join(",")); saveDeleteLog("成员管理", content, operatorRole, member.ToString(), operatorAccount); }
/// <summary> /// 删除分组信息 /// </summary> /// <param name="divideGrop">分组Id</param> /// <param name="operatorAccount">操作员帐号</param> public static void DeleteDivideGroup(Guid divideGrop, PublishRoles role, string operatorAccount) { var view = OnLineCustomerService.QueryDivideGroup(divideGrop); var reposity = Factory.CreateOnLineCustomerRepository(); reposity.DeleteDivideGroup(divideGrop); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string content = string.Format("分组名称:{0},分组描述:{1},分组排序:{2}", view.Name, view.Description, view.SortLevel); saveDeleteLog("分组信息", content, operatorRole, divideGrop.ToString(), operatorAccount); }
/// <summary> /// 更新分组信息 /// </summary> /// <param name="divideGroup">分组信息Id</param> /// <param name="view">分组信息</param> /// <param name="operatorAccount">操作员帐号</param> public static void UpdateDivideGroup(DivideGroupView view, PublishRoles role, string operatorAccount) { var oldView = OnLineCustomerService.QueryDivideGroup(view.Id); var reposity = Factory.CreateOnLineCustomerRepository(); reposity.UpdateDivideGroup(view); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string originalContent = string.Format("分组名称:{0},分组描述:{1},分组排序:{2}", oldView.Name, oldView.Description, oldView.SortLevel); string newContent = string.Format("分组名称:{0},分组描述:{1},分组排序:{2}", view.Name, view.Description, view.SortLevel); saveUpdateLog("分组信息", originalContent, newContent, operatorRole, view.Id.ToString(), operatorAccount); }
public int SaveOnLine(Guid company, PublishRoles role, OnLineCustomerView view) { string sql = "IF EXISTS(SELECT NULL FROM [dbo].[T_OnLineCustomer] WHERE [Company]=@Company) UPDATE[dbo].[T_OnLineCustomer] SET [Title]=@Title," + "[Content]=@Content,[PublishRole]=@PublishRole WHERE [Company]=@Company ELSE INSERT INTO [dbo].[T_OnLineCustomer](Title,Content,PublishRole,Company)" + " VALUES(@Title,@Content,@PublishRole,@Company)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", company); dbOperator.AddParameter("Title", view.Title); dbOperator.AddParameter("Content", view.Content); dbOperator.AddParameter("PublishRole", (int)role); return(dbOperator.ExecuteNonQuery(sql)); } }
static OperatorRole getOperatorRole(PublishRoles role) { switch (role) { case PublishRoles.OEM: return(OperatorRole.Provider); case PublishRoles.平台: return(OperatorRole.Platform); default: throw new NotSupportedException(role.ToString()); } }
/// <summary> /// 插入成员管理 /// </summary> /// <param name="divideGroup">分组信息Id</param> /// <param name="view">成员管理信息</param> /// <param name="operatorAccount">操作员帐号</param> public static void InsertMember(Guid divideGroup, MemberView view, PublishRoles role, string operatorAccount) { var model = new MemberManage(view.Id); model.Remark = view.Remark; model.QQ = view.QQ; model.SortLevel = view.SortLevel; var reposity = Factory.CreateOnLineCustomerRepository(); reposity.InsertMember(divideGroup, model); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string content = string.Format("分组Id:{0},成员说明:{1},成员QQ:{2}", divideGroup, view.Remark, view.QQ.Join(",")); saveAddLog("成员信息", content, operatorRole, view.Id.ToString(), operatorAccount); }
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); } } }
/// <summary> /// 更新成员管理信息 /// </summary> /// <param name="member">成员管理Id</param> /// <param name="view">成员管理Id</param> /// <param name="operatorAccount"></param> public static void UpdateMember(MemberView view, PublishRoles role, string operatorAccount) { var member = OnLineCustomerService.QueryMember(view.Id); var model = new MemberManage(view.Id); model.QQ = view.QQ; model.Remark = view.Remark; model.SortLevel = view.SortLevel; var reposity = Factory.CreateOnLineCustomerRepository(); reposity.UpdateMember(model); // 记录日志 OperatorRole operatorRole = getOperatorRole(role); string originalContent = string.Format("成员说明:{0},成员QQ:{1}", member.Remark, member.QQ.Join(",")); string newContent = string.Format("成员说明:{0},成员QQ:{1}", view.Remark, view.QQ.Join(",")); saveUpdateLog("成员信息", originalContent, newContent, operatorRole, view.Id.ToString(), operatorAccount); }
/// <summary> /// 保存平台发布的在线服务 /// </summary> /// <param name="view">在线服务信息</param> /// <param name="operatorAccount">操作员帐号</param> /// <param name="publishRoles">发布角色</param> public static void SavePlatForm(Guid company, OnLineCustomerView view, string operatorAccount, PublishRoles publishRoles) { var reposity = Factory.CreateOnLineCustomerRepository(); reposity.SaveOnLine(company, publishRoles, view); // 记录日志 string content = string.Format("标题:{0},内容:{1},公司Id{2},发布角色{3}", view.Title, view.Content, company, OperatorRole.Platform.GetDescription()); saveAddLog("在线客服", content, OperatorRole.Platform, company.ToString(), operatorAccount); }