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); }