/// <summary> /// 新增电厂 /// </summary> //[AbpAuthorize(PermissionNames.InfStation_CreateInfStation)] public async Task <int> CreateInfStation(InfStationEditDto input) { //TODO:新增前的逻辑判断,是否允许新增 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into inf_station("); strSql.Append("Id,ZoneId,TypeId,StationName,ProductionTime,OwnershipRatio,MachineNumber,MachineModel,MachineCapacity,CreationTime,CreatorUserId,IsDeleted)"); strSql.Append(" values ("); strSql.Append("@Id,@ZoneId,@TypeId,@StationName,@ProductionTime,@OwnershipRatio,@MachineNumber,@MachineModel,@MachineCapacity,@CreationTime,@CreatorUserId,@IsDeleted)"); using (var conn = DBUtility.GetMySqlConnection()) { input.Id = Guid.NewGuid(); input.CreatorUserId = AbpSession.UserId; return(await conn.ExecuteAsync(strSql.ToString(), input)); } }
/// <summary> /// 更新电厂 /// </summary> //[AbpAuthorize(PermissionNames.InfStation_UpdateInfStation)] public async Task <int> UpdateInfStation(InfStationEditDto input) { //TODO:更新前的逻辑判断,是否允许更新 StringBuilder strSql = new StringBuilder(); strSql.Append("update inf_station set "); strSql.Append("ZoneId=@ZoneId,"); strSql.Append("TypeId=@TypeId,"); strSql.Append("StationName=@StationName,"); strSql.Append("ProductionTime=@ProductionTime,"); strSql.Append("OwnershipRatio=@OwnershipRatio,"); strSql.Append("MachineNumber=@MachineNumber,"); strSql.Append("MachineModel=@MachineModel,"); strSql.Append("MachineCapacity=@MachineCapacity,"); 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)); } }