public static void SetItem(ResourceFilesModels item) { SQLData.Database db = new SQLData.Database(WebInfo.Conn); SQLData.TableObject tableObj = db.GetTableObject("ResourceFiles"); tableObj.GetDataFromObject(item); string sql = "Select 1 From ResourceFiles Where ID = " + item.Id; bool isNew = db.GetFirstValue(sql) == null; if (isNew) { tableObj["FileType"] = ResourceFileType.inFile; tableObj["FileMimeType"] = item.GetMimeType(); tableObj["ClickType"] = 0; tableObj["Creator"] = MemberDAO.SysCurrent.Id; tableObj["CreateTime"] = DateTime.Now; tableObj.Insert(); } else { string[] removeFields = { "ID", "SiteID", "SourceNo", "SourceType", "Ver", "AreaID", "FileType", "FileMimeType", "ClickType", "Creator", "CreateTime" }; foreach (string f in removeFields) { tableObj.Remove(f); } tableObj["Modifier"] = MemberDAO.SysCurrent.Id; tableObj["ModifyTime"] = DateTime.Now; SQLData.ParameterCollection keys = new SQLData.ParameterCollection(); keys.Add("@ID", item.Id); keys.Add("@SiteID", item.SiteID); keys.Add("@SourceNo", item.SourceNo); keys.Add("@SourceType", item.SourceType); keys.Add("@Ver", item.Ver); keys.Add("@AreaID", item.AreaID); tableObj.Update(keys); } }
public ActionResult MenuEdit_File(MenusModels MData, HttpPostedFileBase updFiles) { ViewBag.HasChildren = false; var childList = MenusDAO.GetChildren(MData.ID); if (childList != null && childList.Count() > 0) { ViewBag.HasChildren = true; } MenusDAO.Save_Single(MData); //單檔 if (updFiles != null) { if (updFiles.ContentLength > 0) { string uPath = UpdFileInfo.GetUPathBySiteID(MData.SiteID, "Menus"); string fileName = UpdFileInfo.SaveFiles(updFiles, uPath); ResourceFilesModels newFile = new ResourceFilesModels(); newFile.Id = 1; newFile.SiteID = MData.SiteID; newFile.SourceNo = MData.ID; newFile.SourceType = (byte)SourceType.Menu; newFile.Ver = 1; newFile.AreaID = 1; newFile.FileInfo = fileName; newFile.FileType = ResourceFileType.inFile; newFile.ClickType = (byte)ClickType.OpenNewWin; newFile.FileSize = newFile.GetSize(uPath); newFile.FileMimeType = newFile.GetMimeType(); ResourceFilesDAO.Save_Menu(newFile); } else { ResourceFilesDAO.DelAll(MData.SiteID, MData.ID, (byte)SourceType.Menu, 1, 1); } } //多檔 //List<ResourceFilesModels> newFileList = new List<ResourceFilesModels>(); //int Count = 0; //foreach (var ff in updFiles) //{ // if (ff != null) // { // if (ff.ContentLength > 0) // { // Count += 1; // var fileName = Path.GetFileName(ff.FileName); // var path = Path.Combine(GetItem.UpdPath(GetItem.SiteID() + "\\Menus"), fileName); // ff.SaveAs(path); // } // } //} SysLog.SaveLog(SysActions.Edit, SysMgrNo.Menu, MData.Title, MData.SiteID, MData.ID); TempData["refreshData"] = SysActions.Edit; Response.Redirect(Request.RawUrl); return(View()); }