//===========================================交易员===============================================
#region 交易员分页查询
/// <summary>
/// 交易员分页查询
/// </summary>
/// <param name="userInfo">用户查询实体</param>
/// <param name="pageNo">第几页</param>
/// <param name="pageSize">每页行数</param>
/// <param name="rowCount">总记录数</param>
/// <returns></returns>
public DataSet GetPagingUser(Model.UM_UserInfo userInfo, int pageNo, int pageSize, out int rowCount)
{
try
{
return(dal.GetPagingUser(userInfo, pageNo, pageSize, out rowCount));
}
catch (Exception ex)
{
string errCode = "GL-0260";
string errMsg = "交易员分页查询！";
VTException vte = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(vte.ToString(), vte.InnerException);
rowCount = 0;
return(null);
}
}
//=================================================交易员==========================================
#region 交易员分页查询
/// <summary>
/// 分页查询用户
/// </summary>
/// <param name="userInfo">查询条件 用户实体</param>
/// <param name="pageNo">页码</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="rowCount">总页数</param>
/// <returns></returns>
public DataSet GetPagingUser(Model.UM_UserInfo userInfo, int pageNo, int pageSize, out int rowCount)
{
// string SQL_SELECT_CUSTOMER =
//@"select UserName,LoginName,Password,UserID,CertificateStyle,Postalcode,RoleID,CertificateNo,Telephone,Address,Email,QuestionID,Answer,CouterID,Remark,AddType,AddTime FROM UM_UserInfo where 1=1 ";
string SQL_SELECT_CUSTOMER =
@"select a.*,b.name from UM_UserInfo a,CT_Counter b where b.CouterID=a.CouterID ";
if (userInfo.LoginName != null && !string.IsNullOrEmpty(userInfo.LoginName))
{
SQL_SELECT_CUSTOMER += "AND LoginName LIKE '%' + @LoginName + '%' ";
}
if (userInfo.UserName != null && !string.IsNullOrEmpty(userInfo.UserName))
{
SQL_SELECT_CUSTOMER += "AND UserName LIKE '%' + @UserName + '%' ";
}
//if (userInfo.CouterID != int.MaxValue)
//{
// SQL_SELECT_CUSTOMER += "AND CouterID=@CouterID ";
//}
if (userInfo.UserID != int.MaxValue)
{
SQL_SELECT_CUSTOMER += "AND UserID=@UserID ";
}
if (userInfo.RoleID != int.MaxValue)
{
SQL_SELECT_CUSTOMER += "AND RoleID=@RoleID ";
}
if (userInfo.Name != null && !string.IsNullOrEmpty(userInfo.Name)) //柜台名称
{
SQL_SELECT_CUSTOMER += "AND name LIKE '%' + @name + '%' ";
}
Database database = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = database.GetSqlStringCommand(SQL_SELECT_CUSTOMER);
if (userInfo.LoginName != null && !string.IsNullOrEmpty(userInfo.LoginName))
{
database.AddInParameter(dbCommand, "LoginName", DbType.String, userInfo.LoginName);
}
if (userInfo.UserName != null && !string.IsNullOrEmpty(userInfo.UserName))
{
database.AddInParameter(dbCommand, "UserName", DbType.String, userInfo.UserName);
}
//if (userInfo.CouterID != int.MaxValue)
//{
// database.AddInParameter(dbCommand, "CouterID", DbType.Int32, userInfo.CouterID);
//}
if (userInfo.UserID != int.MaxValue)
{
database.AddInParameter(dbCommand, "UserID", DbType.Int32, userInfo.UserID);
}
if (userInfo.RoleID != int.MaxValue)
{
database.AddInParameter(dbCommand, "RoleID", DbType.Int32, userInfo.RoleID);
}
if (userInfo.Name != null && !string.IsNullOrEmpty(userInfo.Name)) //柜台名称
{
database.AddInParameter(dbCommand, "name", DbType.String, userInfo.Name);
}
return(CommPager.QueryPager(database, dbCommand, SQL_SELECT_CUSTOMER, pageNo, pageSize, out rowCount, "TSM_CUSTOMER"));
}
