/// <summary>
/// 添加管理员组
/// </summary>
/// <param name="Info"></param>
public void AdminGroupInsert(mAdminGroup Info)
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@Title", Info.Title),
new SqlParameter("@ParentId", Info.ParentId),
new SqlParameter("@Note", Info.Note),
new SqlParameter("@GroupSetting", Info.GroupSetting),
new SqlParameter("@OtherSetting", Info.OtherSetting)
};
SQLHelper.ExecuteNonQuery("AdminGroupInsert", par);
}
/// <summary>
/// 修改管理员组
/// </summary>
/// <param name="Info"></param>
public int AdminGroupUpdate(mAdminGroup Info)
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@Id", Info.Id),
new SqlParameter("@Title", Info.Title),
new SqlParameter("@ParentId", Info.ParentId),
new SqlParameter("@Note", Info.Note),
new SqlParameter("@GroupSetting", Info.GroupSetting),
new SqlParameter("@OtherSetting", Info.OtherSetting)
};
return(StringDeal.ToInt(SQLHelper.ExecuteScalar("AdminGroupEdit", par)));
}
/// <summary>
/// 根据ID读取单个管理员组信息
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public IList <mAdminGroup> AdminGroupReader(mAdminGroup Info)
{
IList <mAdminGroup> list = new List <mAdminGroup>();
using (SqlDataReader dr = SQLHelper.ExecuteReader("AdminGroupRead", Info.Id))
{
if (dr.Read())
{
mAdminGroup mAG = new mAdminGroup();
mAG.Title = dr[0].ToString();
mAG.ParentId = StringDeal.ToInt(dr[1]);
mAG.Note = dr[2].ToString();
mAG.GroupSetting = dr[3].ToString();
mAG.OtherSetting = dr[4].ToString();
list.Add(mAG);
}
}
return(list);
}
public void AdminGroupLock(mAdminGroup Info)
{
dal.AdminGroupLock(Info);
}
public DataSet AdminGroupList(mAdminGroup Info)
{
return(dal.AdminGroupList(Info));
}
public IList <mAdminGroup> AdminGroupReader(mAdminGroup Info)
{
return(dal.AdminGroupReader(Info));
}
public void AdminGroupDel(mAdminGroup Info)
{
dal.AdminGroupDel(Info);
}
public int AdminGroupUpdate(mAdminGroup Info)
{
return(dal.AdminGroupUpdate(Info));
}
public void AdminGroupInsert(mAdminGroup Info)
{
dal.AdminGroupInsert(Info);
}
/// <summary>
/// 根据父级ID获取管理组列表
/// </summary>
/// <param name="ParentId">-1为所有，大于-1为父ID号</param>
/// <returns></returns>
public DataSet AdminGroupList(mAdminGroup Info)
{
DataSet ds = SQLHelper.ExecuteDataset("AdminGroupList", Info.ParentId);
return(ds);
}
/// <summary>
/// 删除管理员组
/// </summary>
/// <param name="Info"></param>
public void AdminGroupDel(mAdminGroup Info)
{
SQLHelper.ExecuteNonQuery("AdminGroupDel", Info.Id);
}
