public Result Serach() { Result result = new Result(); result.IsOK = true; try { XNetEntities db = new XNetEntities(); var list = db.MTMS_BarCodeSNTB.Select(p => new { p.BarCodeSN, p.SummonsNumber }); MTMS_BarCodeSNTB dt = db.MTMS_BarCodeSNTB.FirstOrDefault(a => a.BarCodeSN == "2"); JsonSerializerSettings settings = new JsonSerializerSettings(); settings.MissingMemberHandling = MissingMemberHandling.Ignore; var data = JsonConvert.SerializeObject(list); var data1 = JsonConvert.SerializeObject(dt); } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.InnerException.Message); result.IsOK = false; result.Description = ex.InnerException.Message; } return(result); }
public Result Add() { Result result = new Result(); result.IsOK = true; try { MTMS_BarCodeSNTB b = new MTMS_BarCodeSNTB(); b.BarCodeSN = "1"; b.MaterialCode = "xxx"; b.SummonsNumber = "111111"; // string str = System.Configuration.ConfigurationManager.ConnectionStrings["XNet"].ConnectionString; XNetEntities e = new XNetEntities(); e.AddToMTMS_BarCodeSNTB(b); result.IsOK = Convert.ToBoolean(e.SaveChanges()); } catch (Exception ex) { LogHelper.WriteLog(GetType()).Info(ex.InnerException.Message); result.IsOK = false; result.Description = ex.InnerException.Message; } return(result); }