/// <summary>
/// 更新快捷回复跟据 AccountId
/// </summary>
/// <param name="qr"></param>
public void UpdateQuickResponseById(QuickResponse model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update LiveChat_QuickResponse set ");
strSql.Append("DomainName=@DomainName,");
strSql.Append("AccountId=@AccountId,");
strSql.Append("OperatorId=@OperatorId,");
strSql.Append("Submenu=@Submenu,");
strSql.Append("node=@node");
strSql.Append(" where QuickId=@QuickId ");
SqlParameter[] parameters = {
new SqlParameter("@QuickId", SqlDbType.Int,4),
new SqlParameter("@DomainName", SqlDbType.VarChar,50),
new SqlParameter("@AccountId", SqlDbType.VarChar,50),
new SqlParameter("@OperatorId", SqlDbType.VarChar,50),
new SqlParameter("@Submenu", SqlDbType.VarChar,50),
new SqlParameter("@node", SqlDbType.Text)};
parameters[0].Value = model.QuickId;
parameters[1].Value = model.DomainName;
parameters[2].Value = model.AccountId;
parameters[3].Value = model.OperatorId;
parameters[4].Value = model.Submenu;
parameters[5].Value = model.Node;
DBHelper.ExecuteCommand(strSql.ToString(), parameters);
}
/// <summary>
/// 添天节点
/// </summary>
/// <param name="model"></param>
public void NewQuickResponse(QuickResponse model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into LiveChat_QuickResponse(");
strSql.Append("DomainName,AccountId,OperatorId,Submenu,node)");
strSql.Append(" values (");
strSql.Append("@DomainName,@AccountId,@OperatorId,@Submenu,@node)");
SqlParameter[] parameters = {
new SqlParameter("@DomainName", SqlDbType.VarChar,50),
new SqlParameter("@AccountId", SqlDbType.VarChar,50),
new SqlParameter("@OperatorId", SqlDbType.VarChar,50),
new SqlParameter("@Submenu", SqlDbType.VarChar,50),
new SqlParameter("@node", SqlDbType.Text)};
parameters[0].Value = model.DomainName;
parameters[1].Value = model.AccountId;
parameters[2].Value = model.OperatorId;
parameters[3].Value = model.Submenu;
parameters[4].Value = model.Node;
DBHelper.ExecuteCommand(strSql.ToString(), parameters);
}
/// <summary>
/// 跟据域名更新快捷回复
/// </summary>
/// <param name="operatorId"></param>
/// <param name="response"></param>
public static void SaveQuickResponseByDomainName(string operatorId, string domainName, List<QuickResponseCategory> response)
{
string accountId = OperatorService.GetOperatorById(operatorId).AccountId;
DBProvider.DeleteQuickResponseByDomainName(domainName);
foreach (var item in response)
{
QuickResponse qr = new QuickResponse();
qr.DomainName = domainName;
qr.AccountId = accountId;
qr.Submenu = item.Name;
qr.OperatorId = operatorId;
string node = string.Empty;
foreach (var n in item.Responses)
{
node += n.ToString() + "|";
}
if (node.Length > 0 && node[node.Length - 1] == '|')
{
node = node.Substring(0, node.Length - 1);
}
qr.Node = node;
DBProvider.NewQuickResponse(qr);
}
}
