public int Update_Group(GroupModel Group)
{
return groupbll.Update_Group(Group);
}
public int Insert_Group(GroupModel Group)
{
return groupbll.Insert_Group(Group);
}
/// <summary>
/// 添加用户组
/// </summary>
/// <param name="Group">用户组对象</param>
/// <returns></returns>
public int Insert_Group(GroupModel Group)
{
return dal.Insert_Group(Group);
}
/// <summary>
/// 修改用户组
/// </summary>
/// <param name="Group">用户组实体</param>
/// <returns></returns>
public int Update_Group(GroupModel Group)
{
return dal.Update_Group(Group);
}
/// <summary>
/// 获取用户组对象
/// </summary>
/// <param name="ID">用户组编号</param>
/// <returns></returns>
public GroupModel Get_GroupModel(int ID)
{
string strWhere = "id=" + ID.ToString();
DataSet ds = Get_GroupList(strWhere);
GroupModel Group = new GroupModel();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
Group.ID = int.Parse(dt.Rows[0]["ID"].ToString());
Group.GroupNO = dt.Rows[0]["GroupNO"].ToString();
Group.GroupName = dt.Rows[0]["GroupName"].ToString();
Group.IsBlocked = bool.Parse(dt.Rows[0]["IsBlocked"].ToString());
Group.IsOpenExpirationDate = bool.Parse(dt.Rows[0]["IsOpenExpirationDate"].ToString());
Group.ExpirationDate = DateTime.Parse(dt.Rows[0]["ExpirationDate"].ToString());
Group.Reamark = dt.Rows[0]["Reamark"].ToString();
return Group;
}
else
{
return null;
}
}
public int Update_Group(GroupModel Group)
{
SqlParameter[] paras =
{
new SqlParameter("@GroupNO",SqlDbType.NVarChar,20),
new SqlParameter("@GroupName",SqlDbType.NVarChar,20),
new SqlParameter("@IsBlocked",SqlDbType.Bit),
new SqlParameter("@IsOpenExpirationDate",SqlDbType.Bit),
new SqlParameter("@ExpirationDate",SqlDbType.DateTime),
new SqlParameter("@Reamark",SqlDbType.NVarChar,50),
new SqlParameter("@ID",SqlDbType.Int)
};
paras[0].Value = Group.GroupNO;
paras[1].Value = Group.GroupName;
paras[2].Value = Group.IsBlocked;
paras[3].Value = Group.IsOpenExpirationDate;
paras[4].Value = Group.ExpirationDate;
paras[5].Value = Group.Reamark;
paras[6].Value = Group.ID;
try
{
int iReturn;
int i = DbHelperSQL.RunProcedure("Power_Update_Group", paras, out iReturn);
return iReturn;
}
catch
{
return -1;
}
}
