public ResponseDocGet DocGet([FromBody] RequestDocGet request)
{
try
{
DocBLL bll = new DocBLL();
return(bll.DocGet(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ResponseDocGet DocGet(RequestDocGet request)
{
ResponseDocGet response = new ResponseDocGet();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
var user = UserInfoGet(request.Token, ts);
var head = cnn.QueryFirstOrDefault <TKS_FAS_Doc>("select * from TKS_FAS_Doc where id=@Id", new
{
Id = request.Data.Id
}, ts);
if (head == null)
{
throw new Exception("凭证已被删除");
}
var detail = cnn.Query <TKS_FAS_DocDetail>(
@"select * from tks_fas_docDetail where parentId=@ParentId order by Seq",
new { ParentId = head.Id }, ts).ToList();
//TKS_FAS_DocDetail item = new TKS_FAS_DocDetail();
for (int i = 0; i < detail.Count; i++)
{
var item = detail[i];
string CalValue1 = item.CalValue1;
detail[i].CalValue1 = "";
if (!string.IsNullOrEmpty(item.CalItem1))
{
//detail[i].CalValue1 += item.CalItem1 + "," + item.CalValue1 + "#";
detail[i].CalValue1 += item.CalItem1 + "," + 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;
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseDocGet);
}
}
}
