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