public string DownloadRange(int id) { string fileName = GetTempName(); RangeDataEntity entity = new RangeDataEntity(); RangeDataModel result = entity.DownloadRange(id); using (FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write, FileShare.None)) { using (StreamWriter sw = new StreamWriter(fs, Encoding.UTF8)) { sw.WriteLine(result.Data.Length.ToString()); sw.WriteLine(result.Data[0].Length.ToString()); sw.WriteLine(); for (int r = 0; r < result.Data.Length; r++) { for (int c = 0; c < result.Data[r].Length; c++) { sw.WriteLine(result.Data[r][c]); } } sw.Close(); } } return(fileName); }
public JsonResult DownloadRange(int RangeId) { RangeDataModel rDataModel = new RangeDataModel(); using (var context = new xlsnippingtoolEntities()) { var qry = context.RangeDatas.ToList().Where(x => x.RangeId.Equals(RangeId)); RangeData data = qry.FirstOrDefault(); if (data == null) { return null; } String[][] rData = JsonConvert.DeserializeObject<String[][]>(data.Data); rDataModel.Address = data.Address; rDataModel.Data = rData; } return Json(rDataModel, JsonRequestBehavior.AllowGet); }
public JsonResult DownloadRange(int RangeId) { RangeDataModel rDataModel = new RangeDataModel(); using (var context = new xlsnippingtoolEntities()) { var qry = context.RangeDatas.ToList().Where(x => x.RangeId.Equals(RangeId)); RangeData data = qry.FirstOrDefault(); if (data == null) { return(null); } String[][] rData = JsonConvert.DeserializeObject <String[][]>(data.Data); rDataModel.Address = data.Address; rDataModel.Data = rData; } return(Json(rDataModel, JsonRequestBehavior.AllowGet)); }