public ListResponeMessage <AnalyzerGroupInfo> GetListWithCondition(
string AnalyzerGroupCode,
string quoteCode,
string contractCode,
DateTime fromDate, DateTime toDate, int pageSize = 10, int pageIndex = 0)
{
ListResponeMessage <AnalyzerGroupInfo> ret = new ListResponeMessage <AnalyzerGroupInfo>();
try
{
AnalyzerGroupSeachCriteria _criteria = new AnalyzerGroupSeachCriteria();
_criteria.AnalyzerGroupCode = AnalyzerGroupCode;
_criteria.pageSize = pageSize;
_criteria.pageIndex = pageIndex;
ret.isSuccess = true;
ret.data = AnalyzerGroupService.GetInstance().getAllAnalyzerGroup(_criteria);
ret.totalRecords = AnalyzerGroupService.GetInstance().getTotalRecords(_criteria);
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "005";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public List <AnalyzerGroupInfo> getAllAnalyzerGroup(AnalyzerGroupSeachCriteria _criteria)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(AnalyzerGroupDataLayer.GetInstance().GetAllAnalyzerGroup(connection, _criteria));
}
}
public int getTotalRecords(AnalyzerGroupSeachCriteria _criteria)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(AnalyzerGroupDataLayer.GetInstance().getTotalRecords(connection, _criteria));
}
}
/// <summary>
/// Hàm lấy số record theo điều kiện
/// </summary>
/// <param Criteria="_criteria"></param>
/// <returns>Return List<AnalyzerGroupInfo></returns>
///
public int getTotalRecords(SqlConnection connection, AnalyzerGroupSeachCriteria _criteria)
{
if (_criteria != null)
{
using (var command = new SqlCommand("Select count(ANG.AnalyzerGroupID) as TotalRecords " +
" from tbl_AnalyzerGroup ANG where 1 = 1 ", connection))
{
if (!string.IsNullOrEmpty(_criteria.AnalyzerGroupCode))
{
command.CommandText += " and ANG.AnalyzerGroupCode = @AnalyzerGroupCode";
AddSqlParameter(command, "@AnalyzerGroupCode", _criteria.AnalyzerGroupCode, System.Data.SqlDbType.NVarChar);
}
WriteLogExecutingCommand(command);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
return(GetDbReaderValue <int>(reader["TotalRecords"]));
}
}
}
}
else
{
using (var command = new SqlCommand("Select count(*) as TotalRecords from tbl_AnalyzerGroup where 1 = 1 ", connection))
{
WriteLogExecutingCommand(command);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
return(GetDbReaderValue <int>(reader["TotalRecords"]));
}
}
}
}
return(0);
}
/// <summary>
/// Hàm lấy tất cả nhóm tài sản
/// </summary>
/// <param name="connection"> </param>
/// <returns>Return List<AnalyzerGroupInfo></returns>
///
public List <AnalyzerGroupInfo> GetAllAnalyzerGroup(SqlConnection connection, AnalyzerGroupSeachCriteria _criteria)
{
var result = new List <AnalyzerGroupInfo>();
using (var command = new SqlCommand("Select ANG.* " +
" from tbl_AnalyzerGroup ANG " +
" where 1 = 1 order by ANG.AnalyzerGroupName Desc "
, connection))
{
if (_criteria.pageSize == 0)
{
_criteria.pageSize = 10;
}
var offSet = _criteria.pageIndex * _criteria.pageSize;
command.CommandText += " OFFSET @OFFSET ROWS FETCH NEXT @PAGESIZE ROWS ONLY ";
AddSqlParameter(command, "@OFFSET", offSet, System.Data.SqlDbType.Int);
AddSqlParameter(command, "@PAGESIZE", _criteria.pageSize, System.Data.SqlDbType.Int);
WriteLogExecutingCommand(command);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var info = new AnalyzerGroupInfo();
info.AnalyzerGroupID = GetDbReaderValue <int>(reader["AnalyzerGroupID"]);
info.AnalyzerGroupCode = GetDbReaderValue <string>(reader["AnalyzerGroupCode"]);
info.AnalyzerGroupName = GetDbReaderValue <string>(reader["AnalyzerGroupName"]);
info.UserI = GetDbReaderValue <string>(reader["UserI"]);
info.InTime = GetDbReaderValue <DateTime?>(reader["InTime"]);
info.UserU = GetDbReaderValue <string>(reader["UserU"]);
info.UpdateTime = GetDbReaderValue <DateTime>(reader["UpdateTime"]);
result.Add(info);
}
}
return(result);
}
}
