private int UpdateSubItemCategories(string parentId)
{
ItemCategoryFacade localFacade = new ItemCategoryFacade();
localFacade.DeleteItemCategoryByParentId(parentId);
CategoryFacade topFacade = new CategoryFacade(varHelper.TOP_AppKey, varHelper.TOP_AppSecret);
TOPDataList <ItemCategory> list = topFacade.GetItemCategories(parentId, string.Empty);
foreach (ItemCategory category in list)
{
if (!localFacade.IsItemCategoryExist(category.Id))
{
localFacade.AddItemCategory(string.Empty, category.Id, category.ParentId, category.Name, category.IsParent, category.Status, category.SortOrder);
}
}
return(list.Count);
}
public void TestAddItemCategory_正确添加()
{
string id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
#region 验证前置条件
MSSql2005Query query = new MSSql2005Query();
string sqlQuery = query.GenerateSelectViewSql(typeof(ItemCategoryInfo));
sqlQuery += string.Format("WHERE [Id] = N'{0}'", id);
using (DbOperator dbOperator = new DbOperator(connString))
{
DataTable dt = dbOperator.GetTable(sqlQuery);
Assert.AreEqual(0, dt.Rows.Count);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
string idNew = facade.AddItemCategory(id, "50011665", "0", "网游装备/游戏币/帐号/代练", false, "normal", 0);
#region 验证后置条件
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", idNew, true);
using (DbOperator dbOperator = new DbOperator(connString))
{
DataTable dt = dbOperator.GetTable(sqlQuery);
Assert.AreEqual(1, dt.Rows.Count);
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", dt.Rows[0]["Id"].ToString(), true);
Assert.AreEqual("50011665", dt.Rows[0]["CategoryId"].ToString(), true);
Assert.AreEqual("0", dt.Rows[0]["ParentId"].ToString(), true);
Assert.AreEqual("网游装备/游戏币/帐号/代练", dt.Rows[0]["Name"].ToString(), true);
Assert.AreEqual("false", dt.Rows[0]["IsParent"].ToString(), true);
Assert.AreEqual("normal", dt.Rows[0]["Status"].ToString(), true);
Assert.AreEqual("0", dt.Rows[0]["SortOrder"].ToString(), true);
}
#endregion
}