public int AddEquipment(EquipmentEntity equipmentEntity)
{
string sql = @"INSERT INTO `ttl`.`ttl_engineering_equipment` (
`EquipmentName`,
`LastMaintenanceNames`,
`LastMaintenanceIds`,
`LastMaintenanceTime`,
`FixedAssetId`,
`Remark`,
`ScrapDate`,
`CreateUserId`
)
VALUES
(
@EquipmentName,
@LastMaintenanceNames,@LastMaintenanceIds,
@LastMaintenanceTime,
@FixedAssetId,
@Remark,
@ScrapDate,
@CreateUserId
);SELECT LAST_INSERT_ID();" ;
int insertId = _dbContext.ExecuteScalar <int>(sql, equipmentEntity);
if (insertId > 0)
{
_dbContext.Execute(@"INSERT INTO `ttl`.`ttl_engineering_equipment_log` (
`EquipmentId`,
`EquipmentName`,
`LastMaintenanceNames`, `LastMaintenanceIds`,
`LastMaintenanceTime`,
`FixedAssetId`,
`Remark`,
`ScrapDate`,
`CreateUserId`,`LogContent`,`IsDelete`
)
VALUES
(" + insertId +
@",@EquipmentName,
@LastMaintenanceNames,@LastMaintenanceIds,
@LastMaintenanceTime,
@FixedAssetId,
@Remark,
@ScrapDate,
@CreateUserId,'添加设备',0
);" , equipmentEntity);
}
return(1);
}
