/// <summary> /// 新增用车记录 /// </summary> //[AbpAuthorize(PermissionNames.VehUseRecord_CreateVehUseRecord)] public async Task <int> CreateVehUseRecord(VehUseRecordEditDto input) { //TODO:新增前的逻辑判断,是否允许新增 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into veh_userecord("); strSql.Append("Id,UseCompanyId,NumberPlate,Brand,GoOutDate,GoBackDate,DutyPerson,Contact,Description,IsDeleted,CreationTime,CreatorUserId)"); strSql.Append(" values ("); strSql.Append("@Id,@UseCompanyId,@NumberPlate,@Brand,@GoOutDate,@GoBackDate,@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)); } }
/// <summary> /// 更新用车记录 /// </summary> //[AbpAuthorize(PermissionNames.VehUseRecord_UpdateVehUseRecord)] public async Task <int> UpdateVehUseRecord(VehUseRecordEditDto input) { //TODO:更新前的逻辑判断,是否允许更新 StringBuilder strSql = new StringBuilder(); strSql.Append("update veh_userecord set "); strSql.Append("UseCompanyId=@UseCompanyId,"); strSql.Append("NumberPlate=@NumberPlate,"); strSql.Append("Brand=@Brand,"); strSql.Append("GoOutDate=@GoOutDate,"); strSql.Append("GoBackDate=@GoBackDate,"); 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)); } }