public static List<Message> operateToMessage(List<Operator> listOp)
        {
            List<Message> listMessage = new List<Message>() ;

            foreach(Operator o in listOp){
                Message me = new Message();
                me.recordID = o.record.recordID;
                me.carID = o.record.carID;
                me.time = o.record.time;
                me.worker = o.record.worker;
                me.faultID = o.record.faultID;
                me.fault = o.fault.fault;
                me.faultKey = o.fault.faultKey;
                me.solutionID = o.record.solutionID;
                me.solution = o.solution.solution;
                me.runSolution = o.solution.runSolution;
                listMessage.Add(me);
            }
            return listMessage;
        }
        public static int updateMessage(Message m)
        {
            Operator op = findAllByRecordID(m.recordID);

            m.solutionID = op.solution.solutionID;
            m.faultID = op.fault.faultID;

            Record r = new Record();
            r.recordID = m.recordID;
            r.carID = m.carID;
            r.time = m.time;
            r.worker = m.worker;
            r.faultID = m.faultID;
            r.solutionID = m.solutionID;
            updateRecord(r);

            Fault f = new Fault();
            f.faultID = m.faultID;
            f.fault = m.fault;
            f.faultKey = m.faultKey;
            f.faultImgs = op.fault.faultImgs;
            updateFault(f);

            Solution s = new Solution();
            s.solutionID = m.solutionID;
            s.solution = m.solution;
            s.runSolution = m.runSolution;
            s.criImgs = op.solution.criImgs;
            int i = 0;
            i = updateSolution(s);
            if (i != 0)
            {
                return 0;
            }
            else
            {
                return 1;
            }
        }
 public int UpdateM(Message m)
 {
     int res = SqlHelper.updateMessage(m);
     return res;
 }
        public static List<Message> getAllMessage()
        {
            List<Operator> oplist = getAll();

            List<Message> melist = new List<Message>();

            foreach (Operator o in oplist)
            {
                Message m = new Message();
                m.recordID = o.record.recordID;
                m.carID = o.record.carID;
                m.time = o.record.time;
                m.worker = o.record.worker;
                m.faultID = o.record.faultID;
                m.solutionID = o.solution.solutionID;
                m.fault = o.fault.fault;
                m.faultKey = o.fault.faultKey;
                m.solution = o.solution.solution;
                m.runSolution = o.solution.runSolution;
                melist.Add(m);
            }
            return melist;
        }