public ResponsePZZAdd PZZAdd([FromBody] RequestPZZAdd request)
{
try
{
PZZBLL bll = new PZZBLL();
return(bll.PZZAdd(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ResponsePZZAdd PZZAdd(RequestPZZAdd request)
{
ResponsePZZAdd response = new ResponsePZZAdd();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
var user = this.UserInfoGet(request.Token, ts);
var d = cnn.Query("select * from TKS_FAS_CertificateWord where pzz=@PZZ",
new { PZZ = request.Data.PZZ }, ts);
if (d.Count() > 0)
{
throw new NormalException("凭证字已经存在");
}
d = cnn.Query("select * from TKS_FAS_CertificateWord where ShowTitle=@ShowTitle",
new { ShowTitle = request.Data.ShowTitle }, ts);
if (d.Count() > 0)
{
throw new NormalException("显示名称已经存在");
}
if (request.Data.IsDefault == 1)
{
cnn.Execute("update TKS_FAS_CertificateWord set isDefault=0 where accountId=@AccountId",
new { AccountId = user.AccountId }, ts);
}
request.Data.Id = Guid.NewGuid().ToString("N");
request.Data.AccountId = user.AccountId;
cnn.Insert <TKS_FAS_CertificateWord>(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 ResponsePZZAdd);
}
}
}
