public override bool Update(BfCodeInfo item, DataBaseResource dbResource = DataBaseResource.Default)
{
bool updateResult = false;
using (TransactionScope scope = new TransactionScope())
{
updateResult = base.Update(item, dbResource);
if (item.BfCodeDtlInfoList != null)
{
item.BfCodeDtlInfoList.ForEach(o =>
{
o.BF_CODE_ID = item.ID;
if (o.ID == 0)
{
(new BfCodeDetailInfoDAL()).Insert(o, dbResource);
}
else
{
(new BfCodeDetailInfoDAL()).Update(o, dbResource);
}
});
}
scope.Complete();
}
return(updateResult);
}
public override int Insert(BfModuleInfo item, DataBaseResource dbResource = DataBaseResource.Default)
{
using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource)))
{
int mainId = 0;
using (TransactionScope scope = new TransactionScope())
{
mainId = base.Insert(item, dbResource);
if (item.OperationItems != null)
{
item.OperationItems.ForEach(n =>
{
n.BF_MODULE_ID = mainId;
(new BfModuleOperationDAL()).Insert(n, dbResource);
});
}
if (item.OtherOperationItems != null)
{
item.OtherOperationItems.ForEach(n =>
{
n.BF_MODULE_ID = mainId;
(new BfModuleOtherOperationDAL()).Insert(n, dbResource);
});
}
scope.Complete();
}
return(mainId);
}
}
public int DeleteByModuleID(int moduleID, DataBaseResource dbResource = DataBaseResource.Default)
{
using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource)))
{
var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQuery("BfModuleOperation.xml", "DeleteObjectByModuleID", moduleID);
return(i);
}
}
public override int Insert(UserTokenInfo item, DataBaseResource dbResource = DataBaseResource.Default)
{
using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource)))
{
DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQueryByEntity <UserTokenInfo>("UserToken", "AddObject", item);
return(item.USERID);
}
}
public int BatchImport(List <BfRegionInfo> entitys, DataBaseResource dbResource = DataBaseResource.Default)
{
if (entitys == null || entitys.Count < 1)
{
return(0);
}
using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource)))
{
var updateMainLst = new List <BfRegionInfo>();
var insertMainLst = new List <BfRegionInfo>();
var id = 0;
#region 组合主表新增及更新
foreach (var entity in entitys)
{
if (entity.ID > 0)
{
updateMainLst.Add(entity);
}
else
{
insertMainLst.Add(entity);
}
}
if (insertMainLst != null && insertMainLst.Count > 0)
{
id = GetEntityIdentity("BF_CODE", insertMainLst.Count);
foreach (var tmp in insertMainLst)
{
tmp.ID = id;
id++;
}
}
#endregion
MB.RuleBase.Common.DatabaseExecuteHelper.NewInstance.ExecuteWithTransaction((tran) =>
{
using (var bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute(tran))
{
bulk.WriteToServer("BfRegion", "AddObject", insertMainLst);
DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQueryByEntity(tran, "BfRegion", "UpdateObject", updateMainLst);
}
});
return(entitys.Count);
}
}
public override int Insert(BfOrgInfo item, DataBaseResource dbResource = DataBaseResource.Default)
{
using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource)))
{
int mainId = 0;
using (TransactionScope scope = new TransactionScope())
{
mainId = base.Insert(item, dbResource);
//if (item.OWNER_ID < 1)
//{
// item.OWNER_ID = mainId;
// base.Update(item, dbResource);
//}
scope.Complete();
}
return(mainId);
}
}
public override int Insert(BfCodeInfo item, DataBaseResource dbResource = DataBaseResource.Default)
{
using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource)))
{
int mainId = 0;
using (TransactionScope scope = new TransactionScope())
{
mainId = base.Insert(item, dbResource);
if (item.BfCodeDtlInfoList != null)
{
item.BfCodeDtlInfoList.ForEach(n =>
{
n.BF_CODE_ID = mainId;
(new BfCodeDetailInfoDAL()).Insert(n, dbResource);
});
}
scope.Complete();
}
return(mainId);
}
}
public int DeleteByModuleID(int moduleID, DataBaseResource dbResource = DataBaseResource.Default)
{
return(_da.DeleteByModuleID(moduleID, dbResource));
}
public override bool Update(BfModuleInfo item, DataBaseResource dbResource = DataBaseResource.Default)
{
bool updateResult = false;
using (TransactionScope scope = new TransactionScope())
{
updateResult = base.Update(item, dbResource);
var oldOperateList = (new BfModuleOperationDAL()).GetItems(new List <QueryParameterInfo>()
{
new QueryParameterInfo("BF_MODULE_ID", item.ID, DataFilterConditions.Equal)
});
if (item.OperationItems != null)
{
if (oldOperateList != null)
{
foreach (var operate in oldOperateList)
{
if (!item.OperationItems.Exists(p => p.CODE == operate.CODE))
{
//没有该操作，将删除
(new BfModuleOperationDAL()).Delete(operate.ID);
}
}
foreach (var operate in item.OperationItems)
{
if (!oldOperateList.Exists(p => p.CODE == operate.CODE))
{
//没有该操作，将新增
(new BfModuleOperationDAL()).Insert(operate, dbResource);
}
}
}
else
{
item.OperationItems.ForEach(o =>
{
o.BF_MODULE_ID = item.ID;
if (o.ID == 0)
{
(new BfModuleOperationDAL()).Insert(o, dbResource);
}
});
}
}
else
{
foreach (var operate in oldOperateList)
{
(new BfModuleOperationDAL()).Delete(operate.ID);
}
}
if (item.OtherOperationItems != null)
{
item.OtherOperationItems.ForEach(o =>
{
o.BF_MODULE_ID = item.ID;
if (o.ID == 0)
{
(new BfModuleOtherOperationDAL()).Insert(o, dbResource);
}
else
{
(new BfModuleOtherOperationDAL()).Update(o, dbResource);
}
});
}
scope.Complete();
}
return(updateResult);
}
