public IList<AccountOperation> GetAccountOperationByTypeAndDay(String AccountName, String Email, int Day, String Type, String Sort, CY.UME.Core.PagingInfo pageinfo)
{
IList<Core.Business.AccountOperation> accountOperationlist = new List<Core.Business.AccountOperation>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
if (AccountName.Length >= 1)
sql.AddParameter("@AccountName", SqlDbType.NVarChar, AccountName);
if (Email.Length >= 1)
sql.AddParameter("@Email", SqlDbType.NVarChar, Email);
sql.AddParameter("@Day", SqlDbType.Int, Day);
sql.AddParameter("@Type", SqlDbType.NVarChar, Type);
sql.AddParameter("@Sort", SqlDbType.NVarChar, Sort);
sql.AddParameter("@PageSize", SqlDbType.Int, pageinfo.PageSize);
sql.AddParameter("@CurrentPage", SqlDbType.Int, pageinfo.PageSize * (pageinfo.CurrentPage - 1));
SqlDataReader reader = sql.ExecuteSPReader("USP_AccountOperation_Select_By_Type_And_Day");
if (reader != null)
{
while (reader.Read())
{
Core.Business.AccountOperation accountOperation = new Core.Business.AccountOperation();
//if (!reader.IsDBNull(0)) accountOperation.Id = reader.GetInt64(0);
if (!reader.IsDBNull(0)) accountOperation.IsSuccess = reader.GetInt32(0);
if (!reader.IsDBNull(1)) accountOperation.DateCreated = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) accountOperation.Email = reader.GetString(2);
if (!reader.IsDBNull(3)) accountOperation.Type = reader.GetString(3);
if (!reader.IsDBNull(4)) accountOperation.IP = reader.GetString(4);
if (!reader.IsDBNull(5)) accountOperation.Remark = reader.GetString(5);
if (!reader.IsDBNull(6)) accountOperation.AccountId = reader.GetInt64(6);
if (!reader.IsDBNull(7)) accountOperation.AccountName = reader.GetString(7);
if (!reader.IsDBNull(8)) accountOperation.Num = reader.GetInt32(8);
accountOperation.MarkOld();
accountOperationlist.Add(accountOperation);
}
reader.Close();
}
return accountOperationlist;
}
public IList<Core.Business.AccountOperation> GetAllAccountOperation(CY.UME.Core.Business.AccountOperation ao, DateTime StartTime, DateTime EndTime, String Sort, CY.UME.Core.PagingInfo pageInfo)
{
IList<Core.Business.AccountOperation> accountOperationlist = new List<Core.Business.AccountOperation>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
String strFilter = SetStrFilter(ao, StartTime, EndTime);
#region Back Code
/*sql.AddParameter("@Tables", SqlDbType.VarChar, "AccountOperation");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
sql.AddParameter("@Sort", SqlDbType.VarChar, Sort + " DESC");
sql.AddParameter("@Fields", SqlDbType.VarChar, "[Id],[IsSuccess],[DateCreated],[Email],[Type],[IP],[Remark],[AccountId],[AccountName]");
sql.AddParameter("@Filter", SqlDbType.VarChar, strFilter);
sql.AddParameter("@PageNumber", SqlDbType.Int, pageInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pageInfo.PageSize);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");*/
/*String Columns = "[Id],[IsSuccess],[DateCreated],[Email]," +
"(SELECT TOP (1) [Account].[Name] FROM [Account] WHERE [Account].[Id] = (SELECT TOP (1) [AccountExtend].[Id] FROM [AccountExtend] WHERE [AccountExtend].[Email] = [AccountOperation].[Email])) AS [Name]," +
"[Type],[IP],[Remark]";
String SqlGetUC = "SELECT TOP (" + pageInfo.PageSize + ") " + Columns + " FROM [AccountOperation] WHERE [AccountOperation].[Id] NOT IN ";//,[Account],[AccountExtend]
SqlGetUC += "(SELECT TOP (" + pageInfo.PageSize * (pageInfo.CurrentPage - 1) + ") [AccountOperation].[Id] FROM [AccountOperation] WHERE " + strFilter + " ORDER BY " + Sort + " DESC) and " + strFilter + " ORDER BY " + Sort + " DESC";
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetUC);*/
#endregion Back Code
String Columns = "[Id],[IsSuccess],[DateCreated],[Email],[Type],[IP],[Remark],[AccountId],[AccountName]";
String SqlGetUC = "SELECT TOP (" + pageInfo.PageSize + ") " + Columns + " FROM [AccountOperation] WHERE [AccountOperation].[Id] NOT IN ";//,[Account],[AccountExtend]
SqlGetUC += "(SELECT TOP (" + pageInfo.PageSize * (pageInfo.CurrentPage - 1) + ") [AccountOperation].[Id] FROM [AccountOperation] WHERE " + strFilter + " ORDER BY " + Sort + " DESC) and " + strFilter + " ORDER BY " + Sort + " DESC";
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetUC);
if (reader != null)
{
while (reader.Read())
{
Core.Business.AccountOperation accountOperation = new Core.Business.AccountOperation();
if (!reader.IsDBNull(0)) accountOperation.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) accountOperation.IsSuccess = reader.GetInt32(1);
if (!reader.IsDBNull(2)) accountOperation.DateCreated = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) accountOperation.Email = reader.GetString(3);
if (!reader.IsDBNull(4)) accountOperation.Type = reader.GetString(4);
if (!reader.IsDBNull(5)) accountOperation.IP = reader.GetString(5);
if (!reader.IsDBNull(6)) accountOperation.Remark = reader.GetString(6);
if (!reader.IsDBNull(7)) accountOperation.AccountId = reader.GetInt64(7);
if (!reader.IsDBNull(8)) accountOperation.AccountName = reader.GetString(8);
accountOperation.MarkOld();
accountOperationlist.Add(accountOperation);
}
reader.Close();
}
return accountOperationlist;
}
public Core.Business.AccountOperation Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectAccountOperation);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.AccountOperation accountOperation = new Core.Business.AccountOperation();
if (!reader.IsDBNull(0)) accountOperation.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) accountOperation.IsSuccess = reader.GetInt32(1);
if (!reader.IsDBNull(2)) accountOperation.DateCreated = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) accountOperation.Email = reader.GetString(3);
if (!reader.IsDBNull(4)) accountOperation.Type = reader.GetString(4);
if (!reader.IsDBNull(5)) accountOperation.IP = reader.GetString(5);
if (!reader.IsDBNull(6)) accountOperation.Remark = reader.GetString(6);
if (!reader.IsDBNull(7)) accountOperation.AccountId = reader.GetInt64(7);
if (!reader.IsDBNull(8)) accountOperation.AccountName = reader.GetString(8);
reader.Close();
return accountOperation;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<Core.Business.AccountOperation> GetAllAccountOperation()
{
IList<Core.Business.AccountOperation> accountOperationlist = new List<Core.Business.AccountOperation>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllAccountOperation);
if (reader != null)
{
while (reader.Read())
{
Core.Business.AccountOperation accountOperation = new Core.Business.AccountOperation();
if (!reader.IsDBNull(0)) accountOperation.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) accountOperation.IsSuccess = reader.GetInt32(1);
if (!reader.IsDBNull(2)) accountOperation.DateCreated = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) accountOperation.Email = reader.GetString(3);
if (!reader.IsDBNull(4)) accountOperation.Type = reader.GetString(4);
if (!reader.IsDBNull(5)) accountOperation.IP = reader.GetString(5);
if (!reader.IsDBNull(6)) accountOperation.Remark = reader.GetString(6);
if (!reader.IsDBNull(7)) accountOperation.AccountId = reader.GetInt64(7);
if (!reader.IsDBNull(8)) accountOperation.AccountName = reader.GetString(8);
accountOperation.MarkOld();
accountOperationlist.Add(accountOperation);
}
reader.Close();
}
return accountOperationlist;
}
