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