public virtual bool AddHomeLeftCate(HomeLeftCateInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT TOP 0 * FROM Home_Left_Cate"; DtAdd = DBHelper.Query(SqlAdd); DrAdd = DtAdd.NewRow(); DrAdd["Home_Left_Cate_ID"] = entity.Home_Left_Cate_ID; DrAdd["Home_Left_Cate_ParentID"] = entity.Home_Left_Cate_ParentID; DrAdd["Home_Left_Cate_CateID"] = entity.Home_Left_Cate_CateID; DrAdd["Home_Left_Cate_Name"] = entity.Home_Left_Cate_Name; DrAdd["Home_Left_Cate_URL"] = entity.Home_Left_Cate_URL; DrAdd["Home_Left_Cate_Img"] = entity.Home_Left_Cate_Img; DrAdd["Home_Left_Cate_Sort"] = entity.Home_Left_Cate_Sort; DrAdd["Home_Left_Cate_Active"] = entity.Home_Left_Cate_Active; DrAdd["Home_Left_Cate_Site"] = entity.Home_Left_Cate_Site; DtAdd.Rows.Add(DrAdd); try { DBHelper.SaveChanges(SqlAdd, DtAdd); return(true); } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } }
public virtual bool EditHomeLeftCate(HomeLeftCateInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "de88931b-4a5b-4bb7-8f68-4975ad26e59c")) { return(MyDAL.EditHomeLeftCate(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:de88931b-4a5b-4bb7-8f68-4975ad26e59c错误"); } }
public virtual IList <HomeLeftCateInfo> GetHomeLeftCates(QueryInfo Query) { int PageSize; int CurrentPage; IList <HomeLeftCateInfo> entitys = null; HomeLeftCateInfo entity = null; string SqlList, SqlField, SqlOrder, SqlParam, SqlTable; SqlDataReader RdrList = null; try { CurrentPage = Query.CurrentPage; PageSize = Query.PageSize; SqlTable = "Home_Left_Cate"; SqlField = "*"; SqlParam = DBHelper.GetSqlParam(Query.ParamInfos); SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos); SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize); RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.HasRows) { entitys = new List <HomeLeftCateInfo>(); while (RdrList.Read()) { entity = new HomeLeftCateInfo(); entity.Home_Left_Cate_ID = Tools.NullInt(RdrList["Home_Left_Cate_ID"]); entity.Home_Left_Cate_ParentID = Tools.NullInt(RdrList["Home_Left_Cate_ParentID"]); entity.Home_Left_Cate_CateID = Tools.NullInt(RdrList["Home_Left_Cate_CateID"]); entity.Home_Left_Cate_Name = Tools.NullStr(RdrList["Home_Left_Cate_Name"]); entity.Home_Left_Cate_URL = Tools.NullStr(RdrList["Home_Left_Cate_URL"]); entity.Home_Left_Cate_Img = Tools.NullStr(RdrList["Home_Left_Cate_Img"]); entity.Home_Left_Cate_Sort = Tools.NullInt(RdrList["Home_Left_Cate_Sort"]); entity.Home_Left_Cate_Active = Tools.NullInt(RdrList["Home_Left_Cate_Active"]); entity.Home_Left_Cate_Site = Tools.NullStr(RdrList["Home_Left_Cate_Site"]); entitys.Add(entity); entity = null; } } return(entitys); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool AddHomeLeftCate(HomeLeftCateInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "8738cd22-6808-4fdd-94f4-d9bb51b64509")) { return(MyDAL.AddHomeLeftCate(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:8738cd22-6808-4fdd-94f4-d9bb51b64509错误"); } }
public virtual void EditHomeLeftCate() { int Home_Left_Cate_ID = tools.CheckInt(Request.Form["Home_Left_Cate_ID"]); int Home_Left_Cate_ParentID = tools.CheckInt(Request.Form["Home_Left_Cate_ParentID"]); int Home_Left_Cate_CateID = tools.CheckInt(Request.Form["Home_Left_Cate_CateID"]); string Home_Left_Cate_Name = tools.CheckStr(Request.Form["Home_Left_Cate_Name"]); string Home_Left_Cate_URL = tools.CheckStr(Request.Form["Home_Left_Cate_URL"]); string Home_Left_Cate_Img = tools.CheckStr(Request.Form["Home_Left_Cate_Img"]); int Home_Left_Cate_Sort = tools.CheckInt(Request.Form["Home_Left_Cate_Sort"]); int Home_Left_Cate_Active = tools.CheckInt(Request.Form["Home_Left_Cate_Active"]); if (Home_Left_Cate_Name.Length == 0) { Public.Msg("error", "错误信息", "请填写类别名称", false, "{back}"); } HomeLeftCateInfo entity = GetHomeLeftCateByID(Home_Left_Cate_ID); if (entity != null) { entity.Home_Left_Cate_ParentID = Home_Left_Cate_ParentID; entity.Home_Left_Cate_CateID = Home_Left_Cate_CateID; entity.Home_Left_Cate_Name = Home_Left_Cate_Name; entity.Home_Left_Cate_URL = Home_Left_Cate_URL; entity.Home_Left_Cate_Img = Home_Left_Cate_Img; entity.Home_Left_Cate_Sort = Home_Left_Cate_Sort; entity.Home_Left_Cate_Active = Home_Left_Cate_Active; if (MyBLL.EditHomeLeftCate(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "homeleftcate_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public virtual bool EditHomeLeftCate(HomeLeftCateInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Home_Left_Cate WHERE Home_Left_Cate_ID = " + entity.Home_Left_Cate_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Home_Left_Cate_ID"] = entity.Home_Left_Cate_ID; DrAdd["Home_Left_Cate_ParentID"] = entity.Home_Left_Cate_ParentID; DrAdd["Home_Left_Cate_CateID"] = entity.Home_Left_Cate_CateID; DrAdd["Home_Left_Cate_Name"] = entity.Home_Left_Cate_Name; DrAdd["Home_Left_Cate_URL"] = entity.Home_Left_Cate_URL; DrAdd["Home_Left_Cate_Img"] = entity.Home_Left_Cate_Img; DrAdd["Home_Left_Cate_Sort"] = entity.Home_Left_Cate_Sort; DrAdd["Home_Left_Cate_Active"] = entity.Home_Left_Cate_Active; DrAdd["Home_Left_Cate_Site"] = entity.Home_Left_Cate_Site; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }
public virtual HomeLeftCateInfo GetHomeLeftCateByLastID() { HomeLeftCateInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT top 1 * FROM Home_Left_Cate Order By Home_Left_Cate_ID Desc"; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new HomeLeftCateInfo(); entity.Home_Left_Cate_ID = Tools.NullInt(RdrList["Home_Left_Cate_ID"]); entity.Home_Left_Cate_ParentID = Tools.NullInt(RdrList["Home_Left_Cate_ParentID"]); entity.Home_Left_Cate_CateID = Tools.NullInt(RdrList["Home_Left_Cate_CateID"]); entity.Home_Left_Cate_Name = Tools.NullStr(RdrList["Home_Left_Cate_Name"]); entity.Home_Left_Cate_URL = Tools.NullStr(RdrList["Home_Left_Cate_URL"]); entity.Home_Left_Cate_Img = Tools.NullStr(RdrList["Home_Left_Cate_Img"]); entity.Home_Left_Cate_Sort = Tools.NullInt(RdrList["Home_Left_Cate_Sort"]); entity.Home_Left_Cate_Active = Tools.NullInt(RdrList["Home_Left_Cate_Active"]); entity.Home_Left_Cate_Site = Tools.NullStr(RdrList["Home_Left_Cate_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public string CateRecursion(int Cate_ID, string HrefURL) { string Cate_Name = ""; int ParentID = 0; HomeLeftCateInfo entity = GetHomeLeftCateByID(Cate_ID); if (entity != null) { ParentID = entity.Home_Left_Cate_ParentID; Cate_Name = entity.Home_Left_Cate_Name; } else { Cate_ID = 0; } string CateNameStr = ""; if (ParentID > 0) { CateNameStr = CateRecursion(ParentID, HrefURL); } if (CateNameStr.Length > 0) { CateNameStr += " > "; } if (HrefURL.Length > 0) { CateNameStr += "<a href=\"" + HrefURL.Replace("{cate_id}", Cate_ID.ToString()) + "\">" + Cate_Name + "</a>"; } else { CateNameStr += Cate_Name; } return(CateNameStr); }
public virtual void HomeLeftCate_Input() { MyBLL.DelHomeLeftCateAll(Public.GetUserPrivilege()); HomeLeftCateInfo entity = null; HomeLeftCateInfo LastCate = null; HomeLeftCateInfo LastCate1 = null; QueryInfo Query = new QueryInfo(); Query.PageSize = 0; Query.CurrentPage = 1; Query.ParamInfos.Add(new ParamInfo("AND", "str", "CategoryInfo.Cate_Site", "=", Public.GetCurrentSite())); Query.ParamInfos.Add(new ParamInfo("AND", "int", "CategoryInfo.Cate_ParentID", "=", "0")); Query.OrderInfos.Add(new OrderInfo("CategoryInfo.Cate_ID", "ASC")); IList <CategoryInfo> Categorys = MyCate.GetCategorys(Query, Public.GetUserPrivilege()); if (Categorys != null) { foreach (CategoryInfo Category in Categorys) { entity = new HomeLeftCateInfo(); entity.Home_Left_Cate_ParentID = Category.Cate_ParentID; entity.Home_Left_Cate_CateID = Category.Cate_ID; entity.Home_Left_Cate_Name = Category.Cate_Name; entity.Home_Left_Cate_URL = "/product/category.aspx?cate_id=" + Category.Cate_ID; entity.Home_Left_Cate_Img = Category.Cate_Img; entity.Home_Left_Cate_Sort = Category.Cate_Sort; entity.Home_Left_Cate_Active = 1; entity.Home_Left_Cate_Site = Public.GetCurrentSite(); MyBLL.AddHomeLeftCate(entity, Public.GetUserPrivilege()); entity = null; LastCate = MyBLL.GetHomeLeftCateByLastID(Public.GetUserPrivilege()); if (LastCate != null) { if (LastCate.Home_Left_Cate_Name == Category.Cate_Name) { QueryInfo Query1 = new QueryInfo(); Query1.PageSize = 0; Query1.CurrentPage = 1; Query1.ParamInfos.Add(new ParamInfo("AND", "str", "CategoryInfo.Cate_Site", "=", Public.GetCurrentSite())); Query1.ParamInfos.Add(new ParamInfo("AND", "int", "CategoryInfo.Cate_ParentID", "=", Category.Cate_ID.ToString())); Query1.OrderInfos.Add(new OrderInfo("CategoryInfo.Cate_ID", "ASC")); IList <CategoryInfo> Categorys1 = MyCate.GetCategorys(Query1, Public.GetUserPrivilege()); if (Categorys1 != null) { foreach (CategoryInfo Category1 in Categorys1) { entity = new HomeLeftCateInfo(); entity.Home_Left_Cate_ParentID = LastCate.Home_Left_Cate_ID; entity.Home_Left_Cate_CateID = Category1.Cate_ID; entity.Home_Left_Cate_Name = Category1.Cate_Name; entity.Home_Left_Cate_URL = "/product/category.aspx?cate_id=" + Category1.Cate_ID; entity.Home_Left_Cate_Img = Category1.Cate_Img; entity.Home_Left_Cate_Sort = Category1.Cate_Sort; entity.Home_Left_Cate_Active = 1; entity.Home_Left_Cate_Site = Public.GetCurrentSite(); MyBLL.AddHomeLeftCate(entity, Public.GetUserPrivilege()); entity = null; LastCate1 = MyBLL.GetHomeLeftCateByLastID(Public.GetUserPrivilege()); if (LastCate1 != null) { if (LastCate1.Home_Left_Cate_Name == Category1.Cate_Name) { QueryInfo Query2 = new QueryInfo(); Query2.PageSize = 0; Query2.CurrentPage = 1; Query2.ParamInfos.Add(new ParamInfo("AND", "str", "CategoryInfo.Cate_Site", "=", Public.GetCurrentSite())); Query2.ParamInfos.Add(new ParamInfo("AND", "int", "CategoryInfo.Cate_ParentID", "=", Category1.Cate_ID.ToString())); Query2.OrderInfos.Add(new OrderInfo("CategoryInfo.Cate_ID", "ASC")); IList <CategoryInfo> Categorys2 = MyCate.GetCategorys(Query2, Public.GetUserPrivilege()); if (Categorys2 != null) { foreach (CategoryInfo Category2 in Categorys2) { entity = new HomeLeftCateInfo(); entity.Home_Left_Cate_ParentID = LastCate1.Home_Left_Cate_ID; entity.Home_Left_Cate_CateID = Category.Cate_ID; entity.Home_Left_Cate_Name = Category2.Cate_Name; entity.Home_Left_Cate_URL = "/product/category.aspx?cate_id=" + Category2.Cate_ID; entity.Home_Left_Cate_Img = Category2.Cate_Img; entity.Home_Left_Cate_Sort = Category2.Cate_Sort; entity.Home_Left_Cate_Active = 1; entity.Home_Left_Cate_Site = Public.GetCurrentSite(); MyBLL.AddHomeLeftCate(entity, Public.GetUserPrivilege()); entity = null; } } } } } } } } } } Public.Msg("positive", "操作成功", "操作成功", true, "homeleftcate_list.aspx"); }