public static void AddJob(JTSDataContext dc, string mac, long n) { dc.JOBs.InsertOnSubmit(new JOB { JOB_ID = Guid.NewGuid(), MAC = mac, N = n, ASSIGN_DATE = DateTime.Now, STATUS = 0 }); dc.SubmitChanges(); }
private static void AddJob(JTSDataContext dc, string mac, long n) { dc.jobs.InsertOnSubmit(new job { job_id = Guid.NewGuid(), mac = mac, n = n, assign_date = DateTime.Now, status = 0 }); dc.SubmitChanges(); }
public static void SaveResult(string mac, long n, bool isPrime) { using (JTSDataContext dc = new JTSDataContext()) { var item = (from c in dc.JOBs where c.MAC == mac && c.N == n && c.STATUS == 0 orderby c.ASSIGN_DATE descending select c).FirstOrDefault(); if (item == null) { return; } item.STATUS = isPrime ? (byte)1 : (byte)2; item.COMPLETE_DATE = DateTime.Now; dc.SubmitChanges(); } }
public static void SaveResult(string mac, long n, bool isPrime) { using (JTSDataContext dc = new JTSDataContext()) { var item = (from c in dc.jobs where c.mac == mac && c.n == n && c.status == 0 orderby c.assign_date descending select c).FirstOrDefault(); if (item != null) { item.status = isPrime ? (byte)1 : (byte)2; item.complete_date = DateTime.Now; dc.SubmitChanges(); } } }