/// <summary>
/// 是否存在
/// </summary>
/// <param name="anyLambda">查询表达式</param>
/// <returns>布尔值</returns>
public bool Exist <T>(Expression <Func <T, bool> > anyLambda) where T : class
{
using (CommonEntities db = new CommonEntities())
{
return(db.Set <T>().Any(anyLambda));
}
}
/// <summary>
/// 查询sql语句（单条）
/// </summary>
/// <param name="sql">sql</param>
/// <param name="entity">数据实体</param>
/// <returns>数据</returns>
public T QueryFirstSql <T>(string sql) where T : class
{
using (CommonEntities db = new CommonEntities())
{
return(db.Database.SqlQuery <T>(sql).FirstOrDefault());
}
}
////INSERT- UPDATE - DELETE
public int Insert(int PortalId, int ContentItemId, string CultureCode, string RouteName, string RouteUrl, string PhysicalFile,
bool CheckPhysicalUrlAccess, string RouteValueDictionary, string Description, bool Discontinued)
{
int returnValue = 0;
using (CommonEntities dbContext = new CommonEntities())
{
using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope())
{
int ListOrder = (from u in dbContext.aspnet_Routes select u.ListOrder).DefaultIfEmpty(0).Max() + 1;
aspnet_Routes entity = new aspnet_Routes();
entity.PortalId = PortalId;
entity.ContentItemId = ContentItemId;
entity.CultureCode = CultureCode;
entity.RouteName = RouteName;
entity.RouteUrl = RouteUrl;
entity.PhysicalFile = PhysicalFile;
entity.CheckPhysicalUrlAccess = CheckPhysicalUrlAccess;
entity.RouteValueDictionary = RouteValueDictionary;
entity.Description = Description;
entity.ListOrder = ListOrder;
entity.Discontinued = Discontinued;
dbContext.AddToaspnet_Routes(entity);
returnValue = dbContext.SaveChanges();
dbContext.Connection.Close();
transcope.Complete();
}
}
return(returnValue);
}
public int Update(int RouteId, int PortalId, int ContentItemId, string CultureCode, string RouteName, string RouteUrl, string PhysicalFile,
bool CheckPhysicalUrlAccess, string RouteValueDictionary, string Description, bool Discontinued)
{
int i = 0;
using (CommonEntities dbContext = new CommonEntities())
{
using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope())
{
dbContext.Connection.Open();
aspnet_Routes entity = dbContext.aspnet_Routes.Single(x => x.RouteId == RouteId);
entity.PortalId = PortalId;
entity.ContentItemId = ContentItemId;
entity.CultureCode = CultureCode;
entity.RouteName = RouteName;
entity.RouteUrl = RouteUrl;
entity.PhysicalFile = PhysicalFile;
entity.CheckPhysicalUrlAccess = CheckPhysicalUrlAccess;
entity.RouteValueDictionary = RouteValueDictionary;
entity.Description = Description;
entity.Discontinued = Discontinued;
i = dbContext.SaveChanges();
dbContext.Connection.Close();
transcope.Complete();
}
}
return(i);
}
/// <summary>
/// 查询数据列表
/// </summary>
/// <param name="whereLambda">查询表达式</param>
/// <returns>数据列表</returns>
public List <T> QueryList <T>(Expression <Func <T, bool> > whereLambda) where T : class
{
using (CommonEntities db = new CommonEntities())
{
return(db.Set <T>().Where(whereLambda).ToList());
}
}
/// <summary>
/// 查询数据
/// </summary>
/// <param name="Lambda">表达式</param>
/// <returns>数据实体</returns>
public T Query <T>(Expression <Func <T, bool> > whereLambda) where T : class
{
using (CommonEntities db = new CommonEntities())
{
return(db.Set <T>().FirstOrDefault(whereLambda));
}
}
/// <summary>
/// 查询sql语句(集合)
/// </summary>
/// <param name="sql">sql</param>
/// <param name="entity">数据实体</param>
/// <returns>数据列表</returns>
public List <T> QueryListSql <T>(string sql) where T : class
{
using (CommonEntities db = new CommonEntities())
{
return(db.Database.SqlQuery <T>(sql).ToList());
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">数据实体</param>
/// <returns>实体</returns>
public T InsertReturnEntity <T>(T entity) where T : class
{
using (CommonEntities db = new CommonEntities())
{
db.Entry <T>(entity).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
return(entity);
}
}
public aspnet_Routes GetDetails(int RouteId)
{
using (CommonEntities dbContext = new CommonEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
aspnet_Routes entity = dbContext.aspnet_Routes.Where(x => x.RouteId == RouteId).FirstOrDefault();
return(entity);
}
}
public int UpdateStatus(int RouteId, bool Discontinued)
{
using (CommonEntities dbContext = new CommonEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
aspnet_Routes entity = dbContext.aspnet_Routes.Single(x => x.RouteId == RouteId);
entity.Discontinued = Discontinued;
int i = dbContext.SaveChanges();
return(i);
}
}
public int UpdateSortKey(int RouteId, int ListOrder)
{
using (CommonEntities dbContext = new CommonEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
aspnet_Routes album_obj = dbContext.aspnet_Routes.Single(x => x.RouteId == RouteId);
album_obj.ListOrder = ListOrder;
int i = dbContext.SaveChanges();
return(i);
}
}
public List <MiscCombo> GetMiscCombo(MiscCriteria criteria)
{
using (CommonEntities Context = new CommonEntities())
{
var result = Context.GetMiscCombo(
fieldName: criteria.FieldName
, isActive: criteria.IsActive
).ToList();
return(result);
}
}
public List <GroupCombo> GetGroupCombo(GroupCriteriaCombo criteria)
{
using (CommonEntities Context = new CommonEntities())
{
var result = Context.GetGroupCombo(
prodDate: criteria.prodDate
//, groupCode: criteria.GroupCode
, userCode: criteria.UserCode
).ToList();
return(result);
}
}
public List <EmpComboResult> GetEmp(EmpCriteria criteria)
{
using (CommonEntities Context = new CommonEntities())
{
var result = Context.GetEmpCombo(
prodDateFrom: criteria.ProdDateFrom
, prodDateTo: criteria.ProdDateTo
, empCode: criteria.EmpCode
, isActiveOnly: criteria.IsActiveOnly
).ToList();
return(result);
}
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="name">存储过程名称</param>
/// <param name="para">参数</param>
public int execproc(string name, string word, SqlParameter[] para)
{
using (CommonEntities db = new CommonEntities())
{
try
{
return(db.Database.ExecuteSqlCommand(name + " " + word, para));
}
catch (Exception)
{
return(-1024);
}
}
}
public static void Delete(int RouteId)
{
using (CommonEntities dbContext = new CommonEntities())
{
using (System.Transactions.TransactionScope transcope = new System.Transactions.TransactionScope())
{
dbContext.Connection.Open();
aspnet_Routes entity = dbContext.aspnet_Routes.Single(x => x.RouteId == RouteId);
dbContext.aspnet_Routes.DeleteObject(entity);
dbContext.SaveChanges();
dbContext.Connection.Close();
transcope.Complete();
}
}
}
public List <DivisionCombo> GetDivisionCombo(DivisionCriteriaCombo criteria)
{
using (CommonEntities Context = new CommonEntities())
{
var result = Context.GetDivisionCombo(
prodDate: criteria.ProdDate
, prodDateFrom: criteria.ProdDateFrom
, prodDateTo: criteria.ProdDateTo
, divCodeKey: criteria.DivCodeKey
, userCode: criteria.userCode
, isActiveOnly: criteria.IsActiveOnly
).ToList();
return(result);
}
}
public static List <aspnet_Routes> GetListByPortalIdCultureCodeStatus(int PortalId, int ContentItemId, string CultureCode, bool Discontinued)
{
using (CommonEntities dbContext = new CommonEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
var query = from x in dbContext.aspnet_Routes
where x.PortalId == PortalId &&
x.CultureCode == CultureCode &&
x.Discontinued == Discontinued
select x;
if (!string.IsNullOrEmpty(ContentItemId.ToString()) && ContentItemId > 0)
{
query = query.Where(x => x.ContentItemId == ContentItemId);
}
return(query.ToList());
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">数据实体</param>
/// <returns>布尔值</returns>
public bool Insert(T entity)
{
bool result = false;
using (CommonEntities db = new CommonEntities())
{
db.Entry <T>(entity).State = System.Data.Entity.EntityState.Added;
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
return(result);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity">实体数据</param>
/// <returns>布尔值（修改结果）</returns>
public bool Update <T>(T entity) where T : class
{
bool result = false;
using (CommonEntities db = new CommonEntities())
{
db.Entry <T>(entity).State = System.Data.Entity.EntityState.Modified;
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
}
return(result);
}
/// <summary>
/// 添加集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entity"></param>
/// <returns></returns>
public bool InsertIQueryable <T>(List <T> lstentity) where T : class
{
bool result = false;
using (CommonEntities db = new CommonEntities())
{
foreach (var item in lstentity)
{
db.Entry <T>(item).State = System.Data.Entity.EntityState.Added;
}
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
return(result);
}
}
/// <summary>
/// 删除集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entity"></param>
/// <returns></returns>
public bool DeleteIQueryable(List <T> entity)
{
bool result = false;
using (CommonEntities db = new CommonEntities())
{
foreach (var item in entity)
{
db.Entry <T>(item).State = System.Data.Entity.EntityState.Deleted;
}
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
result = false;
}
return(result);
}
}
public CommonService()
{
Context = new CommonEntities();
}
public UnitOfWork(string practiceConnString, string eOrderConnString)
{
CommonContext = new CommonEntities();
EOrderContext = new EOrderEntities(eOrderConnString);
PracticeContext = new PracticeEntities(practiceConnString);
}
public DateTime?GetProductionDate(DateTime prodDate)
{
using (CommonEntities Context = new CommonEntities())
return(Context.GetProductionDate(prodDate).FirstOrDefault());
}
