/// <summary>
/// 根据query得到CPSUser信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetCpsUser(CpsUserQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetCpsUser");
cmd.SetParameterValue("@Status", query.AuditStatus);
cmd.SetParameterValue("@UserType", query.UserType);
cmd.SetParameterValue("@WebSiteType", query.WebSiteType);
cmd.SetParameterValue("@IsAvailable", query.IsActive);
cmd.SetParameterValue("@CustomerID", query.CustomerID);
cmd.SetParameterValue("@ReceivablesName", query.ReceivablesName);
cmd.SetParameterValue("@Email", query.Email);
cmd.SetParameterValue("@Phone", query.Phone);
cmd.SetParameterValue("@ImMessenger", query.ImMessenger);
cmd.SetParameterValue("@RegisterDateFrom", query.RegisterDateFrom);
cmd.SetParameterValue("@RegisterDateTo", query.RegisterDateTo);
cmd.SetParameterValue("@PageIndex", query.PageInfo.PageIndex);
cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize);
cmd.SetParameterValue("@SortFiled", query.PageInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(AuditStatus) },
{ "UserType", typeof(UserType) },
{ "IsAvailable", typeof(IsActive) },
{ "BankLock", typeof(IsLock) },
{ "BankAccountType", typeof(UserType) }
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
public QueryResult GetCpsUser(CpsUserQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <ICpsUserDA> .Instance.GetCpsUser(query, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="mode"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void GetCpsUser(CpsUserQueryVM mode, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string GetCpsUserUrl = "ExternalSYSService/CpsUser/GetCpsUser";
CpsUserQueryFilter query = ConvertQuery(mode);
query.PageInfo = new QueryFilter.Common.PagingInfo()
{
PageIndex = PageIndex,
PageSize = PageSize,
SortBy = SortField
};
restClient.QueryDynamicData(GetCpsUserUrl, query, callback);
}
