// GET: Files
public ActionResult Index(string id)
{
List <WorksFilesModel.FileGroup> Model = new List <WorksFilesModel.FileGroup>();
if (!string.IsNullOrEmpty(id))
{
Model = WorksFilesModel.GetFileList(id);
}
return(PartialView(Model));
}
public JsonResult Delete(string[] id)
{
// TODO: Add delete logic here
List <long> value = new List <long>();
for (int i = 0; i < id.Length; i++)
{
value.Add(Convert.ToInt64(id[i]));
}
var _r = WorksFilesModel.DelFile(value);
return(Json(_r));
}
public ActionResult Create(string id, List <HttpPostedFileBase> Img)
{
//try
//{
WorksFilesModel.InsFile(id, Img);
return(RedirectToAction("Edit", new { id = id }));
//}
//catch(Exception exp)
//{
// return RedirectToAction("Edit", new { id = id });
//}
}
// GET: Files/Edit/5
public ActionResult Edit(string id)
{
List <WorksFilesModel.FileGroup> Model = new List <WorksFilesModel.FileGroup>();
if (!string.IsNullOrEmpty(id))
{
Model = WorksFilesModel.GetFileList(id);
//ViewBag.pn = id;
return(View(Model));
}
else
{
return(RedirectToAction("Index", "Works"));
}
}
public static void 處理圖片()
{
using (var context = new EG_MagicCubeEntities())
{
var _WorksList = context.Works.Select(c => c).OrderBy(c => c.MaterialsID).ToList();
foreach (var _w in _WorksList)
{
Console.WriteLine(_w.MaterialsID + " " + _w.WorksName);
string dirpath_o = @"D:\eslite\Doc\魔術方塊\資料匯入\img_20180109_o\" + _w.MaterialsID + @"\";
string dirpath_m = @"D:\eslite\Doc\魔術方塊\資料匯入\img_20180109_800\" + _w.MaterialsID + @"\";
string dirpath_s = @"D:\eslite\Doc\魔術方塊\資料匯入\img_20180109_200\" + _w.MaterialsID + @"\";
if (System.IO.Directory.Exists(dirpath_o))
{
Console.WriteLine(_w.MaterialsID);
foreach (System.IO.FileInfo _file in new System.IO.DirectoryInfo(dirpath_o).GetFiles())
{
string filepath = _file.FullName.ToUpper();
if (filepath.Contains(".JPG") || filepath.Contains(".JPEG") || filepath.Contains(".PNG") || filepath.Contains(".TIF"))
{
string img_o_url = "";
string img_m_url = "";
string img_s_url = "";
string FileName_o = Math.Abs(Guid.NewGuid().GetHashCode()).ToString() + ".jpg";
string FileName_m = Math.Abs(Guid.NewGuid().GetHashCode()).ToString() + ".jpg";
string FileName_s = Math.Abs(Guid.NewGuid().GetHashCode()).ToString() + ".jpg";
System.IO.FileStream fileStream_o = new System.IO.FileStream(_file.FullName, System.IO.FileMode.Open, System.IO.FileAccess.Read);
System.IO.FileStream fileStream_m = new System.IO.FileStream(dirpath_m + _file.Name, System.IO.FileMode.Open, System.IO.FileAccess.Read);
System.IO.FileStream fileStream_s = new System.IO.FileStream(dirpath_s + _file.Name, System.IO.FileMode.Open, System.IO.FileAccess.Read);
byte[] FileBinary_o = new byte[fileStream_o.Length];
using (System.IO.BinaryReader theReader = new System.IO.BinaryReader(fileStream_o))
{
FileBinary_o = theReader.ReadBytes(int.Parse(fileStream_o.Length.ToString()));
img_o_url = WorksFilesModel.SaveToAzure(FileName_o, FileBinary_o);
Console.WriteLine(img_o_url);
}
byte[] FileBinary_m = new byte[fileStream_m.Length];
using (System.IO.BinaryReader theReader = new System.IO.BinaryReader(fileStream_m))
{
FileBinary_m = theReader.ReadBytes(int.Parse(fileStream_m.Length.ToString()));
img_m_url = WorksFilesModel.SaveToAzure(FileName_m, FileBinary_m);
Console.WriteLine(img_m_url);
}
byte[] FileBinary_s = new byte[fileStream_s.Length];
using (System.IO.BinaryReader theReader = new System.IO.BinaryReader(fileStream_s))
{
FileBinary_s = theReader.ReadBytes(int.Parse(fileStream_s.Length.ToString()));
img_s_url = WorksFilesModel.SaveToAzure(FileName_s, FileBinary_s);
Console.WriteLine(img_s_url);
}
context.WorksFiles.Add(new WorksFiles()
{
WorksNo = _w.WorksNo, Sorting = 0, FileBase64Str = Convert.ToBase64String(FileBinary_s), File_o_Url = img_o_url, File_m_Url = img_m_url, File_s_Url = img_s_url
});
context.SaveChanges();
fileStream_o.Close();
fileStream_o.Dispose();
fileStream_m.Close();
fileStream_m.Dispose();
fileStream_s.Close();
fileStream_s.Dispose();
}
}
}
}
Console.ReadLine();
}
}
/// <summary>
/// 回傳圖片
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public FileStreamResult Img(int id)
{
MemoryStream ms = new MemoryStream(Convert.FromBase64String(WorksFilesModel.GetFile(id)));
return(new FileStreamResult(ms, "image/jpg"));
}
public JsonResult UPdateSorting(WorksFilesModel.FileSortingItem [] data)
{
// TODO: Add delete logic here
return(Json(WorksFilesModel.UpdateSorting(data)));
}
