/// <summary>
/// 根据用户组ID得到组信息
/// </summary>
/// <param name="gid"></param>
/// <returns></returns>
public SysAdminUserGroupModel GetUserGroupInfoByID(int gid)
{
SysAdminUserGroupModel model = null;
string sqltxt = @"SELECT ID ,
GroupName ,
GroupAlt ,
GroupStatus ,
Addtime
FROM dbo.SysAdminUserGroup WITH(NOLOCK)
WHERE ID=@id";
SqlParameter[] paramter = { new SqlParameter("@id", gid) };
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
model = new SysAdminUserGroupModel();
model.ID = int.Parse(dt.Rows[0]["ID"].ToString());
model.GroupName = dt.Rows[0]["GroupName"].ToString();
model.GroupStatus = int.Parse(dt.Rows[0]["GroupStatus"].ToString());
model.GroupAlt = dt.Rows[0]["GroupAlt"].ToString();
model.Addtime = DateTime.Parse(dt.Rows[0]["Addtime"].ToString());
}
return(model);
}
public ActionResult Auadmingroup(SysAdminUserGroupModel AdminGroup)
{
if (AdminGroup != null)
{
int rowcount = mbll.AddAndUpdateAdminGroup(AdminGroup);
}
return(RedirectToAction("SysAdminGroup", "SysSettings", new { area = "AdminArea" }));
}
/// <summary>
/// 得到所有的用户组
/// </summary>
/// <returns></returns>
public List <SysAdminUserGroupModel> GetAllAdminGroup()
{
List <SysAdminUserGroupModel> list = new List <SysAdminUserGroupModel>();
string sqltxt = @"SELECT ID ,
GroupName ,
GroupAlt ,
GroupStatus ,
Addtime
FROM dbo.SysAdminUserGroup";
DataTable dt = helper.Query(sqltxt).Tables[0];
foreach (DataRow item in dt.Rows)
{
SysAdminUserGroupModel model = new SysAdminUserGroupModel();
model.Addtime = DateTime.Parse(item["Addtime"].ToString());
model.GroupAlt = item["GroupAlt"].ToString();
model.GroupName = item["GroupName"].ToString();
model.GroupStatus = int.Parse(item["GroupStatus"].ToString());
model.ID = int.Parse(item["ID"].ToString());
list.Add(model);
}
return(list);
}
/// <summary>
/// 添加和修改系统用户组
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddAndUpdateAdminGroup(SysAdminUserGroupModel model)
{
int rowcount = 0;
string sqltxt = "";
if (model.Type == 0)
{
sqltxt = @"INSERT INTO dbo.SysAdminUserGroup
( GroupName ,
GroupAlt ,
GroupStatus ,
Addtime
)
VALUES ( @GroupName,
@GroupAlt,
@GroupStatus,
GETDATE()
)";
}
else
{
sqltxt = @"UPDATE dbo.SysAdminUserGroup
SET GroupAlt = @GroupAlt ,
GroupName = @GroupName ,
GroupStatus = @GroupStatus
WHERE ID = @ID";
}
SqlParameter[] paramter =
{
new SqlParameter("@GroupName", model.GroupName),
new SqlParameter("@GroupAlt", model.GroupAlt),
new SqlParameter("@GroupStatus", model.GroupStatus),
new SqlParameter("@ID", model.ID)
};
rowcount = helper.ExecuteSql(sqltxt, paramter);
return(rowcount);
}
/// <summary>
/// 添加和修改用户组
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddAndUpdateAdminGroup(SysAdminUserGroupModel model)
{
return(dal.AddAndUpdateAdminGroup(model));
}
