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