public static bool AddAccount(Account account,string NickName, string loginName, string loginPwd) { int i = 0; int di = 0; int oi = 0; i = SqlAccountProvider.Default.AddAccount(account); if (i != 0) { //添加默认部门 Department dt = new Department(); dt.Account = account; dt.DepartmentId = Guid.NewGuid().ToString(); dt.DepartmentName = "默认部门"; dt.IsDefault = true; dt.AddDate = DateTime.Now.ToString(); di=new SqlDepartmentProvider().AddDepartment(dt); if (di!=0) { Operator op = new Operator(); op.Account = account; op.LoginName = loginName; op.Password = loginPwd; op.IsAdmin = true; op.NickName = NickName; op.Department = dt; op.Email = account.Email; op.AVChatStatus = OperatorStatus.Offline.ToString(); op.Status = OperatorStatus.Offline; oi=new SqlOperatorProvider().NewOperator(op); } WebSite wst = WebSiteManager.GetWebSiteByDomainName(Util.GetDomainName(account.Url)); if (wst == null) { wst = new WebSite(); wst.DomainName =Util.GetDomainName(account.Url); wst.ChatStyle = "0"; wst.IcoLocation = "0"; wst.IconStyle = "0"; wst.InviteStyle = "0"; wst.RegisterId = account.AccountId; LiveSupport.BLL.WebSiteManager.NewWebSite(wst); } if (i != 0 && di != 0 && oi != 0) { return true; } else return false; } else return false; }
public List <Operator> GetOperatorListBySql(string sql) { List <Operator> operators = new List <Operator>(); using (SqlDataReader r = DBHelper.GetReader(sql)) { while (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); operators.Add(op); } return(operators); } }
public Operator GetOperatorBySql(string sql) { Operator operators = new Operator(); using (SqlDataReader r = DBHelper.GetReader(sql)) { if (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); return(op); } else { return(null); } } }
public Operator GetOperatorBySql(string sql) { Operator operators = new Operator(); using (SqlDataReader r = DBHelper.GetReader(sql)) { if (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); return op; } else { return null; } } }
public List<Operator> GetOperatorListBySql(string sql) { List<Operator> operators = new List<Operator>(); using (SqlDataReader r = DBHelper.GetReader(sql)) { while (r.Read()) { Operator op = new Operator(r); SqlAccountProvider ap = new SqlAccountProvider(); SqlDepartmentProvider dp = new SqlDepartmentProvider(); op.Department = dp.GetDepartmentById(r["DepartmentId"].ToString()); op.Account = ap.GetAccountByAccountId(r["accountId"].ToString()); operators.Add(op); } return operators; } }