public ReturnMachinePart MachinePartAll() { List <MachinePart> lstMachinePart = null; MachinePart machinePart = null; ReturnMachinePart returnMachinePart = new ReturnMachinePart(); try { using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection()) { using (SqlCommand cmd = new SqlCommand("", sqlConnection)) { cmd.CommandText = "sp_tMachinePart_SelectAll"; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd)) { if (sqlDr.HasRows) { lstMachinePart = new List <MachinePart>(); while (sqlDr.Read()) { machinePart = new MachinePart(); machinePart.ID = int.Parse(sqlDr["ID"].ToString()); machinePart.Name = sqlDr["Name"].ToString(); machinePart.Description = sqlDr["Description"].ToString(); machinePart.MachineType = int.Parse(sqlDr["MachineType"].ToString()); machinePart.DateCreated = DateTime.Parse(sqlDr["DateCreated"].ToString()); machinePart.TypeName = sqlDr["TypeName"].ToString(); lstMachinePart.Add(machinePart); } returnMachinePart.Code = "00"; returnMachinePart.Message = "Lấy dữ liệu thành công."; returnMachinePart.lstMachinePart = lstMachinePart; } else { returnMachinePart.Code = "01"; returnMachinePart.Message = "Không tồn tại bản ghi nào."; returnMachinePart.Total = 0; returnMachinePart.lstMachinePart = null; } } } } } catch (Exception ex) { returnMachinePart.Code = "99"; returnMachinePart.Message = "Lỗi xử lý dữ liệu: " + ex.ToString(); returnMachinePart.Total = 0; returnMachinePart.lstMachinePart = null; mylog4net.Error("", ex); } return(returnMachinePart); }