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));
}
}
