/// <summary>
/// 更新维保记录
/// </summary>
//[AbpAuthorize(PermissionNames.VehMaintenance_UpdateVehMaintenance)]
public async Task <int> UpdateVehMaintenance(VehMaintenanceEditDto input)
{
//TODO:更新前的逻辑判断，是否允许更新
StringBuilder strSql = new StringBuilder();
strSql.Append("update veh_maintenance set ");
strSql.Append("UseCompanyId=@UseCompanyId,");
strSql.Append("NumberPlate=@NumberPlate,");
strSql.Append("Brand=@Brand,");
strSql.Append("TripDistance=@TripDistance,");
strSql.Append("Date=@Date,");
strSql.Append("Type=@Type,");
strSql.Append("Costs=@Costs,");
strSql.Append("DutyPerson=@DutyPerson,");
strSql.Append("Contact=@Contact,");
strSql.Append("Description=@Description,");
strSql.Append("LastModificationTime=@LastModificationTime,");
strSql.Append("LastModifierUserId=@LastModifierUserId");
strSql.Append(" where Id=@Id ");
using (var conn = DBUtility.GetMySqlConnection())
{
input.LastModifierUserId = AbpSession.UserId;
return(await conn.ExecuteAsync(strSql.ToString(), input));
}
}
/// <summary>
/// 新增维保记录
/// </summary>
//[AbpAuthorize(PermissionNames.VehMaintenance_CreateVehMaintenance)]
public async Task <int> CreateVehMaintenance(VehMaintenanceEditDto input)
{
//TODO:新增前的逻辑判断，是否允许新增
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into veh_maintenance(");
strSql.Append("Id,UseCompanyId,NumberPlate,Brand,TripDistance,Date,Type,Costs,DutyPerson,Contact,Description,IsDeleted,CreationTime,CreatorUserId)");
strSql.Append(" values (");
strSql.Append("@Id,@UseCompanyId,@NumberPlate,@Brand,@TripDistance,@Date,@Type,@Costs,@DutyPerson,@Contact,@Description,@IsDeleted,@CreationTime,@CreatorUserId)");
using (var conn = DBUtility.GetMySqlConnection())
{
input.Id = Guid.NewGuid();
input.CreatorUserId = AbpSession.UserId;
return(await conn.ExecuteAsync(strSql.ToString(), input));
}
}
