public bool SaveAdvertisement(Ld_Extend_Advertisement entity, List <Ld_Extend_AdvertisementDetails> lists)
{
try
{
var advertisement = PrimaryKeyHelper.PrimaryKeyType.ExtendAdvertisement;
var advertisementDetails = PrimaryKeyHelper.PrimaryKeyType.ExtendAdvertisementDetails;
var version = PrimaryKeyHelper.PrimaryKeyLen.V1;
string advertisementId = PrimaryKeyHelper.MakePrimaryKey(advertisement, version);
entity.AdvertisementID = advertisementId;
entity.Sort = entity.Sort.ToInt();
entity.State = entity.State.ToBool();
entity.CreateDate = DateTime.Now;
if (lists == null)
{
throw new Exception("广告列表不能为空！");
}
List <Ld_Extend_AdvertisementDetails> details = new List <Ld_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);
}
int intnum = 0;
var dbContext = new DAL.BaseDAL(LdCmsDbEntitiesContext);
using (var db = dbContext.DbEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
dbContext.Add(entity);
dbContext.Add(details);
intnum = db.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
return(intnum > 0);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int MediaInterface(string appId, List <Basics_Media> lists)
{
try
{
if (lists == null)
{
throw new Exception("写入列表不能为空！");
}
lists.ForEach(m => { m.State = true; m.CreateDate = DateTime.Now; });
List <Basics_MediaInterface> listMediaInterface = new List <Basics_MediaInterface>();
foreach (var m in lists)
{
listMediaInterface.Add(new Basics_MediaInterface()
{
SystemID = m.SystemID,
CompanyID = m.CompanyID,
MediaID = m.MediaID,
AppID = appId
});
}
int intnum = 0;
var dbContext = new DAL.BaseDAL(CTMSContext);
using (var db = dbContext.DbEntities())
{
//using (var trans = db.Database.BeginTransaction())
//{
// try
// {
// dbContext.Add(lists);
// dbContext.Add(listMediaInterface);
// intnum = db.SaveChanges();
// trans.Commit();
// }
// catch (Exception)
// {
// trans.Rollback();
// }
// return intnum;
//}
db.Orm.Transaction(() =>
{
dbContext.Add(lists);
dbContext.Add(listMediaInterface);
intnum = db.SaveChanges();
});
return(intnum);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int SaveMediaMember(string memberId, List <Ld_Basics_Media> lists)
{
try
{
if (lists == null)
{
throw new Exception("写入列表不能为空！");
}
lists.ForEach(m => { m.State = true; m.CreateDate = DateTime.Now; });
List <Ld_Basics_MediaMember> listMediaMember = new List <Ld_Basics_MediaMember>();
foreach (var m in lists)
{
listMediaMember.Add(new Ld_Basics_MediaMember()
{
SystemID = m.SystemID,
CompanyID = m.CompanyID,
MediaID = m.MediaID,
MemberID = memberId
});
}
int intnum = 0;
var dbContext = new DAL.BaseDAL(LdCmsDbEntitiesContext);
using (var db = dbContext.DbEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
dbContext.Add(lists);
dbContext.Add(listMediaMember);
intnum = db.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
return(intnum);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool SaveClass(Info_Class entity)
{
try
{
var infoClass = PrimaryKeyHelper.PrimaryKeyType.InfoClass;
var primaryKeyLen = PrimaryKeyHelper.PrimaryKeyLen.V1;
int systemId = entity.SystemID;
string companyId = entity.CompanyID;
string classId = PrimaryKeyHelper.MakePrimaryKey(infoClass, primaryKeyLen);
string className = entity.ClassName;
int classType = entity.ClassType.ToInt();
string parentId = string.IsNullOrEmpty(entity.ParentID) ? "0" : entity.ParentID;
bool state = entity.State.ToBool();
if (parentId != "0")
{
bool verifyParentId = IsExists(m => m.SystemID == systemId && m.CompanyID == companyId && m.ClassID == parentId);
if (!verifyParentId)
{
throw new Exception("上级分类ID不存在！");
}
}
bool verifyClassName = IsExists(m => m.SystemID == systemId && m.CompanyID == companyId && m.ParentID == parentId && m.ClassName == className);
if (verifyClassName)
{
throw new Exception("分类名称已存在！");
}
if (parentId == "0")
{
entity.ParentID = "0";
entity.ParentPath = "0";
entity.ClassRank = 1;
entity.OrderID = 0;
entity.OrderPath = classId;
}
else
{
var entityClass = Find(m => m.SystemID == systemId && m.CompanyID == companyId && m.ClassID == parentId);
int classRank = entityClass.ClassRank.ToInt();
string parentPath = entityClass.ParentPath;
string orderPath = entityClass.OrderPath;
entity.ParentID = parentId;
entity.ParentPath = string.Format("{0},{1}", parentPath, parentId);
entity.ClassRank = (classRank + 1).ToByte();
entity.OrderID = 0;
entity.OrderPath = string.Format("{0}{1}", orderPath, classId);
}
entity.ClassID = classId;
entity.State = state;
entity.CreateDate = DateTime.Now;
var infoPage = PrimaryKeyHelper.PrimaryKeyType.InfoPage;
var infoPageVersion = PrimaryKeyHelper.PrimaryKeyLen.V1;
string pageId = PrimaryKeyHelper.MakePrimaryKey(infoPage, infoPageVersion);
var entityPage = new Info_Page()
{
SystemID = systemId,
CompanyID = companyId,
PageID = pageId,
Title = entity.ClassName,
ClassID = entity.ClassID,
ClassName = entity.ClassName,
Sort = 0,
State = true,
CreateDate = DateTime.Now
};
int intnum = 0;
var dbContext = new DAL.BaseDAL(CTMSContext);
using (var db = dbContext.DbEntities())
{
//using (var trans = db.Database.BeginTransaction())
//{
// try
// {
// dbContext.Add(entity);
// if (classType == 1)
// dbContext.Add(entityPage);
// intnum = db.SaveChanges();
// trans.Commit();
// }
// catch (Exception)
// {
// trans.Rollback();
// }
// return intnum > 0;
//}
db.Orm.Transaction(() =>
{
dbContext.Add(entity);
if (classType == 1)
{
dbContext.Add(entityPage);
}
intnum = db.SaveChanges();
});
return(intnum > 0);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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);
}
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(T model)
{
return(dal.Add(model));
}
/// <summary>
/// 1.0添加数据
/// </summary>
/// <param name="model"></param>
public void Add(T model)
{
idal.Add(model);
}
