public static void UpdateEntityByPropertySingle <T>(T obj, IEnumerable <string> fieldNames) where T : class
{
try
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
if (!fieldNames.Any())
{
return;
}
context.Set <T>().Attach(obj);
if (fieldNames != null)
{
foreach (var item in fieldNames)
{
context.Entry <T>(obj).Property(item).IsModified = true;
}
}
else
{
context.Entry <T>(obj).State = System.Data.Entity.EntityState.Modified;
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <T> AddEntities <T>(IList <T> objList) where T : class
{
InitalCreationTime <T>(objList);
InitalLastUpdateTime <T>(objList);
try
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
for (int i = 0; i < objList.Count; ++i)
{
context.Entry <T>(objList[i]).State = System.Data.Entity.EntityState.Added;
}
context.SaveChanges();
}
return(objList.ToList());
}
catch (Exception ex)
{
throw ex;
}
#region 查看 EntityValidationErrors 详细信息的解决方法
//catch (System.Data.Entity.Validation.DbEntityValidationException ex)
//{
// var msg = string.Empty;
// var errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList();
// foreach (var item in errors)
// msg += item.FirstOrDefault().ErrorMessage;
//}
#endregion 查看 EntityValidationErrors 详细信息的解决方法
}
public void DeleteRolePrivileges(List <WFRolePrivilege_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFRolePrivilege_Dto, WFRolePrivilege>();
DataWriter.DeleteEntities(datas);
}
}
public IList <WFUserRole_Dto> AddUserRoles(List <WFUserRole_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFUserRole_Dto, WFUserRole>();
return(DataWriter.AddEntities(datas)?.AutoMapList <WFUserRole, WFUserRole_Dto>());
}
}
public IList <WFCorporationTypeConfiguration_Dto> AddCorporationTypeConfiguration(List <WFCorporationTypeConfiguration_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFCorporationTypeConfiguration_Dto, WFCorporationTypeConfiguration>();
return(DataWriter.AddEntities(datas)?.AutoMapList <WFCorporationTypeConfiguration, WFCorporationTypeConfiguration_Dto>());
}
}
public IList <WFAccountEntity_Dto> AddAccountEntities(List <WFAccountEntity_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFAccountEntity_Dto, WFAccountEntity>();
return(DataWriter.AddEntities(datas)?.AutoMapList <WFAccountEntity, WFAccountEntity_Dto>());
}
}
public List <WFCommodityCategory_Dto> AddWFCommodityCategory(List <WFCommodityCategory_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFCommodityCategory_Dto, WFCommodityCategory>();
return(DataWriter.AddEntities(datas)?.AutoMapList <WFCommodityCategory, WFCommodityCategory_Dto>());
}
}
/// <summary>
/// 获取所有的
/// </summary>
/// <returns></returns>
public IList <WFCompany_Dto> GetAllExcahnges()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFCompany.Where(p => p.Type == (int)CorporationTypeFlag.Exchange).Where(p => !p.IsDeleted)?.ToList();
return(result.AutoMapList <WFCompany, WFCompany_Dto>());
}
}
/// <summary>
/// 获取所有的品类
/// </summary>
/// <returns></returns>
public IList <WFCommodityType_Dto> GetAllCommodityType()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFCommodityType?.ToList();
return(result.AutoMapList <WFCommodityType, WFCommodityType_Dto>());
}
}
public List <WFCommodityCategory_Dto> GetAllCommodityCategory()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFCommodityCategory?.ToList();
return(result.AutoMapList <WFCommodityCategory, WFCommodityCategory_Dto>());
}
}
public void DeleteCommodityType(List <WFCommodityType_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFCommodityType_Dto, WFCommodityType>();
DataWriter.DeleteEntities(datas);
}
}
public IList <WFCorporationTypeConfiguration_Dto> GetAllCorporationTypeConfiguration()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFCorporationTypeConfiguration.Where(p => !p.IsDeleted)?.ToList();
return(result.AutoMapList <WFCorporationTypeConfiguration, WFCorporationTypeConfiguration_Dto>());
}
}
/// <summary>
/// 获取所有的
/// </summary>
/// <returns></returns>
public IList <WFRolePrivilege_Dto> GetAllRolePrivilege()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFRolePrivilege?.ToList();
return(result.AutoMapList <WFRolePrivilege, WFRolePrivilege_Dto>());
}
}
public IList <WFOfficeAddress_Dto> GetAllOfficeAddress()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFOfficeAddress?.ToList();
return(result.AutoMapList <WFOfficeAddress, WFOfficeAddress_Dto>());
}
}
/// <summary>
/// 获取所有的用户角色信息
/// </summary>
/// <returns></returns>
public IList <WFUserRole_Dto> GetAllUserRoleInfo()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFUserRole?.ToList();
return(result.AutoMapList <WFUserRole, WFUserRole_Dto>());
}
}
public IList <WFOfficeAddress_Dto> AddOfficeAddress(List <WFOfficeAddress_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFOfficeAddress_Dto, WFOfficeAddress>();
return(DataWriter.AddEntities(datas)?.AutoMapList <WFOfficeAddress, WFOfficeAddress_Dto>());
}
}
public void UpdateRolesInfo(List <WFRoleInfo_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFRoleInfo_Dto, WFRoleInfo>();
DataWriter.UpdateEntities(datas);
}
}
public IList <WFInstrumentCategory_Dto> AddInstrument(List <WFInstrumentCategory_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFInstrumentCategory_Dto, WFInstrumentCategory>();
return(DataWriter.AddEntities(datas)?.AutoMapList <WFInstrumentCategory, WFInstrumentCategory_Dto>());
}
}
public void UpdateRoleInfoByModule(List <WFRoleInfo_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFRoleInfo_Dto, WFRoleInfo>();
DataWriter.UpdateEntityByProperty(datas, new PropertiesBuilder <WFRoleInfo>().Append(x => x.Module).Append(x => x.LastUpdateTime).PropertyNames);
}
}
public IList <WFAdditionalConfiguration_Dto> GetWFAdditionalConfiguration()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFAdditionalConfiguration?.ToList();
return(result.AutoMapList <WFAdditionalConfiguration, WFAdditionalConfiguration_Dto>());
}
}
public void DeletePosts(List <WFPost_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFPost_Dto, WFPost>();
DataWriter.DeleteEntities(datas);
}
}
public void UpdateAccountEntities(List <WFAccountEntity_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFAccountEntity_Dto, WFAccountEntity>();
DataWriter.UpdateEntities(datas);
}
}
/// <summary>
/// 获取所有的
/// </summary>
/// <returns></returns>
public IList <WFPost_Dto> GetAllPost()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFPost?.ToList();
return(result.AutoMapList <WFPost, WFPost_Dto>());
}
}
/// <summary>
/// 获取所有的
/// </summary>
/// <returns></returns>
public IList <WFAccountEntity_Dto> GetAllDepartment()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFAccountEntity.Where(p => !p.IsDeleted && !p.IsAccounting)?.ToList();
return(result.AutoMapList <WFAccountEntity, WFAccountEntity_Dto>());
}
}
/// <summary>
/// 获取所有的
/// </summary>
/// <returns></returns>
public IList <WFUser_Dto> GetAllUsers()
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var result = context.WFUser.Where(p => !p.IsDeleted)?.ToList();
return(result.AutoMapList <WFUser, WFUser_Dto>());
}
}
public void AddRolePrivileges(List <WFRolePrivilege_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFRolePrivilege_Dto, WFRolePrivilege>();
DataWriter.BulkInsertEntities(datas);//?.AutoMapList<WFRolePrivilege, WFRolePrivilege_Dto>();
}
}
public void DeleteAccountEntities(List <WFAccountEntity_Dto> dtos)
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
var datas = dtos.AutoMapList <WFAccountEntity_Dto, WFAccountEntity>();
DataWriter.UpdateEntityByProperty(datas, new PropertiesBuilder <WFAccountEntity>()
.Append(p => p.IsDeleted)
.Append(p => p.LastManipulationTime)
.PropertyNames
);
}
}
public static void DeleteEntities <T>(IList <T> objList) where T : class
{
InitalLastUpdateTime <T>(objList);
try
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
for (int i = 0; i < objList.Count; ++i)
{
context.Entry <T>(objList[i]).State = System.Data.Entity.EntityState.Deleted;
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void BulkInsertEntities <T>(IList <T> objList) where T : class
{
try
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
if (!context.Database.Exists())
{
context.Database.Create();
}
context.BulkInsert <T>(objList);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
