public ResponseFixedAssetsGet FixedAssetsGet(RequestFixedAssetsGet request) { ResponseFixedAssetsGet response = new ResponseFixedAssetsGet(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGet(request.Token, ts); AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); var data = cnn.QuerySingle <TKS_FAS_FixedAssets>("select * from TKS_FAS_FixedAssets where id=@Id", new { Id = request.Id }, ts); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.Data = data; response.NowPeriod = period.Id; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseFixedAssetsGet); } } }
public ResponseDocNOGet GetNextDocNO(RequestDocNOGet request) { using (cnn = GetConnection()) { ResponseDocNOGet res = new ResponseDocNOGet(); DateTime docDate = DateTime.Parse(request.DocDate); PeriodBLL periodBLL = new PeriodBLL(cnn); var user = this.UserInfoGet(request.Token, null); AccountSetBLL accountSetBLL = new AccountSetBLL(cnn); var activePeriod = accountSetBLL.GetActivePeriod(user.AccountId, null); if ((activePeriod.Year == docDate.Year && activePeriod.Month > docDate.Month) || activePeriod.Year > docDate.Year) { res.IsSuccess = false; res.Message = "该期别,不可新增凭证"; return(res); } var period = cnn.QueryFirstOrDefault <TKS_FAS_MonthPeriodInfo>("select * from TKS_FAS_MonthPeriodInfo where Year=@Year and AccountId=@AccountId and Month=@Month", new { Year = docDate.Year, Month = docDate.Month, AccountId = user.AccountId }, null); string no = string.Empty; if (period == null) { no = "1"; } else { string sql = @"select (case when max(pzzno) is null then 0 else max(pzzno) end) from TKS_FAS_Doc where accountid=@AccountId and periodId=@PeriodId"; var max = cnn.ExecuteScalar(sql, new { AccountId = user.AccountId, PeriodId = period.Id }, null); no = (int.Parse(max.ToString()) + 1).ToString(); } res.NO = no; res.IsSuccess = true; return(res); } }
public ResponseFixedAssetsChangeListSearch FixedAssetsChangeListSearch(RequestFixedAssetsChangeListSearch request) { ResponseFixedAssetsChangeListSearch response = new ResponseFixedAssetsChangeListSearch(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); var condition = new { AccountId = user.AccountId, Name = "%" + request.Name + "%" }; string sql = this.GetPageSql(@" A.*, convert(varchar(20),B.Year)+'年'+ convert(varchar(20),B.Month)+'期' as period ,C.tplId,ISCHUZHI=(SELECT 'Y' from TKS_FAS_FixedAssetsChange where ChangeType=8 and A.ParentId=ParentId)", @" TKS_FAS_FixedAssetsChange A left join tks_fas_monthPeriodInfo B on A.periodId=B.id left join tks_fas_changeType2TPL C on A.changeType=C.changeType where A.accountId=@AccountId and A.assetsname like @Name ", " createDate desc ", request.PageSize, request.PageIndex); List <TKS_FAS_FixedAssetsChangeExt> data = cnn.Query <TKS_FAS_FixedAssetsChangeExt>(sql, condition, ts).ToList(); string countSql = @"select count(1) from TKS_FAS_FixedAssetsChange where accountId=@AccountId and assetsname like @Name"; int total = int.Parse(cnn.ExecuteScalar(countSql, condition, ts).ToString()); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.PageIndex = request.PageIndex; response.Data = data; response.Total = total; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseFixedAssetsChangeListSearch); } } }
/// <summary> /// 只能查询当前期间下的信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseFixedAssetsListSearch FixedAssetsListSearch(RequestFixedAssetsListSearch request) { ResponseFixedAssetsListSearch response = new ResponseFixedAssetsListSearch(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { AccountSetBLL account = new AccountSetBLL(cnn); var user = this.UserInfoGet(request.Token, ts); var period = account.GetActivePeriod(user.AccountId, ts); var PeriodDate = request.PeriodDate.Split('-'); var condition = new { AccountId = user.AccountId, PeriodId = request.PeriodId, PeriodDate = PeriodDate[0] + PeriodDate[1].PadLeft(2, '0'), Year = PeriodDate[0], Month = PeriodDate[1], Name = "%" + request.Name + "%" }; string sql = this.GetPageSql("a.*,a.InitialAssetValue-a.AccumulativeDpre as ZCJZ,log.Amount", @" TKS_FAS_FixedAssets a left join(select distinct FixedId,Amount from TKS_FAS_FixedAssetsLog where Amount>0 and accountId=@AccountId and PeriodId=@PeriodId) log on a.id=log.FixedId where a.accountId=@AccountId and a.name like @Name and convert(nvarchar(6),a.StartUseDate,112)<=@PeriodDate", " a.DocNo", request.PageSize, request.PageIndex); List <TKS_FAS_FixedAssetsExt> data = cnn.Query <TKS_FAS_FixedAssetsExt>(sql, condition, ts).ToList(); string countSql = @"select count(1) from TKS_FAS_FixedAssets where accountId=@AccountId and name like @Name and convert(nvarchar(6),StartUseDate,112)<=@PeriodDate"; int total = int.Parse(cnn.ExecuteScalar(countSql, condition, ts).ToString()); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.PageIndex = request.PageIndex; response.Data = data; response.Total = total; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseFixedAssetsListSearch); } } }
public void CustomDataImport(DataTable dt, string token, string itemId) { using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(token, ts); AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); BalanceBLL balanceBLL = new BalanceBLL(cnn); PeriodBLL periodBLL = new PeriodBLL(cnn); string sql = string.Empty; sql = @"delete from TKS_FAS_CaculateHelperDetail where AccountId=@AccountId and ParentId=@ParentId"; cnn.Execute(sql, new { AccountId = user.AccountId, ParentId = itemId }, ts); if (dt.DefaultView.ToTable(true, "Name").Rows.Count < dt.Rows.Count) { throw new NormalException("名称不能重复"); } for (var i = 0; i < dt.Rows.Count; i++) { var rowItem = dt.Rows[i]; TKS_FAS_CaculateHelperDetail fix = new TKS_FAS_CaculateHelperDetail(); fix.Id = Guid.NewGuid().ToString("N"); fix.AccountId = user.AccountId; fix.ParentId = itemId;//当前期间为录入期间 fix.IsValid = 1; fix.Code = (i + 1).ToString().PadLeft(3, '0'); fix.Name = rowItem["Name"].ToString(); fix.Memo = rowItem["Memo"].ToString(); fix.Custom1 = "#nodata#"; fix.Custom2 = "#nodata#"; fix.Custom3 = "#nodata#"; fix.Custom4 = "#nodata#"; fix.Custom5 = "#nodata#"; fix.Custom6 = "#nodata#"; fix.Custom7 = "#nodata#"; fix.Custom8 = "#nodata#"; cnn.Insert <TKS_FAS_CaculateHelperDetail>(fix, ts); } ts.Commit(); } catch (Exception ex) { ts.Rollback(); throw ex; } } }
/// <summary> /// 处置资产 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseFixedAssetsDeal FixedAssetsDeal(RequestFixedAssetsDeal request) { ResponseFixedAssetsDeal response = new ResponseFixedAssetsDeal(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGet(request.Token, ts); AccountSetBLL bll = new AccountSetBLL(cnn); var period = bll.GetActivePeriod(user.AccountId, ts); string sql = "select * from TKS_FAS_FixedAssets where isGenPz=1 and id=@Id"; var data = cnn.Query <TKS_FAS_FixedAssets>(sql, new { Id = request.Data.Id }, ts).FirstOrDefault(); if (data == null) { throw new NormalException("未生成凭证,无法报废"); } TKS_FAS_FixedAssetsChange change = new TKS_FAS_FixedAssetsChange(); change.Id = Guid.NewGuid().ToString("N"); change.ParentId = data.Id; change.DocNo = data.DocNo; change.PeriodId = period.Id; change.AccountId = data.AccountId; change.AssetsName = data.Name; change.PreContent = (data.InitialAssetValue - data.AccumulativeDpre).ToString(); change.CurContent = (data.InitialAssetValue - data.AccumulativeDpre).ToString(); change.ChangeType = 8; change.CreateUser = data.CreateUser; change.CreateDate = data.CreateDate; cnn.Insert <TKS_FAS_FixedAssetsChange>(change, ts); sql = "update TKS_FAS_FixedAssets set status=1 where Id=@Id"; cnn.Execute(sql, new { Id = data.Id }, ts); ts.Commit(); response.IsSuccess = true; response.Message = "处置成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseFixedAssetsDeal); } } }
/// <summary> /// 根据保存的来源类型处理 /// 例如:如果是从模板生成触发,期末检查模板要关联生成的凭证 /// </summary> /// <param name="request"></param> /// <param name="ts"></param> /// <param name="user"></param> private void DealByPZType(RequestDocAdd request, IDbTransaction ts, MM_UserInfo user) { if (request.Type == PZType.QM.ToString())//期末 { AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); TKS_FAS_TPL2PZ newData = new TKS_FAS_TPL2PZ(); newData.Id = Guid.NewGuid().ToString(); newData.TPLId = request.TPLId; newData.PZId = request.Head.Id; newData.AccountId = user.AccountId; newData.CreateUser = user.User.UserName; newData.CreateDate = DateTime.Now; newData.PeriodId = period.Id; cnn.Insert <TKS_FAS_TPL2PZ>(newData, ts); } else if (request.Type == PZType.FP.ToString()) { InvoiceBLL bll = new FAS.InvoiceBLL(cnn); bll.LZ(request.Key, request.Head.Id, user, ts); } else if (request.Type == PZType.CHANGE.ToString()) { PZZBLL pzz = new PZZBLL(cnn); var pzzData = pzz.PZZGetById(request.Head.PZZ, ts); FixedAssetsBLL fixedAssetsBLL = new FixedAssetsBLL(cnn); fixedAssetsBLL.ChangeSetPZ(request.Head.Id, pzzData.PZZ + request.Head.PZZNO, request.Key, ts); fixedAssetsBLL.SetIsGenPZ(request.Key, user, ts); } else if (request.Type == PZType.GD.ToString()) { AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); TKS_FAS_TPL2PZ newData = new TKS_FAS_TPL2PZ(); newData.Id = Guid.NewGuid().ToString(); newData.TPLId = request.TPLId; newData.PZId = request.Head.Id; newData.AccountId = user.AccountId; newData.CreateUser = user.User.UserName; newData.CreateDate = DateTime.Now; newData.PeriodId = period.Id; cnn.Insert <TKS_FAS_TPL2PZ>(newData, ts); //更新固定资产 FixedAssetsBLL fixedAssetsBLL = new FixedAssetsBLL(cnn); fixedAssetsBLL.Depreciation(user.AccountId, ts, period); } }
/// <summary> /// 获取快速凭证模板 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseKSPZTPLsGet KSPZTPLsGet(RequestKSPZTPLsGet request) { var res = new ResponseKSPZTPLsGet(); using (cnn = this.GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGet(request.Token, ts); AccountSetBLL accountBll = new AccountSetBLL(cnn); var period = accountBll.GetActivePeriod(user.AccountId, ts); //获取期末检查模板 是否已经生成凭证 //update by Hero.Zhang 按照原始模板查询 string sql = @"select A.*,0 as IsGenPZ from TKS_FAS_DocTPL A where A.tplTarget=1 and A.isCustom=0 and a.AccountId='-' "; var data = cnn.Query <TKS_FAS_DocTPLExt>(sql, new { AccountId = user.AccountId, //账套 PeriodId = period.Id //当前 期间 }, ts).ToList(); res.IsSuccess = true; res.Data = data; res.Message = ""; return(res); } catch (Exception ex) { ts.Rollback(); return(this.DealException(res, ex) as ResponseKSPZTPLsGet); } } }
/// <summary> /// 新增固定资产,都是在当前的期间下操作 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseFixedAssetsAdd FixedAssetsAdd(RequestFixedAssetsAdd request) { ResponseFixedAssetsAdd response = new ResponseFixedAssetsAdd(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); request.Data.Id = Guid.NewGuid().ToString("N"); request.Data.AccountId = user.AccountId; request.Data.StartPeriod = period.Id;//当前期间为录入期间 request.Data.CreateUser = user.User.UserName; request.Data.CreateDate = DateTime.Now; cnn.Insert <TKS_FAS_FixedAssets>(request.Data, ts); if (request.Data.AddType != "期初") { AddChange(request.Data, ts); } ts.Commit(); response.Id = request.Data.Id; response.IsSuccess = true; response.Message = "新增成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseFixedAssetsAdd); } } }
private string Add(RequestTPLAdd request, System.Data.IDbTransaction ts, MM_UserInfo user) { AccountSetBLL ac = new AccountSetBLL(cnn); var period = ac.GetActivePeriod(user.AccountId, ts); decimal total = 0; var flag = 0; //凭证上辅助核算项直接写死对应列 foreach (var item in request.Detail) { if (string.IsNullOrEmpty(item.SubjectCode)) { continue; } item.Id = Guid.NewGuid().ToString("N"); #region 辅助核算赋值 string[] cals = item.CalValue1.Split(new char[] { '#' }); for (int i = 0; i < cals.Length; i++) { if (string.IsNullOrEmpty(cals[i])) { continue; } string[] ss = cals[i].Split(new char[] { ',' }); if (i == 0) { item.CalItem1 = ss[0]; item.CalValue1 = ss[1]; } else if (i == 1) { item.CalItem2 = ss[0]; item.CalValue2 = ss[1]; } else if (i == 2) { item.CalItem3 = ss[0]; item.CalValue3 = ss[1]; } else if (i == 3) { item.CalItem4 = ss[0]; item.CalValue4 = ss[1]; } else if (i == 4) { item.CalItem5 = ss[0]; item.CalValue5 = ss[1]; } } #endregion total += item.Money_Debit; item.Year = period.Year; item.ParentId = request.Head.Id; item.AccountId = user.AccountId; cnn.Insert <TKS_FAS_DocDetailTPL>(item, ts); flag++; } if (flag == 0) { throw new NormalException("亲,您还没有填写明细"); } request.Head.AccountId = user.AccountId; request.Head.AMT_DBT = total; request.Head.IsCarry = 0; request.Head.TPLTarget = 0; //用户选择 request.Head.IsCustom = 1; //自定义 request.Head.CreateUser = user.User.TrueName; request.Head.CreateDate = DateTime.Now; cnn.Insert <TKS_FAS_DocTPL>(request.Head, ts); return(request.Head.Id); }
/// <summary> /// 模板加载 /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseTPLMGet TPLGet(RequestTPLMGet request) { ResponseTPLMGet response = new ResponseTPLMGet(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGet(request.Token, ts); var head = cnn.QuerySingle <TKS_FAS_DocTPL>("select * from TKS_FAS_DocTPL where id=@Id", new { Id = request.Data.Id }, ts); AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); //模板体明细 var detail = cnn.Query <TKS_FAS_DocDetailTPL>( @"select * from tks_fas_docDetailTPL where parentId=@ParentId", new { ParentId = head.Id }, ts).ToList(); //如果是固定资产,则需要捞取当前账套的所有固定资产的每月折旧额,生成计提折旧凭证 //需要对detail进行再包装 if (head.TPLTarget == 3) { #region 固定资产,计提折旧 FixedAssetsBLL fbll = new FixedAssetsBLL(cnn); //获取固定资产 List <TKS_FAS_FixedAssets> fixedAssets = fbll.FixedAssetsGetByAcccount(user.AccountId, period, ts); //凭证明细 List <TKS_FAS_DocDetailTPL> newDetail = new List <TKS_FAS_DocDetailTPL>(); head.AMT_DBT = 0; foreach (var item in fixedAssets) { if (item.DepreciationMethod == "2") { continue; } if (item.IsStartPeriodDepreciation == 0 && item.StartPeriod == period.Id) { continue; } if (item.DpreMonth < item.PreUseMonth) { //固定资产累计折旧科目,产生到凭证 //用固定资产表单上的科目覆盖模板的科目 for (var i = 0; i < detail.Count; i++) { //update by Hero.Zhang 每次循环前必须将借贷金额初始化 detail[i].Money_Credit = 0; detail[i].Money_Debit = 0; if (detail[i].Credit_Debit == 1) { detail[i].SubjectCode = item.ADSubjectCode; //detail[i].SubjectDescription = item.ADSubjectCode + " " + item.ADSubjectName; detail[i].SubjectDescription = item.ADSubjectName; } else if (detail[i].Credit_Debit == 0) { detail[i].SubjectCode = item.DCostSubjectCode; detail[i].SubjectDescription = item.DCostSubjectName; } } //填充金额 var d = FillDetail(item.DprePerMonth, detail); newDetail.AddRange(d); head.AMT_DBT += item.DprePerMonth; //if (item.ADSubjectCode == "1502001") //{ // test.Add(item); //} } } //分组合并 var lst = newDetail.GroupBy(x => new { x.Id, x.ParentId, x.LineNo, x.AccountId, x.Year, x.SubjectCode, x.SubjectDescription, x.Summary, x.Credit_Debit, x.PartnerCode, x.Unit, x.CurrencyCode, x.CalItem1, x.CalValue1, x.CalItem2, x.CalValue2, x.CalItem3, x.CalValue3, x.CalItem4, x.CalValue4, x.CalItem5, x.CalValue5, x.Rate, x.Quantity, x.Price, x.IsCurrency, x.IsQuantity, x.IsCalHelper, x.Balance, x.YB, x.IPercent, x.SourceType }).Select(x => new TKS_FAS_DocDetailTPL { Id = x.First().Id, ParentId = x.First().ParentId, LineNo = x.First().LineNo, AccountId = x.First().AccountId, Year = x.First().Year, SubjectCode = x.First().SubjectCode, SubjectDescription = x.First().SubjectDescription, Summary = x.First().Summary, Credit_Debit = x.First().Credit_Debit, PartnerCode = x.First().PartnerCode, Unit = x.First().Unit, CurrencyCode = x.First().CurrencyCode, CalItem1 = x.First().CalItem1, CalValue1 = x.First().CalValue1, CalItem2 = x.First().CalItem2, CalValue2 = x.First().CalValue2, CalItem3 = x.First().CalItem3, CalValue3 = x.First().CalValue3, CalItem4 = x.First().CalItem4, CalValue4 = x.First().CalValue4, CalItem5 = x.First().CalItem5, CalValue5 = x.First().CalValue5, Rate = x.First().Rate, Quantity = x.First().Quantity, Price = x.First().Price, IsCurrency = x.First().IsCurrency, IsQuantity = x.First().IsQuantity, IsCalHelper = x.First().IsCalHelper, Balance = x.First().Balance, YB = x.First().YB, IPercent = x.First().IPercent, SourceType = x.First().SourceType, Money_Credit = x.Sum(s => s.Money_Credit), Money_Debit = x.Sum(s => s.Money_Debit) }).ToList(); //detail = newDetail; detail = lst; #endregion } else if (head.TPLTarget == 7) { #region 固定资产变动单类型 var changeTypeToTpl = cnn.QuerySingleOrDefault <TKS_FAS_FixedAssetsChange>( "select * from TKS_FAS_FixedAssetsChange where Id=@Id ", new { Id = request.Key }, ts); if (changeTypeToTpl != null) { //固定资产变动类型新增的情况 string fixsql = @"select B.* from TKS_FAS_FixedAssetsChange A left join TKS_FAS_FixedAssets B on A.parentId=B.id where A.id=@ID"; TKS_FAS_FixedAssets fixedAssets = cnn.QuerySingleOrDefault <TKS_FAS_FixedAssets>(fixsql, new { ID = request.Key }, ts); if (fixedAssets == null) { throw new Exception("固定资产不存在"); } FillDetail(request.Money, detail); if (changeTypeToTpl.ChangeType == 1) { #region 新增 for (var i = 0; i < detail.Count; i++) { if (detail[i].SubjectCode == "1501") { detail[i].SubjectCode = fixedAssets.GDCode; detail[i].SubjectDescription = fixedAssets.GDName; } else if (detail[i].SubjectCode == "217100101") { if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = fixedAssets.InputVAT; } else { detail[i].Money_Credit = fixedAssets.InputVAT; } } else if (detail[i].SubjectCode == "1002") { if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = request.Money + fixedAssets.InputVAT; } else { detail[i].Money_Credit = request.Money + fixedAssets.InputVAT; } } } request.Money += fixedAssets.InputVAT; #endregion } else if (changeTypeToTpl.ChangeType == 8) { #region 报废 for (var i = 0; i < detail.Count; i++) { if (detail[i].SubjectCode == "1501") { if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = fixedAssets.InitialAssetValue; } else { detail[i].Money_Credit = fixedAssets.InitialAssetValue; } } else if (detail[i].SubjectCode == "1502") { if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = fixedAssets.AccumulativeDpre + fixedAssets.DprePerMonth;//累计折旧+每月折旧额 } else { detail[i].Money_Credit = fixedAssets.AccumulativeDpre + fixedAssets.DprePerMonth; } } else if (detail[i].SubjectCode == "1701") { if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = fixedAssets.InitialAssetValue - fixedAssets.AccumulativeDpre - fixedAssets.DprePerMonth;//减去累计折旧和每月折旧额 } else { detail[i].Money_Credit = fixedAssets.InitialAssetValue - fixedAssets.AccumulativeDpre - fixedAssets.DprePerMonth; } } } request.Money = fixedAssets.InitialAssetValue; #endregion } } else { FillDetail(request.Money, detail); } #endregion } else if (head.TPLTarget == 2) { #region 发票上传 //var fp = cnn.Query<TKS_FAS_Invoice>( // "select * from TKS_FAS_Invoice where id=@Id", new { Id =request.Data.Id}, ts); //if (fp == null) //{ // throw new NormalException("未找到对应发票"); //} FillDetail(request.Money, detail); decimal total = 0; for (var i = 0; i < detail.Count; i++) { if (detail[i].SourceType == 0) { //发生额比例,不做处理 } else if (detail[i].SourceType == 1) { //含税金额 if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = request.Money; } else { detail[i].Money_Credit = request.Money; } } else if (detail[i].SourceType == 2) { //税金 if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = request.Tax; } else { detail[i].Money_Credit = request.Tax; } } else if (detail[i].SourceType == 3) { //未税金额 if (detail[i].Credit_Debit == 0) { detail[i].Money_Debit = request.Money - request.Tax; } else { detail[i].Money_Credit = request.Money - request.Tax; } } total += detail[i].Money_Debit; } request.Money = total; #endregion } else { FillDetail(request.Money, detail); } if (request.Money > 0) { head.AMT_DBT = request.Money; } ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.Head = head; response.Detail = detail; #region add by Hero.Zhang 判断科目行是否有子科目 for (int i = 0; i < detail.Count(); i++) { var item = detail[i]; List <TKS_FAS_AccountSubject> sub = cnn.Query <TKS_FAS_AccountSubject>(@"select * from TKS_FAS_AccountSubject where AccountId=@AccountId and RootCode=@RootCode", new { AccountId = user.AccountId, RootCode = item.SubjectCode }, ts).ToList(); if (sub.Count > 1) { response.CheckParent = "1"; response.Message += "</br>第" + (i + 1).ToString() + "行有子科目,请重新选择"; } } #endregion return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseTPLMGet); } } }
public ResponsePZZTotalGet PZZTotalGet(RequestPZZTotalGet request) { ResponsePZZTotalGet response = new ResponsePZZTotalGet(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); string sql = "select * from TKS_FAS_CertificateWord where accountId=@AccountId order by isdefault desc"; List <TKS_FAS_CertificateWord> data = cnn.Query <TKS_FAS_CertificateWord>(sql, new { AccountId = user.AccountId }, ts).ToList(); AccountSetBLL account = new AccountSetBLL(cnn); PeriodBLL periodBLL = new PeriodBLL(cnn); var activePeriod = account.GetActivePeriod(user.AccountId, ts); sql = @"select top 1 * from TKS_FAS_Doc where accountid=@AccountId and PZDate>=@StartDate order by CreateDate desc "; var doc = cnn.QueryFirstOrDefault <TKS_FAS_Doc>(sql, new { AccountId = user.AccountId, StartDate = activePeriod.StartDate, }, ts); var period = new TKS_FAS_MonthPeriodInfo(); if (request.Type == "GD") { //add by Hero.Zhang 计提折旧日期默认为当前活动期间 period = activePeriod; response.DefaultDate = DateTime.Parse(period.EndDate.ToString()).ToString("yyyy-MM-dd"); } else { if (doc != null) { response.DefaultDate = (doc.PZDate ?? DateTime.Now).ToString("yyyy-MM-dd"); period = periodBLL.GetPeriod(doc.PeriodId, ts); } else { period = activePeriod; if (period.Month == DateTime.Now.Month && period.Year == DateTime.Now.Year) { //当天日期属于本期 response.DefaultDate = DateTime.Parse(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); } else { response.DefaultDate = DateTime.Parse(period.EndDate.ToString()).ToString("yyyy-MM-dd"); } } } sql = @"select (case when max(pzzno) is null then 0 else max(pzzno) end) from TKS_FAS_Doc where accountid=@AccountId and periodId=@PeriodId"; var max = cnn.ExecuteScalar(sql, new { AccountId = user.AccountId, PeriodId = period.Id }, ts); response.No = (int.Parse(max.ToString()) + 1).ToString(); var currentAccount = account.GetAccountSetByAccountId(user.AccountId, ts); ts.Commit(); response.AccountName = currentAccount.QY_Name; response.IsSuccess = true; response.Message = "加载完毕"; response.Data = data; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponsePZZTotalGet); } } }
public ResponseFixedAssetsUpdate FixedAssetsUpdate(RequestFixedAssetsUpdate request) { ResponseFixedAssetsUpdate response = new ResponseFixedAssetsUpdate(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); //更新固定资产前,先检查是否存在变更记录,若存在,先更新变更记录 var check = "select * from TKS_FAS_FixedAssetsChange where ParentId=@id"; var dataUpdate = cnn.Query(check, new { id = request.Data.Id }, ts); if (dataUpdate.Count() > 0) { //add by Hero.Zhang如果购入类型是期初,则删除变更记录 if (request.Data.AddType == "期初") { cnn.Execute(@"delete from TKS_FAS_FixedAssetsChange where ParentId=@id", new { id = request.Data.Id }, ts); } else { //获取更新前固定资产 var data = cnn.QueryFirst <TKS_FAS_FixedAssets>("select * from TKS_FAS_FixedAssets where id=@Id", new { Id = request.Data.Id }, ts); if (data != null) { string updateSql = @"update TKS_FAS_FixedAssetsChange set DocNo = @DocNo, AssetsName = @AssetsName, PreContent = @PreContent, CurContent = @CurContent where ParentId=@Id"; cnn.Execute(updateSql, new { DocNo = data.DocNo, AssetsName = data.Name, PreContent = request.Data.InitialAssetValue, CurContent = request.Data.InitialAssetValue, Id = request.Data.Id }, ts); } } } else { //add by Hero.Zhang //如果不存在变更记录,判断是否是期初购入类型,不是期初则新增变更记录 if (request.Data.AddType != "期初") { AccountSetBLL account = new AccountSetBLL(cnn); var period = account.GetActivePeriod(user.AccountId, ts); request.Data.AccountId = user.AccountId; request.Data.StartPeriod = period.Id;//当前期间为录入期间 request.Data.CreateUser = user.User.UserName; request.Data.CreateDate = DateTime.Now; AddChange(request.Data, ts); } } string sql = @"UPDATE TKS_FAS_FixedAssets SET DocNo = @DocNo ,Name = @Name ,AddType = @AddType ,AssetsClass = @AssetsClass ,SpecificationType = @SpecificationType ,StartUseDate = @StartUseDate ,UseDeptId = @UseDeptId ,UseDeptName = @UseDeptName ,Supplier = @Supplier ,DepreciationMethod = @DepreciationMethod ,IsStartPeriodDepreciation = @IsStartPeriodDepreciation ,ADSubjectCode = @ADSubjectCode ,ADSubjectName = @ADSubjectName ,DCostSubjectCode = @DCostSubjectCode ,DCostSubjectName = @DCostSubjectName ,AssetImpairmentSubjectCode = @AssetImpairmentSubjectCode ,AssetImpairmentSubjectName = @AssetImpairmentSubjectName ,InitialAssetValue = @InitialAssetValue ,ScrapValueRate = @ScrapValueRate ,ScrapValue = @ScrapValue ,PreUseMonth = @PreUseMonth ,DpreMonth = @DpreMonth ,RemainderUseMonth = @RemainderUseMonth ,AccumulativeDpre = @AccumulativeDpre ,AccumulativeDpre_Y = @AccumulativeDpre_Y ,PreviousAccumulativeDpre = @PreviousAccumulativeDpre ,DprePerMonth = @DprePerMonth ,GDCode=@GDCode ,GDName=@GDName ,InputVAT=@InputVAT ,Memo = @Memo WHERE Id=@Id"; cnn.Execute(sql, request.Data, ts); ts.Commit(); response.IsSuccess = true; response.Message = "更新成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseFixedAssetsUpdate); } } }