123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140 |
- using LeaRun.Application.Entity.DemoManage;
- using LeaRun.Application.IService.DemoManage;
- using LeaRun.Data.Repository;
- using LeaRun.Util.WebControl;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using LeaRun.Util;
- using LeaRun.Util.Extension;
- namespace LeaRun.Application.Service.DemoManage
- {
- /// <summary>
- /// 版 本 6.1
- /// Copyright (c) 2013-2016 上海力软信息技术有限公司
- /// 创 建:超级管理员
- /// 日 期:2016-12-06 17:29
- /// 描 述:OfficeRk
- /// </summary>
- public class OfficeRkService : RepositoryFactory, OfficeRkIService
- {
- #region 获取数据
- /// <summary>
- /// 获取列表
- /// </summary>
- /// <param name="pagination">分页</param>
- /// <param name="queryJson">查询参数</param>
- /// <returns>返回分页列表</returns>
- public IEnumerable<OfficeRkEntity> GetPageList(Pagination pagination, string queryJson)
- {
- var expression = LinqExtensions.True<OfficeRkEntity>();
- var queryParam = queryJson.ToJObject();
- //查询条件
- if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
- {
- string condition = queryParam["condition"].ToString();
- string keyword = queryParam["keyword"].ToString();
- switch (condition)
- {
- case "GysName": //供应商名称
- expression = expression.And(t => t.GysName.Contains(keyword));
- break;
- case "SellerName": //销售人员
- expression = expression.And(t => t.SellerName.Contains(keyword));
- break;
- default:
- break;
- }
- }
- return this.BaseRepository().FindList(expression,pagination);
- }
- /// <summary>
- /// 获取实体
- /// </summary>
- /// <param name="keyValue">主键值</param>
- /// <returns></returns>
- public OfficeRkEntity GetEntity(string keyValue)
- {
- return this.BaseRepository().FindEntity<OfficeRkEntity>(keyValue);
- }
- /// <summary>
- /// 获取子表详细信息
- /// </summary>
- /// <param name="keyValue">主键值</param>
- /// <returns></returns>
- public IEnumerable<OfficeRkEntryEntity> GetDetails(string keyValue)
- {
- return this.BaseRepository().FindList<OfficeRkEntryEntity>("select * from OfficeRkEntry where OrderId='" + keyValue + "'"); }
- #endregion
- #region 提交数据
- /// <summary>
- /// 删除数据
- /// </summary>
- /// <param name="keyValue">主键</param>
- public void RemoveForm(string keyValue)
- {
- IRepository db = new RepositoryFactory().BaseRepository().BeginTrans();
- try
- {
- db.Delete<OfficeRkEntity>(keyValue);
- db.Delete<OfficeRkEntryEntity>(t => t.RkEntryId.Equals(keyValue));
- db.Commit();
- }
- catch (Exception)
- {
- db.Rollback();
- throw;
- }
- }
- /// <summary>
- /// 保存表单(新增、修改)
- /// </summary>
- /// <param name="keyValue">主键值</param>
- /// <param name="entity">实体对象</param>
- /// <returns></returns>
- public void SaveForm(string keyValue, OfficeRkEntity entity,List<OfficeRkEntryEntity> entryList)
- {
- IRepository db = this.BaseRepository().BeginTrans();
- try
- {
- if (!string.IsNullOrEmpty(keyValue))
- {
- //主表
- entity.Modify(keyValue);
- db.Update(entity);
- //明细
- db.Delete<OfficeRkEntryEntity>(t => t.OrderId.Equals(keyValue));
- foreach (OfficeRkEntryEntity item in entryList)
- {
- item.Create();
- item.OrderId = entity.OrderId;
- db.Insert(item);
- }
- }
- else
- {
- //主表
- entity.Create();
- db.Insert(entity);
- //明细
- foreach (OfficeRkEntryEntity item in entryList)
- {
- item.Create();
- item.OrderId = entity.OrderId;
- db.Insert(item);
- }
- }
- db.Commit();
- }
- catch (Exception)
- {
- db.Rollback();
- throw;
- }
- }
- #endregion
- }
- }
|