public ResponseInvoiceUpdate WX_BasicDataUpdate(RequestBasicDataSearch request) { ResponseInvoiceUpdate response = new ResponseInvoiceUpdate(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); //var user = cnn.Query<TKS_FAS_User>(@"select * from TKS_FAS_User where Id=@Id", new { Id = request.UserId }, ts).FirstOrDefault(); string update_Invoice = @" UPDATE TKS_FAS_BasicData SET Name =@Name where id=@Id"; cnn.Execute(update_Invoice, new { Id = request.Id, Name = request.Name }, ts); ts.Commit(); response.IsSuccess = true; response.Message = "更新成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseInvoiceUpdate); } } }
public ResponseInvoiceAdd WX_BasicDataAdd(RequestBasicDataSearch request) { ResponseInvoiceAdd response = new ResponseInvoiceAdd(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); //string sql = @"select * from TKS_FAS_User where Id=@Id"; //var user = cnn.Query<TKS_FAS_User>(sql, new { Id = request.UserId }, ts).FirstOrDefault(); TKS_FAS_BasicData Invoice = new TKS_FAS_BasicData(); Invoice.Id = Guid.NewGuid().ToString("N"); Invoice.UserId = request.UserId; Invoice.CreateUser = user.User.TrueName; Invoice.CreateDate = DateTime.Now; Invoice.Name = request.Name; Invoice.DataType = request.DataType; cnn.Insert <TKS_FAS_BasicData>(Invoice, ts); ts.Commit(); response.IsSuccess = true; response.Message = "新增成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseInvoiceAdd); } } }
/// <summary> /// /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseBasicDataSearch BasicDataListSearch(RequestBasicDataSearch request) { ResponseBasicDataSearch response = new ResponseBasicDataSearch(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); string where = string.Empty; if (!string.IsNullOrEmpty(request.Name)) { where += " and Name like '%" + request.Name + "%'"; } string sql = this.GetPageSql("*", @" TKS_FAS_BasicData where UserId=@UserId and DataType=@DataType" + where, " createDate desc ", request.PageSize, request.PageIndex); List <TKS_FAS_BasicData> data = cnn.Query <TKS_FAS_BasicData>(sql, new { UserId = request.UserId, DataType = request.DataType }, ts).ToList(); string countSql = @"select count(1) from TKS_FAS_BasicData where UserId=@UserId and DataType=@DataType" + where; int total = int.Parse(cnn.ExecuteScalar(countSql, new { UserId = request.UserId, DataType = request.DataType }, 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 ResponseBasicDataSearch); } } }
public ResponseInvoiceAdd WX_BasicDataAdd([FromBody] RequestBasicDataSearch request) { try { BasicDataBLL bll = new BasicDataBLL(); return(bll.WX_BasicDataAdd(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }