protected void btnSave_Click(object sender, EventArgs e) { if (valiate()) { if (this.lblAddOrUpdate.Text != "修改") { DivideGroupView view = new DivideGroupView(); SaveInfo(view); try { OnLineCustomerService.InsertDivideGroup(this.CurrentCompany.CompanyId, view, IsOEM ? PublishRoles.OEM : PublishRoles.平台, this.CurrentUser.Name); RegisterScript("alert('添加成功');window.location.href='OnLineServiceSet.aspx';", false); } catch (Exception ex) { ShowExceptionMessage(ex, "添加"); } } else { DivideGroupView view = new DivideGroupView(Guid.Parse(Request.QueryString["devideGroupId"])); SaveInfo(view); try { OnLineCustomerService.UpdateDivideGroup(view, IsOEM ? PublishRoles.OEM : PublishRoles.平台, this.CurrentUser.Name); RegisterScript("alert('修改成功');window.location.href='OnLineServiceSet.aspx';", false); } catch (Exception ex) { ShowExceptionMessage(ex, "修改"); } } } }
/// <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="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); }
protected void Page_Load(object sender, EventArgs e) { RegisterOEMSkins("form.css"); RegisterOEMSkins("page.css"); if (!IsPostBack) { string divGroupId = Request.QueryString["devideGroupId"]; if (!string.IsNullOrWhiteSpace(divGroupId)) { this.lblAddOrUpdate.Text = "修改"; DivideGroupView view = OnLineCustomerService.QueryDivideGroup(Guid.Parse(divGroupId)); Bind(view); } } }
public int UpdateDivideGroup(DivideGroupView divideGroup) { string sql = "UPDATE [dbo].[T_DivideGroupManage] SET [Name]=@Name,[Description]=@Description,[SortLevel]=@SortLevel WHERE [Id]=@Id"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Name", divideGroup.Name); if (string.IsNullOrWhiteSpace(divideGroup.Description)) { dbOperator.AddParameter("Description", DBNull.Value); } else { dbOperator.AddParameter("Description", divideGroup.Description); } dbOperator.AddParameter("SortLevel", divideGroup.SortLevel); dbOperator.AddParameter("Id", divideGroup.Id); return(dbOperator.ExecuteNonQuery(sql)); } }
public DivideGroupView QueryDivideGroup(Guid divideGroup) { DivideGroupView view = null; string sql = "SELECT [Name],[Description],[SortLevel] FROM [dbo].[T_DivideGroupManage] WHERE [Id]=@Id"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", divideGroup); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { view = new DivideGroupView(); view.Id = divideGroup; view.Name = reader.GetString(0); view.Description = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); view.SortLevel = reader.GetInt32(2); } } } return(view); }
public IEnumerable <DivideGroupView> QueryDivideGroups(Guid company) { var result = new List <DivideGroupView>(); string sql = "SELECT [Id],[Name],[Description],[SortLevel] FROM [dbo].[T_DivideGroupManage] WHERE [T_DivideGroupManage].[Company]=@Company ORDER BY [SortLevel]"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", company); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { DivideGroupView view = new DivideGroupView(); view.Id = reader.GetGuid(0); view.Name = reader.GetString(1); view.Description = reader.IsDBNull(2) ? String.Empty : reader.GetString(2); result.Add(view); } } } return(result); }
public int InsertDivideGroup(Guid company, DivideGroupView divideGroup) { string sql = "INSERT INTO [dbo].[T_DivideGroupManage]([Id],[Name],[Description],[SortLevel],[Company]) VALUES(@Id,@Name,@Description,@SortLevel,@Company)"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Id", divideGroup.Id); dbOperator.AddParameter("Name", divideGroup.Name); if (string.IsNullOrWhiteSpace(divideGroup.Description)) { dbOperator.AddParameter("Description", DBNull.Value); } else { dbOperator.AddParameter("Description", divideGroup.Description); } dbOperator.AddParameter("SortLevel", divideGroup.SortLevel); dbOperator.AddParameter("Company", company); return(dbOperator.ExecuteNonQuery(sql)); } }
private void SaveInfo(DivideGroupView view) { view.Description = this.txtDescription.InnerText; view.Name = this.txtGroupName.Text; view.SortLevel = int.Parse(this.txtGroupOrder.Text); }
private void Bind(DivideGroupView view) { this.txtGroupName.Text = view.Name; this.txtGroupOrder.Text = view.SortLevel.ToString(); this.txtDescription.InnerText = view.Description; }