public ResponseTPLGet TPLGet([FromBody] RequestTPLGet request)
{
try
{
TPLBLL bll = new TPLBLL();
return(bll.TPLGet(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ResponseTPLGet TPLGet(RequestTPLGet request)
{
ResponseTPLGet response = new ResponseTPLGet();
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);
var detail = cnn.Query <TKS_FAS_DocDetailTPL>(
@"select * from tks_fas_docDetailTPL where parentId=@ParentId",
new { ParentId = head.Id }, ts).ToList();
for (int i = 0; i < detail.Count; i++)
{
var item = detail[i];
if (!string.IsNullOrEmpty(item.CalItem1))
{
detail[i].CalValue1 += item.CalItem1 + "," + item.CalValue1 + "#";
}
if (!string.IsNullOrEmpty(item.CalItem2))
{
detail[i].CalValue1 += item.CalItem2 + ',' + item.CalValue2 + "#";
}
if (!string.IsNullOrEmpty(item.CalItem3))
{
detail[i].CalValue1 += item.CalItem3 + "," + item.CalValue3 + "#";
}
if (!string.IsNullOrEmpty(item.CalItem4))
{
detail[i].CalValue1 += item.CalItem4 + "," + item.CalValue4 + "#";
}
if (!string.IsNullOrEmpty(item.CalItem5))
{
detail[i].CalValue1 += item.CalItem5 + "," + item.CalValue5 + "#";
}
}
ts.Commit();
response.IsSuccess = true;
response.Message = "加载完毕";
response.Head = head;
response.Detail = detail;
#region add by Hero.Zhang 判断科目行是否有子科目
int flag = 0;
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)
{
flag++;
response.CheckParent = "1";
response.Message += "</br>第" + (i + 1).ToString() + "行有子科目，请重新选择";
}
}
//if (flag>0)
//{
// throw new NormalException("固定资产原值与期初固定资产不匹配</br>固定资产原值：" + FixedAssets.InitialAssetValue.ToString() + "</br>期初固定资产：" + val.ToString());
//}
#endregion
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseTPLGet);
}
}
}
