public FileResultLocal ExportChecked(string ids) { string[] idList = ids.Split(','); FileResultLocal file = new FileResultLocal(); file.FileName = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + ".txt"; string data = ""; foreach (string id in idList) { var uist = db.UserInstance.Single(u => u.ID == id); var json = JsonSerializer.SerializeUserInstance(uist); data += json; data += "\r\n"; uist.AcceptedTime = DateTime.Now; uist.Status = (int)Status.Accepted; uist.RetreatReason = ""; db.ObjectStateManager.ChangeObjectState(uist, EntityState.Modified); } data += "###"; data += "\r\n"; foreach (string id in idList) { var uinst = db.UserInstance.Single(u => u.ID == id); var ist = uinst.Instance; var json = new JavaScriptSerializer().Serialize(ist); data += json; data += "\r\n"; } file.Data = data; db.SaveChanges(); return file; }
public FileResultLocal ExportAll() { FileResultLocal file = new FileResultLocal(); file.FileName = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + ".txt"; var instanceList = from uist in db.UserInstance where uist.Status == (int)Status.Checked select uist.Instance; var usintList = from uist in db.UserInstance where uist.Status == (int)Status.Checked select uist; string data = ""; foreach (var u in usintList) { var json = JsonSerializer.SerializeUserInstance(u); data += json; data += "\r\n"; } data += "###"; data += "\r\n"; foreach (var ist in instanceList) { //序列化代码 var json = new JavaScriptSerializer().Serialize(ist); data += json; data += "\r\n"; } file.Data = data; var userinstanceList = from uist in db.UserInstance where uist.Status == (int)Status.Checked select uist; foreach (UserInstance u in userinstanceList) { u.AcceptedTime = DateTime.Now; u.Status = (int)Status.Accepted; u.RetreatReason = ""; db.ObjectStateManager.ChangeObjectState(u, EntityState.Modified); } db.SaveChanges(); return file; }