/// <summary> /// 連結檔案選單 /// </summary> /// <param name="data"></param> public static void Save_Menu(ResourceLinksModels data) { SQLData.Database db = new SQLData.Database(WebInfo.Conn); string Sql = "IF EXISTS (SELECT 1 FROM ResourceLinks WHERE ID=@ID and SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID)" + " UPDATE ResourceLinks SET LinkType=@LinkType, LinkInfo=@LinkInfo, Descriptions=Descriptions, Detail=@Detail, ClickType=@ClickType, Modifier=@Modifier, ModifyTime=GetDate() WHERE ID=@ID and SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID" + " ELSE" + " INSERT INTO ResourceLinks(ID,SiteID,SourceNo, SourceType,Ver,AreaID,LinkType,LinkInfo,Descriptions,Detail,ClickType,Creator,CreateTime)VALUES(@ID,@SiteID,@SourceNo,@SourceType,@Ver,@AreaID,@LinkType,@LinkInfo,@Descriptions,@Detail,@ClickType,@Creator,GetDate())"; SQLData.ParameterCollection para = new SQLData.ParameterCollection(); para.Add("@ID", data.Id); para.Add("@SiteID", data.SiteID); para.Add("@SourceNo", data.SourceNo); para.Add("@SourceType", data.SourceType); para.Add("@Ver", data.Ver); para.Add("@AreaID", data.AreaID); para.Add("@LinkType", data.LinkType); para.Add("@LinkInfo", data.LinkInfo); para.Add("@Descriptions", data.Descriptions); para.Add("@Detail", data.Detail); para.Add("@ClickType", data.ClickType); para.Add("@Creator", MemberDAO.SysCurrent.Id); para.Add("@Modifier", MemberDAO.SysCurrent.Id); db.ExecuteNonQuery(Sql, para); }
public static void SetItem(ResourceLinksModels item) { SQLData.Database db = new SQLData.Database(WebInfo.Conn); SQLData.TableObject tableObj = db.GetTableObject("ResourceLinks"); tableObj.GetDataFromObject(item); string sql = "Select 1 From ResourceLinks Where ID = " + item.Id; bool isNew = db.GetFirstValue(sql) == null; if (isNew) { tableObj["ClickType"] = 0; tableObj["Creator"] = MemberDAO.SysCurrent.Id; tableObj["CreateTime"] = DateTime.Now; tableObj.Insert(); } else { string[] removeFields = { "ID", "SiteID", "SourceNo", "SourceType", "Ver", "AreaID", "ClickType", "Code", "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); } }
private static ResourceLinksModels CreateData(DataRow dr) { ResourceLinksModels nData = new ResourceLinksModels { Id = (long)dr["id"], SiteID = (long)dr["SiteID"], SourceNo = (long)dr["SourceNo"], SourceType = (byte)dr["SourceType"], Ver = (int)dr["Ver"], AreaID = (byte)dr["AreaID"], LinkType = dr["LinkType"].ToString().Trim(), LinkInfo = dr["LinkInfo"].ToString().Trim(), Descriptions = dr["Descriptions"].ToString().Trim(), Detail = dr["Detail"].ToString().Trim(), ClickType = (int)dr["ClickType"], Creator = (long)dr["Creator"], CreateTime = dr["CreateTime"] as DateTime?, Modifier = dr["Modifier"] as long?, ModifyTime = dr["ModifyTime"] as DateTime? }; return(nData); }
public static ResourceLinksModels GetInfo(long SiteID, long SourceNo, byte SourceType, int AreaID, long Id, int Ver) { SQLData.Database db = new SQLData.Database(WebInfo.Conn); string Sql = "Select * From ResourceLinks Where Id=@Id and SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID"; SQLData.ParameterCollection para = new SQLData.ParameterCollection(); para.Add("@ID", Id); para.Add("@SiteID", SiteID); para.Add("@SourceNo", SourceNo); para.Add("@SourceType", SourceType); para.Add("@Ver", Ver); para.Add("@AreaID", AreaID); DataTable dt = db.GetDataTable(Sql, para); ResourceLinksModels _TempRow = new ResourceLinksModels(); if (dt.Rows.Count > 0) { _TempRow = CreateData(dt.Rows[0]); } return(_TempRow); }
public void MenuEdit_Link(MenusModels MData, string Sites, string[] Pages, string PageDetailID) { ViewBag.HasChildren = false; var childList = MenusDAO.GetChildren(MData.ID); if (childList != null && childList.Count() > 0) { ViewBag.HasChildren = true; } MenusDAO.Save_Single(MData); ResourceLinksModels newLink = new ResourceLinksModels(); newLink.Id = 1; newLink.SiteID = MData.SiteID; newLink.SourceNo = MData.ID; newLink.SourceType = (byte)SourceType.Menu; newLink.Ver = 1; newLink.AreaID = 1; bool isOpenNewWin = Request["OpenNewWin"].Contains("true"); if (isOpenNewWin) { newLink.ClickType = (byte)ClickType.OpenNewWin; } else { newLink.ClickType = (byte)ClickType.PageOpen; } //WorkLib.WriteLog.Write(true, Request["inLink"]); if (Request["inLink"].Contains("true")) { newLink.LinkInfo = Request["LinkInfo"].ToString(); newLink.LinkType = ResourceLinkType.inLink; if (!string.IsNullOrEmpty(PageDetailID)) { newLink.Detail = PageDetailID; var pageInfo = WorkV3.Areas.Backend.Models.DataAccess.PagesDAO.GetPageInfo(long.Parse(PageDetailID)); if (pageInfo != null) { var siteInfo = WorkV3.Models.DataAccess.SitesDAO.GetInfo(pageInfo.SiteID); newLink.LinkInfo = Url.RouteUrl("FrontSitePage", new { SiteSN = siteInfo.SN, PageSN = pageInfo.SN }); } } else if (Pages != null) { for (int i = 0; i < Pages.Length; i++) { if (!string.IsNullOrEmpty(Pages[i])) { newLink.Detail = Pages[i]; } } if (!string.IsNullOrEmpty(newLink.Detail)) { var pageInfo = WorkV3.Areas.Backend.Models.DataAccess.PagesDAO.GetPageInfo(long.Parse(newLink.Detail)); if (pageInfo != null) { var siteInfo = WorkV3.Models.DataAccess.SitesDAO.GetInfo(pageInfo.SiteID); newLink.LinkInfo = Url.RouteUrl("FrontSitePage", new { SiteSN = siteInfo.SN, PageSN = pageInfo.SN }); } } } } else { newLink.LinkType = ResourceLinkType.outLink; newLink.LinkInfo = Request["LinkInfo"].ToString(); } ResourceLinksDAO.Save_Menu(newLink); SysLog.SaveLog(SysActions.Edit, SysMgrNo.Menu, MData.Title, MData.SiteID, MData.ID); TempData["refreshData"] = SysActions.Edit; Response.Redirect(Request.RawUrl); }
public ActionResult MenuEdit_Link(long?id) { ViewBag.HasChildren = false; List <long> MenuIDs = new List <long>(); Dictionary <int, WorkV3.Models.MenusModels> MenuList = new Dictionary <int, WorkV3.Models.MenusModels>(); if (uCheck.IsNumeric(id)) { long SiteID = GetItem.SiteID(); MenusModels mm = MenusDAO.GetInfo(GetItem.SiteID(), (long)id); ResourceLinksModels newLink = ResourceLinksDAO.GetInfo(SiteID, (long)id, (byte)SourceType.Menu, 1, 1, 1); ViewBag.LinkInfo = newLink; var childList = MenusDAO.GetChildren(id.Value); if (childList != null && childList.Count() > 0) { ViewBag.HasChildren = true; } int menuLev = 0; if (!string.IsNullOrEmpty(newLink.Detail)) { var menuInfo = WorkV3.Models.DataAccess.MenusDAO.GetInfo(long.Parse(newLink.Detail)); if (menuInfo != null && !string.IsNullOrEmpty(menuInfo.Title)) { ViewBag.DefaultSiteID = menuInfo.SiteID; menuLev++; MenuList.Add(menuLev, menuInfo); while (menuInfo.ParentID != 0) { menuInfo = WorkV3.Models.DataAccess.MenusDAO.GetInfo(menuInfo.ParentID); if (menuInfo != null && !string.IsNullOrEmpty(menuInfo.Title)) { menuLev++; MenuList.Add(menuLev, menuInfo); } else { break; } } } else { var pageInfo = WorkV3.Areas.Backend.Models.DataAccess.PagesDAO.GetPageInfo(long.Parse(newLink.Detail)); if (pageInfo != null && !string.IsNullOrEmpty(pageInfo.Title)) { ViewBag.DefaultSiteID = pageInfo.SiteID; ViewBag.DefaultPageTitle = pageInfo.Title; var page_menuInfo = WorkV3.Models.DataAccess.MenusDAO.GetInfo(pageInfo.MenuID); if (page_menuInfo != null) { menuLev++; MenuList.Add(menuLev, page_menuInfo); while (page_menuInfo.ParentID != 0) { page_menuInfo = WorkV3.Models.DataAccess.MenusDAO.GetInfo(page_menuInfo.ParentID); if (page_menuInfo != null && !string.IsNullOrEmpty(page_menuInfo.Title)) { menuLev++; MenuList.Add(menuLev, page_menuInfo); } else { break; } } } } } if (MenuList != null && MenuList.Count > 0) { var orderMenus = MenuList.OrderByDescending(p => p.Key).Select(p => p.Value.Id); MenuIDs = orderMenus.ToList(); } ViewBag.DefaultMenus = MenuIDs; } return(View(mm)); } return(View()); }