Пример #1
0
 public ResponseBBDetailtplUpdate BBDetailtplUpdate([FromBody] RequestBBDetailtplUpdate request)
 {
     try
     {
         ReportTplBLL bll = new ReportTplBLL();
         return(bll.BBDetailtplUpdate(request));
     }
     catch (Exception ex)
     {
         throw new HttpResponseException(
                   Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
     }
 }
Пример #2
0
        public ResponseBBDetailtplUpdate BBDetailtplUpdate(RequestBBDetailtplUpdate request)
        {
            ResponseBBDetailtplUpdate response = new ResponseBBDetailtplUpdate();

            using (cnn = GetConnection())
            {
                var ts = cnn.BeginTransaction();

                try
                {
                    var user = this.UserInfoGetButAccount(request.Token, ts);

                    string sql = @"update TKS_FAS_ReportDetailTPL set
                                columnName=@ColumnName,
                                SourceType=@SourceType,
                                SourceValue=@SourceValue,
                                Category=@Category,
                                seq=@Seq,
                                OperatorCharacter=@OperatorCharacter
                                where id=@Id";

                    cnn.Execute(sql, request.Data, ts);

                    ts.Commit();

                    response.IsSuccess = true;
                    response.Id        = request.Data.Id;
                    response.Message   = "更新成功";
                    return(response);
                }
                catch (Exception ex)
                {
                    ts.Rollback();
                    return(this.DealException(response, ex) as ResponseBBDetailtplUpdate);
                }
            }
        }