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); } }