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;
}
