public string CreateTemplate(string name, string content, string userId)
{
string id = Guid.NewGuid().ToString();
TOP.Template.Domain.Template template = new TOP.Template.Domain.Template();
template.Name = name;
template.Content = content;
template.CreateUserId = userId;
template.LastUpdateUserId = userId;
#region 执行SQL以创建对象
TemplateManager manager = new TemplateManager();
string sqlCreate = manager.GetCreateSql(template);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlCreate);
dbOperator.CommintTran();
return id;
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("创建模板发生异常 - ", ex);
}
}
#endregion
}
public List<TemplateInfo> GetTemplateInfoListByUserId(string userId)
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(TemplateInfo));
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
return TransferList<TemplateInfo>(dt);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string value = tvSchema.SelectedNode.Value;
if (value != "table" && value != "view")
{
Type type = Type.GetType(value);
string dbTypeId = ConfigurationManager.AppSettings["DbType"];
TOP.Common.DbHelper.DbType dbType = (TOP.Common.DbHelper.DbType)short.Parse(dbTypeId);
string connString = ConfigurationManager.AppSettings["ConnString"];
string sqlDrop = string.Empty;
string sqlCreate = string.Empty;
string parent = tvSchema.SelectedNode.Parent.Value;
if (parent.Equals("Table", StringComparison.OrdinalIgnoreCase))
{
DbSqlCreater dbSqlCreater = DbSqlCreater.GetDbSqlCreater(dbType);
sqlDrop = dbSqlCreater.GenerateDropTableSql(type);
sqlCreate = dbSqlCreater.GenerateCreateTableSql(type);
}
else if (parent.Equals("View", StringComparison.OrdinalIgnoreCase))
{
string baseDir = Server.MapPath("~");
baseDir += @"\..\..\Database\Scripts";
DbQuery dbQuery = DbQuery.GetDbQuery(dbType);
sqlDrop = dbQuery.GenerateDropViewSql(type, baseDir);
sqlCreate = dbQuery.GenerateCreateViewSql(type, baseDir);
}
else
{
throw new ArgumentException("不能更新的类型 - " + parent + " - " + value);
}
using (DbOperator dbOperator = new DbOperator(connString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlDrop);
dbOperator.ExecSql(sqlCreate);
dbOperator.CommintTran();
lblMessage.Text = "更新成功 - " + parent + " - " + value;
}
catch
{
dbOperator.RollbackTran();
throw new Exception("更新数据库对象错误 - " + parent + " - " + value);
}
}
}
else
{
lblMessage.Text = "所选择对象无效，请选择要更新的数据库对象。";
}
}
public void DeleteItemCategoryByParentId(string categoryId)
{
ItemCategory category = new ItemCategory();
ItemCategoryManager manager = new ItemCategoryManager();
string sqlDelete = manager.GetDeleteSql(category);
sqlDelete += string.Format("WHERE [ParentId] = N'{0}'", categoryId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
dbOperator.ExecSql(sqlDelete);
}
}
public string AddArea(string id, string areaId, string areaTypeId, string areaName, string parentId, string zip, string createUserId)
{
#region 构造要新增的对象
if (string.IsNullOrEmpty(id) || id == Guid.Empty.ToString())
{
id = Guid.NewGuid().ToString();
}
Area area = new Area();
area.Id = id;
area.AreaId = areaId;
area.AreaTypeId = areaTypeId;
area.AreaName = areaName;
area.ParentId = parentId;
area.Zip = zip;
area.CreateDate = DateTime.Now;
area.CreateUserId = createUserId;
area.LastUpdateDate = DateTime.Now;
area.LastUpdateUserId = createUserId;
#endregion
#region 执行SQL以创建对象
AreaManager manager = new AreaManager();
string sqlCreate = manager.GetCreateSql(area);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlCreate);
dbOperator.CommintTran();
return id;
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("新增区域发生异常 - ", ex);
}
}
#endregion
}
public TemplateContentInfo GetTemplateContentById(string templateId)
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(TemplateContentInfo));
sqlSelect += string.Format(" WHERE [Id] = '{0}'", templateId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
if (dt.Rows.Count > 0)
{
return TransferInfo<TemplateContentInfo>(dt.Rows[0]);
}
else
{
return null;
}
}
}
public ItemCategoryInfo GetItemCategoryById(string categoryId)
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(ItemCategoryInfo));
sqlSelect += string.Format("WHERE [CategoryId] = N'{0}'", categoryId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
if (dt.Rows.Count > 0)
{
return TransferInfo<ItemCategoryInfo>(dt.Rows[0]);
}
else
{
return null;
}
}
}
/// <summary>
/// 登录，并返回登录用户。如果登录失败，则返回null。
/// </summary>
/// <param name="loginName">登录名</param>
/// <param name="password">加密后的密码</param>
/// <returns></returns>
public UserInfo Login(string loginName, string password)
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(UserInfo));
sqlSelect += string.Format("WHERE [LoginName] = N'{0}' AND [Password] = N'{1}'", loginName, password);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
if (dt.Rows.Count > 0)
{
return TransferInfo<UserInfo>(dt.Rows[0]);
}
else
{
return null;
}
}
}
public void AddImportGroup(string groupId, string operatorUserId, string operatorUserName, int totalCount
, string fromNick, string fromTitle, string fromImageUrl, string toNick, string toTitle
, ImportorEnumerations.ImportType importType, string userId)
{
ImportGroup groupEntity = new ImportGroup();
groupEntity.Id = groupId;
groupEntity.OperatorUserId = operatorUserId;
groupEntity.OperatorUserName = operatorUserName;
groupEntity.TotalCount = totalCount;
groupEntity.SuccessCount = 0;
groupEntity.FailCount = 0;
groupEntity.ImportFormSellerNick = fromNick;
groupEntity.ImportFormShopTitle = fromTitle;
groupEntity.ImportFormShopImageUrl = fromImageUrl;
groupEntity.ImportToSellerNick = toNick;
groupEntity.ImportToShopTitle = toTitle;
groupEntity.ImportType = importType;
groupEntity.ImportState = ImportorEnumerations.ImportState.Waitting;
groupEntity.ImportResult = ImportorEnumerations.ImportGroupResult.Pending;
groupEntity.ListDateTime = DateTime.Now;
groupEntity.StartDateTime = null;
groupEntity.FinishDateTime = null;
groupEntity.CreateDate = DateTime.Now;
groupEntity.CreateUserId = userId;
groupEntity.LastUpdateDate = DateTime.Now;
groupEntity.LastUpdateUserId = userId;
ImportGroupManager groupManager = new ImportGroupManager();
string sqlCreateGroup = groupManager.GetCreateSql(groupEntity);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlCreateGroup);
dbOperator.CommintTran();
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("添加导入组发生异常 - ", ex);
}
}
}
public string AddItemCategory(string id, string categoryId, string parentId, string name, bool isParent, string status, int sortOrder)
{
#region 构造要新增的对象
if (string.IsNullOrEmpty(id) || id == Guid.Empty.ToString())
{
id = Guid.NewGuid().ToString();
}
ItemCategory category = new ItemCategory();
category.Id = id;
category.CategoryId = categoryId;
category.ParentId = parentId;
category.Name = name;
category.IsParent = isParent;
category.Status = status;
category.SortOrder = sortOrder;
#endregion
#region 执行SQL以创建对象
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate = manager.GetCreateSql(category);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlCreate);
dbOperator.CommintTran();
return id;
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("新增类目发生异常 - ", ex);
}
}
#endregion
}
public void DbInitialize()
{
string sqlDropTable = dbSqlCreater.GenerateDropTableSql(typeof(Area));
string sqlCreateTable = dbSqlCreater.GenerateCreateTableSql(typeof(Area));
using (DbOperator dbOperator = new DbOperator(connString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlDropTable);
dbOperator.ExecSql(sqlCreateTable);
dbOperator.CommintTran();
}
catch (Exception ex)
{
dbOperator.RollbackTran();
Assert.Fail("初始化数据库错误 - " + ex.Message);
}
}
}
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
}
public void TestAddArea_正确添加区域()
{
string id = "c2ecf0ef-dc5b-4308-9f38-037453d53919";
#region 验证前置条件
MSSql2005Query query = new MSSql2005Query();
string sqlQuery = query.GenerateSelectViewSql(typeof(AreaInfo));
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
AreaFacade facade = new AreaFacade();
string idNew = facade.AddArea(id, "401331", AreaType.Province, "重庆市", "", "401331");
#region 验证后置条件
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-037453d53919", 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-037453d53919", dt.Rows[0]["Id"].ToString(), true);
Assert.AreEqual("401331", dt.Rows[0]["AreaId"].ToString(), true);
Assert.AreEqual("2", dt.Rows[0]["AreaType"].ToString(), true);
Assert.AreEqual("重庆市", dt.Rows[0]["AreaName"].ToString(), true);
Assert.AreEqual("", dt.Rows[0]["ParentId"].ToString(), true);
Assert.AreEqual("401331", dt.Rows[0]["Zip"].ToString(), true);
}
#endregion
}
/// <summary>
/// 注册新用户。返回用户Id。
/// </summary>
/// <param name="id"></param>
/// <param name="loginName">登录名</param>
/// <param name="password">加密后的密码</param>
/// <param name="userName">用户名</param>
/// <returns></returns>
public string Register(string id, string loginName, string password, string userName)
{
#region 构造要新增的对象
if (string.IsNullOrEmpty(id) || id == Guid.Empty.ToString())
{
id = Guid.NewGuid().ToString();
}
User _user = new User();
_user.Id = id;
_user.LoginName = loginName;
_user.Password = password;
_user.UserName = userName;
#endregion
#region 执行SQL以创建对象
UserManager manager = new UserManager();
string sqlCreate = manager.GetCreateSql(_user);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlCreate);
dbOperator.CommintTran();
return id;
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("注册用户发生异常 - ", ex);
}
}
#endregion
}
public void StartImport(string groupId, int version, string userId)
{
ImportGroup groupEntity = new ImportGroup();
groupEntity.Id = groupId;
groupEntity.ImportState = ImportorEnumerations.ImportState.Importing;
groupEntity.LastUpdateDate = DateTime.Now;
groupEntity.LastUpdateUserId = userId;
groupEntity.CurrentVersion = version;
#region 执行SQL以修改对象
ImportGroupManager manager = new ImportGroupManager();
string sqlUpdate = manager.GetUpdateSql(groupEntity, "ImportState");
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlUpdate);
dbOperator.CommintTran();
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("启动导入过程发生异常 - ", ex);
}
}
#endregion
}
public void StartImportItem(string itemId, int version, string userId)
{
ImportItem itemEntity = new ImportItem();
itemEntity.Id = itemId;
itemEntity.ImportState = ImportorEnumerations.ImportState.Importing;
itemEntity.StartDateTime = DateTime.Now;
itemEntity.LastUpdateDate = DateTime.Now;
itemEntity.LastUpdateUserId = userId;
itemEntity.CurrentVersion = version;
ImportItemManager manager = new ImportItemManager();
string sqlUpdateItem = manager.GetUpdateSql(itemEntity, "ImportState", "StartDateTime");
#region 执行SQL以修改对象
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlUpdateItem);
dbOperator.CommintTran();
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("启动导入宝贝发生异常 - ", ex);
}
}
#endregion
}
public List<ItemCategoryInfo> GetItemCategoryListByParent(string parentId)
{
if (string.IsNullOrEmpty(parentId))
{
parentId = "0";
}
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(ItemCategoryInfo));
sqlSelect += string.Format("WHERE [ParentId] = N'{0}' ", parentId);
sqlSelect += "ORDER BY [SortOrder] ASC";
using (DbOperator dbOperator = new DbOperator(ConnString))
{
List<ItemCategoryInfo> list = new List<ItemCategoryInfo>();
DataTable dt = dbOperator.GetTable(sqlSelect);
foreach (DataRow row in dt.Rows)
{
list.Add(TransferInfo<ItemCategoryInfo>(row));
}
return list;
}
}
public void TestGetItemCategoryListByParent_有一条根数据()
{
#region 验证前置条件
ItemCategory category = new ItemCategory();
category.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
category.CategoryId = "50011665";
category.Name = "测试类目";
category.ParentId = "0";
category.IsParent = true;
category.SortOrder = 1;
category.Status = "normal";
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate = manager.GetCreateSql(category);
using (DbOperator dbOperator = new DbOperator(connString))
{
dbOperator.ExecSql(sqlCreate);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
List<ItemCategoryInfo> list = facade.GetItemCategoryListByParent(string.Empty);
#region 验证后置条件
Assert.AreEqual(1, list.Count);
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", list[0].Id);
Assert.AreEqual("50011665", list[0].CategoryId);
Assert.AreEqual("测试类目", list[0].Name);
Assert.AreEqual("0", list[0].ParentId);
Assert.AreEqual(true, list[0].IsParent);
Assert.AreEqual(1, list[0].SortOrder);
Assert.AreEqual("normal", list[0].Status);
#endregion
}
public void AddImportItem(string itemId, string groupId, string operatorUserId, string operatorUserName
, string fromItemIid, string fromItemTitle, string fromItemPrice, string fromSellerNick, string fromShopTitle, string userId)
{
ImportItem itemEntity = new ImportItem();
itemEntity.Id = itemId;
itemEntity.OperatorUserId = operatorUserId;
itemEntity.OperatorUserName = operatorUserName;
itemEntity.ItsImportGroupId = groupId;
itemEntity.ImportFormItemIid = fromItemIid;
itemEntity.ImportFormItemTitle = fromItemTitle;
itemEntity.ImportFormItemPrice = fromItemPrice;
itemEntity.ImportFormSellerNick = fromSellerNick;
itemEntity.ImportFormShopTitle = fromShopTitle;
itemEntity.ImportState = ImportorEnumerations.ImportState.Waitting;
itemEntity.ImportResult = ImportorEnumerations.ImportItemResult.Pending;
itemEntity.ListDateTime = DateTime.Now;
itemEntity.StartDateTime = null;
itemEntity.FinishDateTime = null;
itemEntity.CreateDate = DateTime.Now;
itemEntity.CreateUserId = userId;
itemEntity.LastUpdateDate = DateTime.Now;
itemEntity.LastUpdateUserId = userId;
ImportItemManager itemManager = new ImportItemManager();
string sqlCreateItem = itemManager.GetCreateSql(itemEntity);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlCreateItem);
dbOperator.CommintTran();
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("添加导入项发生异常 - ", ex);
}
}
}
public List<AreaInfo> GetAllProvinceAreaList()
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(AreaInfo));
sqlSelect += string.Format("WHERE [AreaType] = N'{0}'", (int)AreaType.Province);
sqlSelect += " ORDER BY [AreaId]";
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
List<AreaInfo> list = new List<AreaInfo>();
foreach (DataRow row in dt.Rows)
{
list.Add(TransferInfo<AreaInfo>(row));
}
return list;
}
}
public void TestGetItemCategory_已经存在的情况()
{
#region 验证前置条件
ItemCategory category = new ItemCategory();
category.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
category.CategoryId = "50011665";
category.Name = "测试类目";
category.ParentId = "0";
category.IsParent = true;
category.SortOrder = 1;
category.Status = "normal";
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate = manager.GetCreateSql(category);
using (DbOperator dbOperator = new DbOperator(connString))
{
dbOperator.ExecSql(sqlCreate);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
ItemCategoryInfo categoryInfo = facade.GetItemCategoryById("50011665");
#region 验证后置条件
Assert.IsNotNull(categoryInfo);
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", categoryInfo.Id);
Assert.AreEqual("50011665", categoryInfo.CategoryId);
Assert.AreEqual("测试类目", categoryInfo.Name);
Assert.AreEqual("0", categoryInfo.ParentId);
Assert.AreEqual(true, categoryInfo.IsParent);
Assert.AreEqual(1, categoryInfo.SortOrder);
Assert.AreEqual("normal", categoryInfo.Status);
#endregion
}
public void UpdateArea(string areaId, string areaTypeId, string areaName, string parentId, string zip, string updateUserId)
{
#region 构造要修改的对象
Area area = new Area();
area.AreaTypeId = areaTypeId;
area.AreaName = areaName;
area.ParentId = parentId;
area.Zip = zip;
area.LastUpdateDate = DateTime.Now;
area.LastUpdateUserId = updateUserId;
#endregion
#region 执行SQL以修改对象
AreaManager manager = new AreaManager();
string sqlUpdate = manager.GetUpdateSql(area);
sqlUpdate += string.Format("WHERE [AreaId] = N'{0}'", areaTypeId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
try
{
dbOperator.BeginTran();
dbOperator.ExecSql(sqlUpdate);
dbOperator.CommintTran();
}
catch (Exception ex)
{
dbOperator.RollbackTran();
throw new FacadeException("修改区域发生异常 - ", ex);
}
}
#endregion
}
public void TestGetItemCategoryListByParent_父子数据情况()
{
#region 验证前置条件
ItemCategory category1 = new ItemCategory();
category1.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
category1.CategoryId = "50011665";
category1.Name = "测试类目1";
category1.ParentId = "0";
category1.IsParent = true;
category1.SortOrder = 1;
category1.Status = "normal";
ItemCategory category2 = new ItemCategory();
category2.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53929";
category2.CategoryId = "50011667";
category2.Name = "测试类目2";
category2.ParentId = "50011665";
category2.IsParent = true;
category2.SortOrder = 0;
category2.Status = "deleted";
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate1 = manager.GetCreateSql(category1);
string sqlCreate2 = manager.GetCreateSql(category2);
using (DbOperator dbOperator = new DbOperator(connString))
{
dbOperator.ExecSql(sqlCreate1);
dbOperator.ExecSql(sqlCreate2);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
#region 验证后置条件
List<ItemCategoryInfo> list1 = facade.GetItemCategoryListByParent(string.Empty);
Assert.AreEqual(1, list1.Count);
ItemCategoryInfo categoryInfo1 = list1[0];
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", categoryInfo1.Id);
Assert.AreEqual("50011665", categoryInfo1.CategoryId);
Assert.AreEqual("测试类目1", categoryInfo1.Name);
Assert.AreEqual("0", categoryInfo1.ParentId);
Assert.AreEqual(true, categoryInfo1.IsParent);
Assert.AreEqual(1, categoryInfo1.SortOrder);
Assert.AreEqual("normal", categoryInfo1.Status);
List<ItemCategoryInfo> list2 = facade.GetItemCategoryListByParent("50011665");
ItemCategoryInfo categoryInfo2 = list2[0];
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53929", categoryInfo2.Id);
Assert.AreEqual("50011667", categoryInfo2.CategoryId);
Assert.AreEqual("测试类目2", categoryInfo2.Name);
Assert.AreEqual("50011665", categoryInfo2.ParentId);
Assert.AreEqual(true, categoryInfo2.IsParent);
Assert.AreEqual(0, categoryInfo2.SortOrder);
Assert.AreEqual("deleted", categoryInfo2.Status);
#endregion
}
public bool IsHasChildren(string parentId)
{
string sqlSelect = sqlHelper.GenerateCountViewSql(typeof(AreaInfo));
sqlSelect += string.Format("WHERE [ParentId] = N'{0}'", parentId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
return (int)dt.Rows[0]["RowCount"] > 0;
}
}
public bool IsAreaExist(string areaId)
{
string sqlCheck = sqlHelper.GenerateCountViewSql(typeof(AreaInfo));
sqlCheck += string.Format("WHERE [AreaId] = N'{0}'", areaId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlCheck);
return (int)dt.Rows[0]["RowCount"] > 0;
}
}
public List<ImportItemInfo> GetImportItemList(string groupId)
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(ImportItemInfo));
sqlSelect += string.Format("WHERE [ItsImportGroupId] = N'{0}'", groupId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
return TransferList<ImportItemInfo>(dt);
}
}
public List<ImportItemInfo> GetImportItemList(string groupId, int pageIndex, int pageSize)
{
int start = pageIndex * pageSize + 1;
int end = start + pageSize - 1;
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(ImportItemInfo));
sqlSelect += string.Format("WHERE [ItsImportGroupId] = N'{0}'", groupId);
sqlSelect = "SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY [LastUpdateDate] DESC) AS [RowNum] FROM ("
+ sqlSelect
+ string.Format(") AS [MyTable]) AS [T1] WHERE [T1].[RowNum] BETWEEN {0} AND {1}", start, end);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
return TransferList<ImportItemInfo>(dt);
}
}
public bool IsItemCategoryExist(string categoryId)
{
string sqlCheck = sqlHelper.GenerateCountViewSql(typeof(ItemCategoryInfo));
sqlCheck += string.Format("WHERE [CategoryId] = N'{0}'", categoryId);
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlCheck);
int i = (int)dt.Rows[0][0];
return i > 0;
}
}
public List<AreaInfo> GetAllRootAreaList()
{
string sqlSelect = sqlHelper.GenerateSelectViewSql(typeof(AreaInfo));
sqlSelect += "WHERE [ParentId] = N'0'";
sqlSelect += " ORDER BY [AreaId]";
using (DbOperator dbOperator = new DbOperator(ConnString))
{
DataTable dt = dbOperator.GetTable(sqlSelect);
List<AreaInfo> list = new List<AreaInfo>();
foreach (DataRow row in dt.Rows)
{
list.Add(TransferInfo<AreaInfo>(row));
}
return list;
}
}
public void TestIsItemCategoryExist_已经存在的情况()
{
#region 验证前置条件
ItemCategory category = new ItemCategory();
category.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
category.CategoryId = "50011665";
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate = manager.GetCreateSql(category);
using (DbOperator dbOperator = new DbOperator(connString))
{
dbOperator.ExecSql(sqlCreate);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
bool isExist = facade.IsItemCategoryExist("50011665");
Assert.AreEqual(true, isExist);
}