public bool DeleteAdvertisement(int systemId, string companyId, string advertisementId)
{
try
{
int intnum = 0;
var dbContext = new DAL.BaseDAL(LdCmsDbEntitiesContext);
using (var db = dbContext.DbEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
dbContext.Delete <Ld_Extend_Advertisement>(m => m.SystemID == systemId && m.CompanyID == companyId && m.AdvertisementID == advertisementId);
dbContext.Delete <Ld_Extend_AdvertisementDetails>(m => m.SystemID == systemId && m.CompanyID == companyId && m.AdvertisementID == advertisementId);
intnum = db.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
return(intnum > 0);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int DeleteClass(int systemId, string companyId, string classId)
{
try
{
var expressionPage = ExtLinq.True <Info_Page>();
var expressionClass = ExtLinq.True <Info_Class>();
var expressionPageFindByClassId = expressionPage.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.ClassID == classId);
var expressionClassFind = expressionClass.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.ClassID == classId);
var expressionClassFindByParentId = expressionClass.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.ParentID == classId);
if (IsExists(expressionClassFindByParentId))
{
throw new Exception("分类、栏目还有下级栏目不能删除！");
}
var entity = Find(expressionClassFind);
int classType = entity.ClassType.ToInt();
int intnum = 0;
var dbContext = new DAL.BaseDAL(CTMSContext);
using (var db = dbContext.DbEntities())
{
//using (var trans = db.Database.BeginTransaction())
//{
// try
// {
// if (classType == 1)
// dbContext.Delete(expressionPageFindByClassId);
// dbContext.Delete(expressionClassFind);
// intnum = db.SaveChanges();
// trans.Commit();
// }
// catch (Exception)
// {
// trans.Rollback();
// }
// return intnum;
//}
db.Orm.Transaction(() =>
{
if (classType == 1)
{
dbContext.Delete(expressionPageFindByClassId);
}
dbContext.Delete(expressionClassFind);
intnum = db.SaveChanges();
});
return(intnum);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int DeleteAccountAll(int systemId, string companyId, string memberId)
{
try
{
var entity = GetAccount(systemId, companyId, memberId);
if (entity == null)
{
throw new Exception("会员ID不存在！");
}
var expressionAddress = ExtLinq.True <Member_Address>();
expressionAddress = expressionAddress.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.MemberID == memberId);
var expressionInvoice = ExtLinq.True <Member_Invoice>();
expressionInvoice = expressionInvoice.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.MemberID == memberId);
int intnum = 0;
var dbContext = new DAL.BaseDAL(CTMSContext);
using (var db = dbContext.DbEntities())
{
//using (var trans = db.Database.BeginTransaction())
//{
// try
// {
// dbContext.Delete(expressionAddress);
// dbContext.Delete(expressionInvoice);
// db.Set<Member_Account>().Remove(entity);
// intnum = db.SaveChanges();
// trans.Commit();
// }
// catch (Exception)
// {
// trans.Rollback();
// }
// return intnum;
//}
db.Orm.Transaction(() =>
{
dbContext.Delete(expressionAddress);
dbContext.Delete(expressionInvoice);
db.Set <Member_Account>().Remove(entity);
intnum = db.SaveChanges();
});
return(intnum);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool DeleteAdvertisement(int systemId, string companyId, string advertisementId)
{
try
{
var expressionAdvertisement = ExtLinq.True <Extend_Advertisement>();
expressionAdvertisement = expressionAdvertisement.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.AdvertisementID == advertisementId);
var expressionAdvertisementDetails = ExtLinq.True <Extend_AdvertisementDetails>();
expressionAdvertisementDetails = expressionAdvertisementDetails.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.AdvertisementID == advertisementId);
int intnum = 0;
var dbContext = new DAL.BaseDAL(CTMSContext);
using (var db = dbContext.DbEntities())
{
//using (var trans = db.Database.BeginTransaction())
//{
// try
// {
// dbContext.Delete(expressionAdvertisement);
// dbContext.Delete(expressionAdvertisementDetails);
// intnum = db.SaveChanges();
// trans.Commit();
// }
// catch (Exception)
// {
// trans.Rollback();
// }
// return intnum > 0;
//}
db.Orm.Transaction(() =>
{
dbContext.Delete(expressionAdvertisement);
dbContext.Delete(expressionAdvertisementDetails);
intnum = db.SaveChanges();
});
return(intnum > 0);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 2.0 删除方法1 删除给定的对象
/// </summary>
/// <param name="model"></param>
/// <param name="IsSoftDel">是否软删除[*如果是软删除 则自动保存*]</param>
/// <param name="Pro">软删除 要修改的删除标志字段</param>
/// <param name="DelTag">软删除 删除标志值</param>
/// <returns>如果非软删除则永远返回true 可以忽略</returns>
public void Delete(T model, bool IsSoftDel, string Pro = "IsDelte", bool DelTag = true)
{
idal.Delete(model, IsSoftDel, Pro, DelTag);
}
public bool UpdateAdvertisement(Extend_Advertisement entity, List <Extend_AdvertisementDetails> lists)
{
try
{
var advertisementDetails = PrimaryKeyHelper.PrimaryKeyType.ExtendAdvertisementDetails;
var version = PrimaryKeyHelper.PrimaryKeyLen.V1;
int systemId = entity.SystemID;
string companyId = entity.CompanyID;
string advertisementId = entity.AdvertisementID;
entity.Sort = entity.Sort.ToInt();
entity.State = entity.State.ToBool();
entity.CreateDate = DateTime.Now;
if (lists == null)
{
throw new Exception("广告列表不能为空！");
}
List <Extend_AdvertisementDetails> details = new List <Extend_AdvertisementDetails>();
foreach (var m in lists)
{
string advertisementDetailsId = PrimaryKeyHelper.MakePrimaryKey(advertisementDetails, version);
m.SystemID = entity.SystemID;
m.CompanyID = entity.CompanyID;
m.DetailsID = advertisementDetailsId;
m.AdvertisementID = advertisementId;
m.Sort = m.Sort.ToInt();
m.State = m.State.ToBool();
m.CreateDate = DateTime.Now;
details.Add(m);
}
var expression = ExtLinq.True <Extend_AdvertisementDetails>();
expression = expression.And(m => m.SystemID == systemId && m.CompanyID == companyId && m.AdvertisementID == advertisementId);
int intnum = 0;
var dbContext = new DAL.BaseDAL(CTMSContext);
using (var db = dbContext.DbEntities())
{
//using (var trans = db.Database.BeginTransaction())
//{
// try
// {
// dbContext.Update(entity);
// dbContext.Delete(expression);
// dbContext.Add(details);
// intnum = db.SaveChanges();
// trans.Commit();
// }
// catch (Exception)
// {
// trans.Rollback();
// }
// return intnum > 0;
//}
db.Orm.Transaction(() =>
{
dbContext.Update(entity);
dbContext.Delete(expression);
dbContext.Add(details);
intnum = db.SaveChanges();
});
return(intnum > 0);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}