/// <summary>
/// 获取功能菜单
/// </summary>
/// <param name="RoleId"></param>
/// <returns></returns>
public DataTable GetMenuInfo(string RoleId)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@RoleId", RoleId)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_GetMenuInfo", Para);
return(dt);
}
/// <summary>
/// 根据ID查询人员信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable BindUserInfo(string id)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@id", id)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_BindUserInfo", Para);
return(dt);
}
/// <summary>
/// 设置/取消是否需要审核
/// </summary>
/// <param name="id"></param>
/// <param name="IsDelete"></param>
/// <returns></returns>
public DataTable WhatBooked(string index)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@index", index)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_WhatBooked", Para);
return(dt);
}
/// <summary>
/// 启用禁用账号
/// </summary>
/// <param name="id"></param>
/// <param name="IsDelete"></param>
/// <returns></returns>
public DataTable SetUserInfoIsDelete(string id, string IsDelete)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@id", id),
new SqlParameter("@IsDelete", IsDelete)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_SetUserInfoIsDelete", Para);
return(dt);
}
/// <summary>
/// 登陆验证
/// </summary>
/// <param name="LoginName"></param>
/// <param name="PassWord"></param>
/// <returns></returns>
public DataTable Login(string LoginName, string PassWord)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@PassWord", PassWord)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_GetLogin", Para);
return(dt);
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="id"></param>
/// <param name="oldpwd"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public DataTable EditPassword(string id, string oldpwd, string pwd)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@id", id),
new SqlParameter("@oldpwd", oldpwd),
new SqlParameter("@pwd", pwd)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_SetUserInfo", Para);
return(dt);
}
/// <summary>
/// 修改或新增时间段
/// </summary>
/// <param name="TimeSectionName"></param>
/// <param name="userid"></param>
/// <param name="id"></param>
/// <param name="Type">修改还是新增</param>
/// <returns></returns>
public DataTable InTimeSection(string TimeSectionName, string userid, string id, string Type)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@TimeSectionName", TimeSectionName),
new SqlParameter("@userid", userid),
new SqlParameter("@id", id),
new SqlParameter("@Type", Type)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_InTimeSection", Para);
return(dt);
}
/// <summary>
/// 修改或新增会议室
/// </summary>
/// <param name="MeetingName"></param>
/// <param name="userid"></param>
/// <param name="id"></param>
/// <param name="Type">修改还是新增</param>
/// <returns></returns>
public DataTable InMeeting(string MeetingName, string userid, string id, string Type)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@MeetingName", MeetingName),
new SqlParameter("@userid", userid),
new SqlParameter("@id", id),
new SqlParameter("@Type", Type)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_InMeeting", Para);
return(dt);
}
/// <summary>
/// 修改或删除人员信息
/// </summary>
/// <param name="Name"></param>
/// <param name="IDCard"></param>
/// <param name="Phone"></param>
/// <param name="RoleID"></param>
/// <param name="LoginName"></param>
/// <param name="id"></param>
/// <param name="Type"></param>
/// <returns></returns>
public DataTable InUserInfo(string Name, string IDCard, string Phone, string RoleID, string LoginName, string id, string Type)
{
SqlParameter[] Para = new SqlParameter[] {
new SqlParameter("@Name", Name),
new SqlParameter("@IDCard", IDCard),
new SqlParameter("@Phone", Phone),
new SqlParameter("@RoleID", RoleID),
new SqlParameter("@LoginName", LoginName),
new SqlParameter("@id", id),
new SqlParameter("@Type", Type)
};
DataTable dt = SQLHelp.ExexProcQuery("Proc_InUserInfo", Para);
return(dt);
}
