/// <summary>
/// 删除群组菜单权限中的功能
/// </summary>
/// <param name="EmployeID"></param>
/// <returns></returns>
public bool DeleteMenuFunctionGroupRight(long GroupID)
{
string sql = "DELETE UT_SYS_MenuFunctionGroupRight WHERE GroupID = " + GroupID;
NDDBAccess.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 删除用户菜单权限中的功能
/// </summary>
/// <param name="EmployeID"></param>
/// <returns></returns>
public bool DeleteUserMenuFunctionRight(long UserID)
{
string sql = "DELETE UT_SYS_MenuFunctionRight WHERE UserID = " + UserID;
NDDBAccess.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 部门排序下移
/// </summary>
/// <param name="curOUID"></param>
/// <param name="perOUID"></param>
/// <returns></returns>
public static void OUSortMovedown(long curOUID, long NextOUID)
{
List <System.Data.SqlClient.SqlParameter> paramList = new List <System.Data.SqlClient.SqlParameter>();
paramList.Add(new System.Data.SqlClient.SqlParameter("@CurOUID", curOUID));
paramList.Add(new System.Data.SqlClient.SqlParameter("@NextOUID", NextOUID));
NDDBAccess.ExecuteNonQuery("UP_ORG_Oth_OUSortMovedown", paramList, CommandType.StoredProcedure);
}
/// <summary>
/// 人员排序上移
/// </summary>
/// <param name="curUserID"></param>
/// <param name="perUserID"></param>
/// <returns></returns>
public static void UserSortMoveup(long curUserID, long perUserID)
{
List <System.Data.SqlClient.SqlParameter> paramList = new List <System.Data.SqlClient.SqlParameter>();
paramList.Add(new System.Data.SqlClient.SqlParameter("@CurUserID", curUserID));
paramList.Add(new System.Data.SqlClient.SqlParameter("@PerUserID", perUserID));
NDDBAccess.ExecuteNonQuery("UP_ORG_Oth_UserSortMoveup", paramList, CommandType.StoredProcedure);
}
/// <summary>
/// 逻辑删除
/// 作者：姚东
/// 时间：20100919
/// </summary>
/// <param name="huiYuanID"></param>
/// <returns></returns>
public int DelInfoHuiYuan(string huiYuanID)
{
string sql = "select * from UT_QS_HuiYuan_Point where HuiYuanGuid='" + huiYuanID + "'";
DataTable dt = NDDBAccess.Fill(sql);
if (dt.Rows.Count > 0)
{
sql = "Update UT_QS_HuiYuan_Point set Status=0 where HuiYuanGuid='" + huiYuanID + "'";
return(NDDBAccess.ExecuteNonQuery(sql));
}
else
{
sql = string.Format("Insert into UT_QS_HuiYuan_Point(HuiYuanGuid,TotalPoint,RemainPoint,Status) values ('{0}',0,0,0)", huiYuanID);
return(NDDBAccess.ExecuteNonQuery(sql));
}
}
/// <summary>
/// 更改会员剩余积分
/// 作者：姚东
/// 时间：20100920
/// </summary>
/// <param name="huiyuanID"></param>
/// <param name="UsedPoint"></param>
/// <returns></returns>
public int UpdateRemainPoint(string huiYuanID, int UsedPoint)
{
string sql = "Update UT_QS_HuiYuan_Point set RemainPoint=RemainPoint-" + UsedPoint.ToString() + " where HuiYuanGuid='" + huiYuanID + "'";
return(NDDBAccess.ExecuteNonQuery(sql));
}
/// <summary>
/// 删除用户权限
/// </summary>
/// <param name="PersonID"></param>
public void DeleteUserRight(long UserID)
{
string sql = "DELETE FROM UT_SYS_Right WHERE UserID = " + UserID;
NDDBAccess.ExecuteNonQuery(sql);
}