public bool IsAdmin(string Name, string Vhost, AdminFlag Flag)
{
var db = SchumixBase.DManager.QueryFirstRow("SELECT Vhost, Flag FROM admins WHERE Name = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), servername);
if (!db.IsNull())
{
string vhost = db["Vhost"].ToString();
if (Vhost != vhost)
{
return(false);
}
int flag = db["Flag"].ToInt32();
if ((flag == 1 && Flag == AdminFlag.HalfOperator) ||
(flag == 2 && Flag == AdminFlag.HalfOperator) ||
(flag == 2 && Flag == AdminFlag.Operator))
{
return(true);
}
return(Flag == (AdminFlag)flag);
}
return(false);
}
//=============================================================
/// <summary>
/// 查询具体的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public void GetView()
{
var id = PageRequest.GetInt("FlagId", 0);
var dt = new AdminFlag().GetTableModel(id);
var data = MyDBUtils.DataTable2ArrayList(dt);
var user = data.Count > 0 ? (Hashtable)data[0] : null;
var json = PluSoft.Utils.JSON.Encode(user);
Response.Write(json);
}
public bool IsAdmin(string Name, AdminFlag Flag)
{
var db = SchumixBase.DManager.QueryFirstRow("SELECT Flag FROM admins WHERE Name = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), servername);
if (!db.IsNull())
{
int flag = db["Flag"].ToInt32();
return(Flag == (AdminFlag)flag);
}
return(false);
}
/// <summary>
/// 更新信息
/// </summary>
public void SaveData()
{
var json = Request["data"];
var rows = (ArrayList)PluSoft.Utils.JSON.Decode(json);
var bllAdminFlag = new AdminFlag();
Sys.Model.AdminFlag model;
foreach (Hashtable row in rows)
{
var id = row["ID"] != null ? row["ID"].ToString() : "";
//根据记录状态，进行不同的增加、删除、修改操作
var state = row["_state"] != null ? row["_state"].ToString() : "";
if (state == "added" || id == "") //新增：id为空，或_state为added
{
model = new Sys.Model.AdminFlag();
model.AppUrl = row["AppUrl"] == null ? "" : row["AppUrl"].ToString();
model.CreateTime = DateTime.Now;
model.Flag = row["Flag"] == null ? "" : row["Flag"].ToString();
model.FlagAction = row["FlagAction"] == null ? "" : row["FlagAction"].ToString();
model.FlagGroup = Utils.StrToInt(row["FlagGroup"], 0);
model.FlagName = row["FlagName"] == null ? "" : row["FlagName"].ToString();
model.FlagType = Utils.StrToInt(row["FlagType"], 0);
model.HaveChildNav = Utils.StrToInt(row["HaveChildNav"], 0) == 1 ? true : false;
model.Icon = "";
model.IsNav = Utils.StrToInt(row["IsNav"], 0);
model.IsOpen = Utils.StrToInt(row["IsOpen"], 0) == 1 ? true : false;
model.OrderID = bllAdminFlag.GetMaxId();
model.ParentID = Utils.StrToInt(row["ParentID"], 0);
bllAdminFlag.Add(model);
}
else if (state == "modified" || state == "") //更新：_state为空或modified
{
model = bllAdminFlag.GetModel(Utils.StrToInt(row["ID"], 0));
if (model != null)
{
model.AppUrl = row["AppUrl"] == null ? "" : row["AppUrl"].ToString();
model.Flag = row["Flag"] == null ? "" : row["Flag"].ToString();
model.FlagAction = row["FlagAction"] == null ? "" : row["FlagAction"].ToString();
model.FlagGroup = Utils.StrToInt(row["FlagGroup"], 0);
model.FlagName = row["FlagName"] == null ? "" : row["FlagName"].ToString();
model.FlagType = Utils.StrToInt(row["FlagType"], 0);
model.HaveChildNav = Utils.StrToInt(row["HaveChildNav"], 0) == 1 ? true : false;
model.Icon = "";
model.IsNav = Utils.StrToInt(row["IsNav"], 0);
model.IsOpen = Utils.StrToInt(row["IsOpen"], 0) == 1 ? true : false;
model.OrderID = bllAdminFlag.GetMaxId();
model.ParentID = Utils.StrToInt(row["ParentID"], 0);
bllAdminFlag.Update(model);
}
}
}
}
/// <summary>
/// 查询
/// </summary>
public void SearchDatat()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " OrderID";
}
const string strWhere = "IsNav=1";
var dt = new AdminFlag().GetTable(-1, -1, strWhere, order);
var tempDt = dt.Clone();
foreach (DataRow model in dt.Rows)
{
if (ManageHelper.CheckAdminHavePower(model["Flag"].ToString()))
{
tempDt.Rows.Add(model.ItemArray);
}
}
var dataAll = MyDBUtils.DataTable2ArrayList(tempDt);
var result = new Hashtable();
result["data"] = dataAll;
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
}
public void DelFlag()
{
var flagId = PageRequest.GetInt("FlagId", 0);
if (flagId > 0)
{
var tem = new AdminFlag().Delete(flagId);
if (tem <= 0)
{
Response.Write("");
}
else
{
Response.Write(tem);
}
}
}
//=============================================================
/// <summary>
/// 更新信息
/// </summary>
public void SaveData()
{
var json = Request["data"];
var rows = (ArrayList)PluSoft.Utils.JSON.Decode(json);
var bllAdminFlag = new AdminFlag();
Sys.Model.Services model;
foreach (Hashtable row in rows)
{
var id = row["ID"] != null ? row["ID"].ToString() : "";
//根据记录状态，进行不同的增加、删除、修改操作
var state = row["_state"] != null ? row["_state"].ToString() : "";
if (state == "added" || id == "") //新增：id为空，或_state为added
{
model = new Sys.Model.Services
{
linkAddress = row["linkAddress"] == null ? "" : row["linkAddress"].ToString(),
OrderId = Utils.StrToInt(row["OrderId"], 0),
Name = row["Name"] == null ? "" : row["Name"].ToString(),
Picpath = row["Picpath"] == null ? "" : row["Picpath"].ToString()
};
BllServices.Add(model);
}
else if (state == "modified" || state == "") //更新：_state为空或modified
{
model = BllServices.GetModel(Utils.StrToInt(row["ID"], 0));
if (model != null)
{
model.linkAddress = row["linkAddress"] == null ? "" : row["linkAddress"].ToString();
model.OrderId = Utils.StrToInt(row["OrderId"], 0);
model.Name = row["Name"] == null ? "" : row["Name"].ToString();
model.Picpath = row["Picpath"] == null ? "" : row["Picpath"].ToString();
BllServices.Update(model);
}
}
}
}
public bool IsAdmin(string Name, AdminFlag Flag)
{
var db = SchumixBase.DManager.QueryFirstRow("SELECT Flag FROM admins WHERE Name = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), servername);
if(!db.IsNull())
{
int flag = db["Flag"].ToInt32();
return Flag == (AdminFlag)flag;
}
return false;
}
public bool IsWarningAdmin(string Name, string Vhost, AdminFlag Flag)
{
return IsAdmin(Name) && !IsAdmin(Name, Vhost) && IsAdminLevel(Name, Flag);
}
public bool IsAdmin(string Name, string Vhost, AdminFlag Flag)
{
var db = SchumixBase.DManager.QueryFirstRow("SELECT Vhost, Flag FROM admins WHERE Name = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), servername);
if(!db.IsNull())
{
string vhost = db["Vhost"].ToString();
if(Vhost != vhost)
return false;
int flag = db["Flag"].ToInt32();
if((flag == 1 && Flag == AdminFlag.HalfOperator) ||
(flag == 2 && Flag == AdminFlag.HalfOperator) ||
(flag == 2 && Flag == AdminFlag.Operator))
return true;
return Flag == (AdminFlag)flag;
}
return false;
}
