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();
}
}
