public IList <string> GetUserNameList(int startRowIndexId, int maxiNumRows, int searchType, string keyword)
{
IList <string> list = new List <string>();
CommonListParameters cmdParams = new CommonListParameters(startRowIndexId, maxiNumRows);
cmdParams.TableName = "PE_Users";
cmdParams.StrColumn = "UserName";
cmdParams.SortColumn = "UserId";
cmdParams.Sorts = Sorts.Asc;
switch (searchType)
{
case 0:
cmdParams.Filter = " GroupID = " + DBHelper.ToNumber(keyword);
break;
case 1:
cmdParams.Filter = " UserName LIKE '%" + DBHelper.FilterBadChar(keyword) + "%'";
break;
}
cmdParams.CreateParameter();
using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Common_GetList", cmdParams))
{
while (reader.Read())
{
list.Add(reader.GetString("UserName"));
}
}
return(list);
}
public IList <BankInfo> GetList(int startRowIndexId, int maxiNumRows)
{
List <BankInfo> list = new List <BankInfo>();
CommonListParameters cmdParams = new CommonListParameters(startRowIndexId, maxiNumRows);
cmdParams.TableName = "PE_Bank";
cmdParams.StrColumn = "*";
cmdParams.SortColumn = "OrderID";
cmdParams.Sorts = Sorts.Asc;
cmdParams.CreateParameter();
using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Common_GetList", cmdParams))
{
while (reader.Read())
{
list.Add(BankFromDataReader(reader));
}
}
return(list);
}
public IList <CardInfo> GetCardList(int startRowIndexId, int maxiNumRows, int cardType, int cardStatus, int field, string keyword, string agentName)
{
IList <CardInfo> list = new List <CardInfo>();
CommonListParameters cmdParams = new CommonListParameters(startRowIndexId, maxiNumRows);
cmdParams.TableName = "PE_Cards";
cmdParams.StrColumn = "*";
cmdParams.SortColumn = "CardID";
cmdParams.Sorts = Sorts.Desc;
cmdParams.Filter = GetField(cardType, cardStatus, field, keyword, agentName);
cmdParams.CreateParameter();
using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Common_GetList", cmdParams))
{
while (reader.Read())
{
CardInfo item = CardFromDataReader(reader);
list.Add(item);
}
}
return(list);
}
