/// <summary> /// 编辑财务类别 /// </summary> /// <returns></returns> public ActionResult Edit() { string SnNum = WebUtil.GetFormValue <string>("SnNum"); string CateNum = WebUtil.GetFormValue <string>("CateNum"); string CateName = WebUtil.GetFormValue <string>("CateName"); string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); FinanceCateEntity entity = new FinanceCateEntity(); entity.SnNum = SnNum; entity.CateNum = CateNum; entity.IsDelete = (int)EIsDelete.NotDelete; entity.CateName = CateName; entity.CompanyID = CompanyID; FinanceCateProvider provider = new FinanceCateProvider(CompanyID); int line = provider.Update(entity); DataResult result = new DataResult(); if (line > 0) { result.Code = (int)EResponseCode.Success; result.Message = "财务类别修改成功"; } else { result.Code = (int)EResponseCode.Exception; result.Message = "财务类别修改失败"; } return(Content(JsonHelper.SerializeObject(result))); }
public ActionResult Add() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); string CompanyID = this.CompanyID; FinanceCateEntity entity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(FinanceCateApiName.FinanceCateApiName_Single, dic); if (!result.IsEmpty()) { DataResult <FinanceCateEntity> dataResult = JsonConvert.DeserializeObject <DataResult <FinanceCateEntity> >(result); entity = dataResult.Result; } } entity = entity.IsNull() ? new FinanceCateEntity() : entity; ViewBag.Entity = entity; return(View()); }
/// <summary> /// 查询分页 /// </summary> /// <returns></returns> public ActionResult GetPage() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); string CateNum = WebUtil.GetFormValue <string>("CateNum"); string CateName = WebUtil.GetFormValue <string>("CateName"); FinanceCateEntity entity = new FinanceCateEntity(); entity.CateNum = CateNum; entity.CateName = CateName; PageInfo pageInfo = new PageInfo(); pageInfo.PageIndex = PageIndex; pageInfo.PageSize = PageSize; FinanceCateProvider provider = new FinanceCateProvider(CompanyID); List <FinanceCateEntity> list = provider.GetList(entity, ref pageInfo); DataListResult <FinanceCateEntity> result = new DataListResult <FinanceCateEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = list, PageInfo = pageInfo }; return(Content(JsonHelper.SerializeObject(result))); }
/// <summary> /// 查询财务类别信息 /// </summary> /// <returns></returns> public ActionResult Single() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); FinanceCateProvider provider = new FinanceCateProvider(CompanyID); FinanceCateEntity entity = provider.GetSingle(SnNum); DataResult <FinanceCateEntity> result = new DataResult <FinanceCateEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity }; return(Content(JsonHelper.SerializeObject(result))); }
/// <summary> /// 修改财务类别 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(FinanceCateEntity entity) { string Key = string.Format(CacheKey.JOOSHOW_FINANCECATE_CACHE, this.CompanyID); entity.IncludeCateName(true) .Where(a => a.SnNum == entity.SnNum) .And(a => a.CompanyID == this.CompanyID) ; int line = this.FinanceCate.Update(entity); if (line > 0) { CacheHelper.Remove(Key); } return(line); }
/// <summary> /// 根据财务类别删除删除 /// </summary> /// <param name="cateNum"></param> /// <returns></returns> public int Delete(IEnumerable <string> list) { string Key = string.Format(CacheKey.JOOSHOW_FINANCECATE_CACHE, this.CompanyID); FinanceCateEntity entity = new FinanceCateEntity(); entity.Where("SnNum", ECondition.In, list.ToArray()); entity.IsDelete = (int)EIsDelete.Deleted; entity.IncludeIsDelete(true); int line = this.FinanceCate.Update(entity); if (line > 0) { CacheHelper.Remove(Key); } return(line); }
/// <summary> /// 添加财务类别 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Add(FinanceCateEntity entity) { string Key = string.Format(CacheKey.JOOSHOW_FINANCECATE_CACHE, this.CompanyID); entity.SnNum = entity.SnNum.IsEmpty() ? ConvertHelper.NewGuid():entity.SnNum; entity.CateNum = entity.CateNum.IsEmpty() ? new SequenceProvider(this.CompanyID).GetSequence(typeof(FinanceCateEntity)) : entity.CateNum; entity.IncludeAll(); int line = this.FinanceCate.Add(entity); if (line > 0) { CacheHelper.Remove(Key); } return(line); }
/// <summary> /// 编辑财务应收应付 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Edit(FinanceBillEntity entity) { if (entity.CateNum.IsNotEmpty()) { List <FinanceCateEntity> listCate = new FinanceCateProvider(this.CompanyID).GetList(); if (!listCate.IsNullOrEmpty()) { FinanceCateEntity cate = listCate.FirstOrDefault(a => a.SnNum == entity.CateNum); entity.CateName = cate != null ? cate.CateName : string.Empty; } } entity.Include(a => new { a.CateNum, a.CateName, a.BillType, a.FromNum, a.FromName, a.ToNum, a.ToName, a.Amount, a.PrePayCount, a.PrePayRate, a.RealPayCount, a.LastTime, a.Title, a.ContractSn, a.ContractNum, a.Remark }); entity.Where(a => a.SnNum == entity.SnNum).And(a => a.CompanyID == this.CompanyID); int line = this.FinanceBill.Update(entity); return(line); }
/// <summary> /// 查询财务类别分页 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List <FinanceCateEntity> GetList(FinanceCateEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID); if (!entity.CateNum.IsEmpty()) { entity.And("CateNum", ECondition.Like, "%" + entity.CateNum + "%"); } if (!entity.CateName.IsEmpty()) { entity.And("CateName", ECondition.Like, "%" + entity.CateName + "%"); } entity.OrderBy(a => a.ID, EOrderBy.DESC); int rowCount = 0; List <FinanceCateEntity> list = this.FinanceCate.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return(list); }
/// <summary> /// 新增应收应付 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Add(FinanceBillEntity entity) { entity.SnNum = ConvertHelper.NewGuid(); entity.BillNum = entity.BillNum.IsEmpty() ? DateTime.Now.ToString("yyyyMMdd") + new TNumProvider(this.CompanyID).GetSwiftNumByDay(typeof(FinanceBillEntity), 4) : entity.BillNum; entity.CreateTime = DateTime.Now; entity.IsDelete = (int)EIsDelete.NotDelete; entity.Status = (int)EFinanceStatus.Wait; entity.CompanyID = this.CompanyID; if (entity.CateNum.IsNotEmpty()) { List <FinanceCateEntity> listCate = new FinanceCateProvider(this.CompanyID).GetList(); if (!listCate.IsNullOrEmpty()) { FinanceCateEntity cate = listCate.FirstOrDefault(a => a.SnNum == entity.CateNum); entity.CateName = cate != null ? cate.CateName : string.Empty; } } entity.IncludeAll(); int line = this.FinanceBill.Add(entity); return(line); }
/// <summary> /// 查询所有的财务类别 /// </summary> /// <returns></returns> public List <FinanceCateEntity> GetList() { string Key = string.Format(CacheKey.JOOSHOW_FINANCECATE_CACHE, this.CompanyID); List <FinanceCateEntity> list = CacheHelper.Get(Key) as List <FinanceCateEntity>; if (!list.IsNullOrEmpty()) { return(list); } FinanceCateEntity entity = new FinanceCateEntity(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.IncludeAll(); entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID); list = this.FinanceCate.GetList(entity); if (!list.IsNullOrEmpty()) { CacheHelper.Insert(Key, list); } return(list); }