/// <summary>
///
/// </summary>
/// <param name="accountId"></param>
/// <returns></returns>
public List<WebSite> GetAllWebSiteByRegisterId(string accountId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" DomainName,CompanyName,RegisterId,IconStyle,InviteStyle,ChatStyle,IcoLocation ");
strSql.Append(" FROM WebSite ");
strSql.Append(" where RegisterId='" + accountId +"'");
List<WebSite> modelList = new List<WebSite>();
using (SqlDataReader r = DBHelper.GetReader(strSql.ToString()))
{
while (r.Read())
{
WebSite model =new WebSite();
model.DomainName = r["DomainName"].ToString();
model.CompanyName = r["CompanyName"].ToString();
model.RegisterId = r["RegisterId"].ToString();
model.IconStyle = r["IconStyle"].ToString();
model.InviteStyle = r["InviteStyle"].ToString();
model.ChatStyle = r["ChatStyle"].ToString();
model.IcoLocation = r["IcoLocation"].ToString();
modelList.Add(model);
}
return modelList;
}
}
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;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebSite model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WebSite(");
strSql.Append("DomainName,CompanyName,RegisterId,IconStyle,InviteStyle,ChatStyle,IcoLocation)");
strSql.Append(" values (");
strSql.Append("@DomainName,@CompanyName,@RegisterId,@IconStyle,@InviteStyle,@ChatStyle,@IcoLocation)");
SqlParameter[] parameters = {
new SqlParameter("@DomainName", SqlDbType.VarChar,50),
new SqlParameter("@CompanyName",SqlDbType.VarChar,100),
new SqlParameter("@RegisterId", SqlDbType.VarChar,50),
new SqlParameter("@IconStyle", SqlDbType.Text),
new SqlParameter("@InviteStyle", SqlDbType.Text),
new SqlParameter("@ChatStyle", SqlDbType.Text),
new SqlParameter("@IcoLocation", SqlDbType.VarChar,50)};
parameters[0].Value = model.DomainName;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.RegisterId;
parameters[3].Value = model.IconStyle;
parameters[4].Value = model.InviteStyle;
parameters[5].Value = model.ChatStyle;
parameters[6].Value = model.IcoLocation;
return DBHelper.ExecuteCommand(strSql.ToString(), parameters);
}
public static bool UpdateNewWebSite(NewWebSite nwst)
{
WebSite website = new WebSite();
website.IconStyle = nwst.banners.State + "|" + nwst.banners.Online + "|" + nwst.banners.Offline;
website.InviteStyle = nwst.invites.State + "|" + nwst.invites.Bgimg + "|" + nwst.invites.Okimg + "|" + nwst.invites.Noimg;
website.ChatStyle = nwst.chatpage.State + "|" + nwst.chatpage.ChatPageBGImg + "|" + nwst.chatpage.ChatPageRightImg + "|" + nwst.chatpage.LeavePageTopImg;
website.DomainName = nwst.domainName;
website.CompanyName=nwst.companyName;
website.RegisterId = nwst.accountId;
website.IcoLocation = nwst.icoLocation;
return Update(website);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(WebSite model)
{
int i= Provider.Update(model);
if (i > 0)
{
return true;
}
else
return false;
}
//保存
protected void Button1_Click(object sender, EventArgs e)
{
string domainName = this.drpDomainName.SelectedValue;
if (string.IsNullOrEmpty(domainName))
{
return;
}
else
{
WebSite wst = new WebSite();
wst.DomainName = domainName;
if (RadioButton0.Checked == true) { wst.IcoLocation = "0"; }
if (RadioButton1.Checked == true) { wst.IcoLocation = "1"; }
if (RadioButton2.Checked == true) { wst.IcoLocation = "2"; }
if (RadioButton3.Checked == true) { wst.IcoLocation = "3"; }
if (RadioButton4.Checked == true) { wst.IcoLocation = "4"; }
if (RadioButton5.Checked == true) { wst.IcoLocation = "5"; }
if (RadioButton6.Checked == true) { wst.IcoLocation = "6"; }
wst.IconStyle = DropDownList1.SelectedValue;
wst.InviteStyle = DropDownList2.SelectedValue;
wst.ChatStyle = DropDownList3.SelectedValue;
if (Session["User"] != null)
{
oper = (Operator)Session["User"];
wst.RegisterId = oper.Account.AccountId;
LiveSupport.BLL.WebSiteManager.Update(wst);
Response.Redirect("DomainName.aspx");
}
else
{
return;
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(WebSite model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WebSite set ");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("RegisterId=@RegisterId,");
strSql.Append("IconStyle=@IconStyle,");
strSql.Append("InviteStyle=@InviteStyle,");
strSql.Append("ChatStyle=@ChatStyle,");
strSql.Append("IcoLocation=@IcoLocation");
strSql.Append(" where DomainName=@DomainName ");
SqlParameter[] parameters = {
new SqlParameter("@DomainName", SqlDbType.VarChar,50),
new SqlParameter("@CompanyName",SqlDbType.VarChar,100),
new SqlParameter("@RegisterId", SqlDbType.VarChar,50),
new SqlParameter("@IconStyle", SqlDbType.Text),
new SqlParameter("@InviteStyle", SqlDbType.Text),
new SqlParameter("@ChatStyle", SqlDbType.Text),
new SqlParameter("@IcoLocation", SqlDbType.VarChar,50)};
parameters[0].Value = model.DomainName;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.RegisterId;
parameters[3].Value = model.IconStyle;
parameters[4].Value = model.InviteStyle;
parameters[5].Value = model.ChatStyle;
parameters[6].Value = model.IcoLocation;
return DBHelper.ExecuteCommand(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebSite GetModel(string DomainName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DomainName,CompanyName,RegisterId,IconStyle,InviteStyle,ChatStyle,IcoLocation from WebSite ");
strSql.Append(" where DomainName=@DomainName ");
SqlParameter[] parameters = {
new SqlParameter("@DomainName", SqlDbType.VarChar,50)};
parameters[0].Value = DomainName;
WebSite model = new WebSite();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.DomainName = ds.Tables[0].Rows[0]["DomainName"].ToString();
model.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString();
model.RegisterId = ds.Tables[0].Rows[0]["RegisterId"].ToString();
model.IconStyle = ds.Tables[0].Rows[0]["IconStyle"].ToString();
model.InviteStyle = ds.Tables[0].Rows[0]["InviteStyle"].ToString();
model.ChatStyle = ds.Tables[0].Rows[0]["ChatStyle"].ToString();
model.IcoLocation = ds.Tables[0].Rows[0]["IcoLocation"].ToString();
return model;
}
else
{
return null;
}
}