/// <summary> /// 添加数据 /// </summary> /// <param name="newData">数据</param> public void AddData(Pro_TemplateModel newData) { this.BeginTransaction(); Pro_TemplateItemBusiness templateItemBus = new Pro_TemplateItemBusiness(); Pro_Template template = new Pro_Template() { Id = newData.Id, TemplateId = newData.TemplateId, TemplateName = newData.TemplateName, TemplateType = newData.TemplateType, LastOperator = newData.LastOperator, LastTime = DateTime.Now, Context = newData.Context }; Insert(template); templateItemBus.BeginTransaction(); foreach (Pro_TemplateItem item in newData.TemplateItemList) { item.TemplateId = template.Id; item.Id = Guid.NewGuid().ToSequentialGuid(); templateItemBus.Insert(item); } ; if (templateItemBus.EndTransaction()) { this.EndTransaction(); } }
/// <summary> /// 更新数据 /// </summary> public void UpdateData(Pro_TemplateModel theData) { this.BeginTransaction(); Pro_Template template = new Pro_Template() { Id = theData.Id, TemplateId = theData.TemplateId, TemplateName = theData.TemplateName, TemplateType = theData.TemplateType, LastOperator = theData.LastOperator, LastTime = DateTime.Now, Context = theData.Context }; _tib.BeginTransaction(); List <Pro_TemplateItem> list = _tib.GetDataList("TemplateId", template.Id, new Pagination() { PageIndex = 1, PageRows = int.MaxValue }); var listIds = from p in list select p.Id; _tib.DeleteData(listIds.ToList()); foreach (Pro_TemplateItem item in theData.TemplateItemList) { item.TemplateId = template.Id; item.Id = Guid.NewGuid().ToSequentialGuid(); _tib.Insert(item); } ; Update(template); if (_tib.EndTransaction()) { this.EndTransaction(); } }
/// <summary> /// 获取指定的单条数据 /// </summary> /// <param name="id">主键</param> /// <returns></returns> public Pro_TemplateModel GetTheData(string id) { Pro_TemplateModel theData = _cache.GetCache(id); if (theData == null) { //缓存中没有找到,查询数据库 Pro_Template template = this.GetEntity(id); if (template == null) { return(null); } theData = new Pro_TemplateModel(template); List <Pro_TemplateItem> list = _tib.GetDataList("TemplateId", template.Id, new Pagination() { PageIndex = 1, PageRows = int.MaxValue }); theData.TemplateItemList = list; } return(theData); }