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