public object GetAddUserInfo(string data)
{
string Message = string.Empty;
int Success = 0;
int TotalCount = 0;
try
{
AllUserPermissionsFilter filter = JsonConvert.DeserializeObject <AllUserPermissionsFilter>(data);
var resultData = EmployeeActionOperator.Instance.GetAddUserInfo(filter, out TotalCount);
Success = 1;
Message = "查询成功";
return(new
{
Data = resultData,
TotalCount = TotalCount,
Success = Success,
Message = Message
});
}
catch (Exception ex)
{
return(new
{
Data = "",
TotalCount = TotalCount,
Success = 0,
Message = ex.Message
});
}
}
/// <summary>
/// 查询员工信息,角色添加用户用
/// </summary>
/// <param name="filter"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public List <AllUserPermissions> GetAddUserInfo(AllUserPermissionsFilter filter, out int TotalCount)
{
//string sql = string.Format("exec Proc_GetContractList @ContractCode,@ContractName,@PartyAUnitName,@DataStatus,@ContractTypeCode,@ScalingName,@PartyBUnitName,@BusinessKey,@ProjectID,@pageSize,@pageNumber,@PageSource");
string sql = string.Format("Exec [dbo].[Pro_GetUserInfo] @RoleID,@KeyWord,@PageIndex, @PageSize");
DbParameter[] parameters = new DbParameter[] {
CreateSqlParameter("@LoginName", DbType.String, filter.LoginName),
CreateSqlParameter("@RoleID", DbType.Guid, filter.RoleID),
CreateSqlParameter("@KeyWord", DbType.String, filter.keyWord),
CreateSqlParameter("@PageIndex", DbType.Int32, filter.PageIndex),
CreateSqlParameter("@PageSize", DbType.Int32, filter.PageSize)
};
DataSet ds = ExecuteReturnDataSet(sql, parameters);
List <AllUserPermissions> list = new List <AllUserPermissions>();
TotalCount = 0;
if (ds != null)
{
DataTable returnTable = ds.Tables[0];
string tempName = string.Empty;
if (returnTable != null)
{
foreach (DataRow dr in returnTable.Rows)
{
AllUserPermissions obj = new AllUserPermissions();
System.Reflection.PropertyInfo[] propertys = obj.GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
tempName = pi.Name;
if (returnTable.Columns.Contains(tempName))
{
if (!pi.CanWrite)
{
continue;
}
object value = dr[tempName];
if (value != DBNull.Value)
{
pi.SetValue(obj, value, null);
}
}
}
list.Add(obj);
}
}
TotalCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
}
return(list);
}
/// <summary>
/// 查询员工信息,角色添加用户用
/// </summary>
/// <param name="filter"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public List <AllUserPermissions> GetAddUserInfo(AllUserPermissionsFilter filter, out int TotalCount)
{
return(_smployeeAdapter.GetAddUserInfo(filter, out TotalCount));
}