public int Insert(ArticleCategoryInfo model) { var parent = this.GetArticleCategoryById(model.ParentId); model.Id = KeyGenerator.Instance.GetNextValue("ArticleCategory"); using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertArticleCategory")) { cmd.SetParameterValue("@Id", model.Id); cmd.SetParameterValue("@Title", model.Title); cmd.SetParameterValue("@Name", model.Name); cmd.SetParameterValue("@UrlPath", model.UrlPath); cmd.SetParameterValue("@Keywords", model.Keywords); cmd.SetParameterValue("@MetaDesc", model.MetaDesc); cmd.SetParameterValue("@ParentId", model.ParentId); cmd.SetParameterValue("@MyLeft", parent.Lft); cmd.SetParameterValue("@Description", model.Description); cmd.SetParameterValue("@InUserId", model.InUserId); cmd.SetParameterValue("@InDate", model.InDate); cmd.SetParameterValue("@EditDate", model.EditDate); cmd.SetParameterValue("@EditUserId", model.EditUserId); cmd.SetParameterValue("@DisplayOrder", model.DisplayOrder); cmd.SetParameterValue("@DataStatus", model.DataStatus); cmd.SetParameterValue("@Type", model.CategoryType); return cmd.ExecuteNonQuery(); } }
public ArticleCategoryInfo GetArticleCategoryById(int id) { var model = new ArticleCategoryInfo(); using (DataCommand cmd = DataCommandManager.GetDataCommand("GetArticleCategoryById")) { cmd.SetParameterValue("@Id", id); using(IDataReader dr=cmd.ExecuteDataReader()) { while (dr.Read()) { model = this.GetModelFromDataReader(dr); } } } return model; }
public int Update(ArticleCategoryInfo model) { return _dataAccess.Update(model); }
public int Insert(ArticleCategoryInfo model) { return _dataAccess.Insert(model); }
public int UpdateArticleCategoryByCategoryId() { IArticleCategoryService articleCategoryService = new ArticleCategoryService(); var model = new ArticleCategoryInfo(); model.Id = Convert.ToInt32(HttpContext.Current.Request.Params["ArticleCategoryId"]); model.Title = HttpContext.Current.Request.Params["ArticleCategoryTitle"]; model.Name = HttpContext.Current.Request.Params["ArticleCategoryTitle"]; model.UrlPath = HttpContext.Current.Request.Params["UrlPath"]; model.Keywords = HttpContext.Current.Request.Params["ArticleCategoryKeywords"]; model.MetaDesc = HttpContext.Current.Request.Params["ArticleCategoryMetaDesc"]; //var parentId = HttpContext.Current.Request.Params["ParentArticleCategory"] ?? "0"; //model.ParentId = Convert.ToInt32(parentId); model.Description = HttpContext.Current.Request.Params["ArticleCategoryDesc"]; //model.InUserId = 0; //model.InDate = DateTime.Now; model.EditDate = DateTime.Now; model.EditUserId = 0; //model.DisplayOrder = OrderGenerator.NewOrder(); //model.DataStatus = 1; return articleCategoryService.Update(model); }
public List<ComboTree> GetComboTreeChildren2(ComboTree comboTree, ArticleCategoryInfo category, List<ArticleCategoryInfo> data) { var childrens = data.Where(s => s.Depth == category.Depth + 1 && s.Lft > category.Lft && s.Rgt < category.Rgt); var childs = new List<ComboTree>(); foreach (var productCategoryInfo in childrens) { var child = new ComboTree(); child.Id = productCategoryInfo.Id; child.Text = productCategoryInfo.Name; childs.Add(child); } comboTree.Children = childs; foreach (var child in comboTree.Children) { var temp = data.FirstOrDefault(s => s.Id == child.Id); if (temp != null) { this.GetComboTreeChildren2(child, temp, data); } } return comboTree.Children; }
private ArticleCategoryInfo GetModelFromDataReader(IDataReader dr) { var model = new ArticleCategoryInfo(); if (!Convert.IsDBNull(dr["Id"])) { model.Id = Convert.ToInt32(dr["Id"]); } if (!Convert.IsDBNull(dr["Title"])) { model.Title = dr["Title"].ToString(); } if (!Convert.IsDBNull(dr["Name"])) { model.Name = dr["Name"].ToString(); } if (!Convert.IsDBNull(dr["UrlPath"])) { model.UrlPath = dr["UrlPath"].ToString(); } if (!Convert.IsDBNull(dr["Keywords"])) { model.Keywords = dr["Keywords"].ToString(); } if (!Convert.IsDBNull(dr["MetaDesc"])) { model.MetaDesc = dr["MetaDesc"].ToString(); } if (!Convert.IsDBNull(dr["ParentId"])) { model.ParentId = Convert.ToInt32(dr["ParentId"]); } if (!Convert.IsDBNull(dr["Lft"])) { model.Lft = Convert.ToInt32(dr["Lft"]); } if (!Convert.IsDBNull(dr["Rgt"])) { model.Rgt = Convert.ToInt32(dr["Rgt"]); } if (!Convert.IsDBNull(dr["Depth"])) { model.Depth = Convert.ToInt32(dr["Depth"]); } if (!Convert.IsDBNull(dr["Description"])) { model.Description = dr["Description"].ToString(); } if (!Convert.IsDBNull(dr["InUserId"])) { model.InUserId = Convert.ToInt32(dr["InUserId"]); } if (!Convert.IsDBNull(dr["InDate"])) { model.InDate = Convert.ToDateTime(dr["InDate"]); } if (!Convert.IsDBNull(dr["EditDate"])) { model.EditDate = Convert.ToDateTime(dr["EditDate"]); } if (!Convert.IsDBNull(dr["EditUserId"])) { model.EditUserId = Convert.ToInt32(dr["EditUserId"]); } if (!Convert.IsDBNull(dr["DisplayOrder"])) { model.DisplayOrder = Convert.ToInt64(dr["DisplayOrder"]); } if (!Convert.IsDBNull(dr["DataStatus"])) { model.DataStatus = Convert.ToInt32(dr["DataStatus"]); } if (!Convert.IsDBNull(dr["Type"])) { model.CategoryType = Convert.ToInt32(dr["Type"]); } return model; }
public int Update(ArticleCategoryInfo model) { using(DataCommand cmd=DataCommandManager.GetDataCommand("UpdateArticleCategoryById")) { cmd.SetParameterValue("@Id", model.Id); cmd.SetParameterValue("@Title", model.Title); cmd.SetParameterValue("@Name", model.Name); cmd.SetParameterValue("@UrlPath", model.UrlPath); cmd.SetParameterValue("@Keywords", model.Keywords); cmd.SetParameterValue("@MetaDesc", model.MetaDesc); cmd.SetParameterValue("@Description", model.Description); cmd.SetParameterValue("@EditDate", model.EditDate); cmd.SetParameterValue("@EditUserId", model.EditUserId); return cmd.ExecuteNonQuery(); } }